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

Part 3. Using Excel > Task 21 How to Work with Borders and Patterns

Task 21 How to Work with Borders and Patterns

The gridlines you see in your Excel worksheets are a little misleading. Normally, these lines do not print, and if you do print them, they might appear faint. To give your cells well-defined lines, use Excel's Border options. You can choose to add a border to a single cell or to an entire range. You can specify a border on only one side of a cell or border the entire cell. If borders don't set off your cells to your satisfaction, try adding a background pattern, such as a color blend, a pattern effect, or a solid color fill. Keep in mind, however, that a background that's too busy will make it difficult for the reader to see your data.

  1. Open the Format Cells Dialog Box

    Select the cell or range to which you want to add a border or pattern, Choose Format, Cells to open the Format Cells dialog box.



  2. Set a Line Style

    Click the Border tab. From the Style list, choose a border style. Use the Color drop-down list to select a border color.




PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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