• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 20. Advanced Worksheet Formattin... > Designing and Formatting a Worksheet...

Designing and Formatting a Worksheet for Maximum Readability

If you simply enter data into a worksheet, every cell will look exactly the same, and you'll force anyone reading the worksheet to work to pick out the important details. Set off different regions of a worksheet by using custom cell formatting—larger, bolder fonts for headings, for example, plus borders around the data area with a double line to mark where the data range ends and the totals begin. Carefully resetting row heights and column widths, wrapping and slanting text, and adding background shading can make the entire sheet easier to follow.

Changing Fonts and Character Attributes

The default worksheet font (10-point Arial) is fine for basic data entry, but for any worksheet more complex than a simple list you'll probably want to adjust fonts to squeeze more data onto printed pages while beefing up titles, totals, and category headings with larger, bolder fonts.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint