How to change the look of a table

March 17th, 2006

The look and feel of your tables are a critical part of providing clear, concise, and meaningful results. For example, if your table is difficult to read, the information contained within that table may not be easily understood.

In this log we will introduce the tablelook option in SPSS.

Double-click the table.

From the menus choose: Format > Tablelook

The TableLooks dialog box lists a variety of predefined styles. Select a style from the list to preview it in the Sample window to the right.
You can use a style as is, or you can edit an existing style to better suit your needs. To use an existing style, select one and click OK.

Although you can change the format of a table after it has been created, it may be more efficient to change the default TableLook so that you do not have to change the format every time you create a table. To change the default TableLook style for your pivot tables, from the menus choose:

Edit > Options> Pivot Tables

Select the TableLook style that you want to use for all new tables. Click OK to save your settings and close the dialog box. All tables that you create after changing the default TableLook automatically conform to the new formatting rules.

(Source: SPSS 12.0 Brief guide)

Entry Filed under: 4. Modifying SPSS output,Questions and answers


  • 1. Amber Parillo  |  January 4th, 2007 at 9:55 am

    I was wondering if you know of any way that you are able to change the actual output on the tables. I’m specifically thinking of frequency tables…rather than having Frequency, Percent, Valid Percent, Cummulative Percent, I would prefer to tailor my output to only show Valid Percent, Cummulative Percent and THEN Frequency. If you could help me, that would be great, thanks!

  • 2. Mark  |  January 5th, 2007 at 2:22 am

    Yes, this is possible! Use the tables module:
    Analyze-Tables-Basic Tables
    Here you can change the actual output on the tables.

  • 3. Ann  |  February 10th, 2008 at 12:59 am

    I want to shrink columns, reduce font size, anything to get the table smaller so I can print an entire table on one page. The font is huge and I don’t know how to reduce column width, especially the Left column with table title and variables.

  • 4. Andris  |  February 11th, 2008 at 3:35 am

    @Ann: Please ask your question at, there are a lot of SPSS users over there who are able to help out! :-)


March 2006
    Apr »

Most Recent Posts