3 Excel (2007) Formatting Tricks

SpreadsheetExcel is a great business tool! Although, it has many features the common user is unaware of, but could greatly benefit from!

Here are a few tips on formatting that I use regularly;

  1. Table Formatting – Formatting your information as a table gives you added features such as; predesigned templates, filters, and easily adding rows or columns. 
    • To do this: Select the information in your spreadsheet. Navigate to the Home Ribbon, where you will find the ‘Format as Table’ button in the Styles Group. Choose your preferred style.
  2. Print on 1 Page – Adjusting your printing options to 1 page width is easily done and can make a huge difference in readability!
    • To do this: Navigate to the Page Layout Ribbon, where you will find the ‘Scale to Fit’ group. In that group, you can choose how to alter how your spreadsheet prints widthwise or lengthwise by choosing the number of pages you wish to span.
  3. Hide Cells – Hiding confusing (or unnecessary) information can make your spreadsheets much more user-friendly! You can hide columns, rows, or even whole spreadsheets in a workbook.
    • To do this: Right click on the column heading, row heading, or page tab that you would like to hide. From the shortcut menu, choose ‘Hide’.
    • To unhide, simply right-click and choose ‘Unhide’.


For more tips and tricks with using Excel, please feel free to contact us at Office Solutions ME!


2 thoughts on “3 Excel (2007) Formatting Tricks

  1. I can’t live without excel – especially for alphabetizing and adding columns of $! I’ll check these tips out too and someday learn how to input a formula 🙂

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s