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

Excel in Practice

The type of formatting you apply to a worksheet depends largely on its use and who will be seeing it. For worksheets that only you will see, formatting probably will be restricted to things that make the worksheet easier to read, such as increasing font size for onscreen viewing.

Worksheets that are shared with others often are formatted for clarity, visual impact, and a professional look. In some cases, you'll spend more time formatting than you did entering the data! To make the most of Excel's formatting tools without taking a lot of time, keep things simple (see Figure 5.51). Use shading to improve clarity and draw attention to important data, use borders and boldface to set column or row headings apart, and use fonts sparingly—you'll save time choosing them, and the worksheet won't look too “busy.” It's a good idea to use the same formatting on many (if not all) of the worksheets—this strategy can help your work have a signature look that people will associate with you.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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