Microsoft Office Tutorials and References
In Depth Information
Table Design Principles
Figure 2-2 shows a table with the colors removed. As you can see, it’s already easier to read.
Figure 2-2: Remove unnecessary cell coloring.
To remove color from cells in a table, first highlight the cells, and then go to the Ribbon and select
Home ➜ Theme Colors. From the Theme Colors drop-down menu, select No Fill (see Figure 2-3).
Figure 2-3: Use the No Fill option to clear cell colors.
Believe it or not, borders get in the way of quickly reading the data in a table. This is counterintuitive
to the thought that borders help separate data into nicely partitioned sections. The reality is that the
borders of a table are the first thing your eyes see when looking at a table. Don’t believe it? Try
standing back a bit from an Excel table and squint. The borders will pop out at you.
De-emphasize borders and gridlines wherever you can:
➤ Try to use the natural white space between the columns to partition sections.
➤ If borders are necessary, format them to lighter hues than your data.
➤ Light grays are typically ideal for borders. The idea is to indicate sections without distracting
from the information displayed.