Office for Mere Mortals helps people around the world get more from Word, Excel, PowerPoint and Outlook. Delivered once a week. free.
Some great tips on table formatting.
Joey Cherdarchuk has a nice posting on a very different table styling to the type that Microsoft prefers.
Under the banner ‘Clear Off the Table’ he suggests getting rid of gridlines and colors to simplify the look of tables. In his example, Joey takes a standard Microsoft auto formatted table like this:
And changes it to this:
There’s a slide deck which goes through the steps:
- Remove the colors
- Remove gridlines
- Remove Fills
- Remove the border
- Remove bolding
- Left Align Text
- Right Align Numbers/Dates
- Align Titles with Data
- Resize columns to data
- Put whitespace to work
(put gaps between groups)
- Use consistent precision
- Round the numbers
- Remove Repetition
- Please no more Calibri
(he uses another san-serif font – Open Sans since Calibri shows up in tables way too often)
- Add back the emphasis
In the blog comments Joey remarks that alternate row colors have a place when the row groups are larger. Certainly alternate coloring makes it easier for the eye to move accurately along a line, but they aren’t always necessary.
- 8 ways to improve on Word’s Table Styles
- Word tables for formatting magic
- Word Count / Table cell bug in Word
- How to convert Excel tables to HTML tables
- Creating Instant Tables in Excel
- Table tricks in Word 2003
Office Watch has the latest news and tips about Microsoft Office. Independent since 1996. Delivered once a week.