Clearer table formatting than Microsoft auto-format


Office for Mere Mortals
Your beginners guide to the secrets of Microsoft Office
Invalid email address
Tips and help for Word, Excel, PowerPoint and Outlook from Microsoft Office experts.  Give it a try. You can unsubscribe at any time.  Office for Mere Mortals has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy

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:

http://img.office-watch.com/ow/Clear%20off%20the%20table%201.png image from Clearer table formatting than Microsoft auto-format at Office-Watch.com

And changes it to this:

http://img.office-watch.com/ow/Clear%20off%20the%20table%202.png image from Clearer table formatting than Microsoft auto-format at Office-Watch.com

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.

subs profile e1563205311409 - Clearer table formatting than Microsoft auto-format
Latest news & secrets of Microsoft Office

Microsoft Office experts give you tips and help for Word, Excel, PowerPoint and Outlook.

Give it a try. You can unsubscribe at any time.  Office Watch has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy
Invalid email address