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

Chapter 5. Formatting and Printing > Why Change the Formatting?

Why Change the Formatting?

You could build an entire workbook with no special formatting at all. Excel’s default styles, fonts, alignments, and other settings for text and numbers are sufficient for the legible and accurate display and printing of worksheet data. Why change formatting? Although Excel offers a logical grid format, your data often reads better with formatting. This includes creating bold headings to your lists as well as coloring text and worksheet cells. When you first open a workbook, it displays the default lines between columns and rows in Excel. If you don’t want the row and column lines, you can select the entire worksheet and then fill the worksheet with the color white. This gives you a clean canvas with which to start. An alternative method is to select the Tools menu and choose Options, and then select the View tab. Under the Window Options on the View tab deselect Gridlines.

Tip From

As a habit, before I ever start creating a worksheet or workbook, I fill the worksheets with white to create a canvas. In terms of creating a painting, it allows you to start with a clean, blank slate.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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