Formatting Excel Workbooks & Worksheets
Preparing clear and readable analyses is a little like a work of art. Selecting the correct size paper, colors, line styles, font, font size, font type, font color, and general sheet information is key to helping the reader understand the purpose of the worksheet/analysis.
This guide will provide tips for formatting Excel worksheets including fonts, alignment, number formatting, margins, orientation, paper sizes, setting print area, page breaks, printing titles (header and footer), viewing and printing gridlines and headings.