Creating Your Own TableLook in IBM SPSS Statistics - dummies

Creating Your Own TableLook in IBM SPSS Statistics

By Keith McCormick, Jesus Salcedo, Aaron Poh

Editing pivot tables in SPSS Statistics can be easy if there is an existing TableLook that you like. But what if none of the SPSS TableLooks is exactly what you, or your boss, or your professor, or your colleagues want?

You may know how to make the changes, but did you know that you can then save all your work in the form of a brand-new TableLook of your very own?

Take a look at the following figure, which is a Compare Means report with a minor modification made in the menus. It displays only the mean, not the other default statistics.

Compare Means Report with default TableLook.

Compare Means Report with default TableLook.

Say you want to make a series of aesthetic changes. These aren’t necessarily better settings, but you like them and maybe they better resemble other aspects of your report. For example, say you want to do the following:

  • Make the font bigger, at 12 instead of 9.

  • Change the font to Calibri.

  • Widen the column labels.

  • Change the way the row labels are arranged and add a new line separating the row labels.

  • Make the corner area gray.

Instead of just making these changes and moving on to another table to edit, take a moment to save your work as a new TableLook so you don’t have to make these changes again! Watch out because not everything you modify will be saved as part of the TableLook.

Try to limit your changes to those in the Table Properties menu. Saving the new Look is easy — just return to the TableLook menu, shown in the following figure, after making the changes and click Save As.

The TableLooks menu.

The TableLooks menu.

Next time you need this TableLook, just take any pivot table and go find your TableLook. Apply your personal TableLook. Then just click Open.

Apply your new TableLook.

Apply your new TableLook.

The table will now have the look of your new TableLook, as shown in the following figure.

Modified table with new TableLook.

Modified table with new TableLook.