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

Chapter 5. Formatting and Printing > Applying and Drawing Borders and Shading

Applying and Drawing Borders and Shading

You can apply borders from the Format Cells dialog box, which you find by choosing Cells from the Format menu and clicking the Borders tab. Another method is involves clicking the downward pointing arrow to the right of the Borders button on the Formatting toolbar and selecting a border to apply from those shown. You can also draw borders with the new Draw Borders command from the Formatting toolbar. To access the Draw Borders command, select the Borders drop-down arrow and click Draw Borders.

Notice Figure 5.13, when the worksheet is filled with white to create a canvas affect (or when gridlines are disabled), Excel plots the corners of each cell when the Draw Borders command is selected. When you select the Draw Borders command, the cursor turns into a pencil and allows you to apply borders one click at a time or by holding down the left mouse button, you can draw borders around several cells at once. Briefly, you turn off the borders by clicking the Draw Border button or by pressing the Esc key. Using borders and/or shading in worksheets is an effective method for enhancing and improving a worksheet’s appearance and highlighting important information.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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