2 Quick Ways to Insert Cell Borders or Gridlines in Excel

PDF download Download Article
A complete guide to adding borders around cells in Microsoft Excel
PDF download Download Article

If you want to make your data easier to read in Excel, you can add borders around the cells. Borders can be applied around each cell or around a chart. This is different from gridlines, which are the light grey lines separating each cell. Here's how to insert borders in Excel using your Windows or Mac computer.

Applying Cell Borders in an Excel Worksheet

To add borders in Excel, highlight the data. Click the Home tab and click the arrow next to the Borders icon. Select a border icon to apply it. To print with the default gridlines, go to Page Layout → Sheet Options → check the box for Print underneath Gridlines.

Method 1
Method 1 of 2:

Inserting Borders

PDF download Download Article
  1. Open a worksheet in Microsoft Excel . You can use an existing project or create a new spreadsheet.
    • Borders are added manually and can be customized, unlike gridlines. If you have multiple pages of data that you need to print , consider using gridlines instead.
  2. You will be able to add a border that surrounds the entire selected range, and/or around each individual cell in the range. [1]
    Advertisement
  3. It's at the top of Excel.
  4. The Borders icon is a dotted grid on the "Font" panel at the top of Excel. A list of border styles will appear.
  5. If you want to add darker grid lines surrounding each selected cell, choose All Borders . Otherwise, choose any of the other options, such as Thick Outside Borders , which adds one solid border around the selected range.
    • To remove cell borders, select the cells again. Click the arrow next to the Borders icon in the toolbar, and then choose No Border .
    • Unlike gridlines, cell borders are always shown on printed sheets.
    6. Advertisement
Method 2
Method 2 of 2:

Inserting Gridlines

PDF download Download Article
  1. You can use an existing project or create a new spreadsheet . [2]
    • Gridlines can't be customized in the same way borders can.
  2. This is the tab at the top.
    • If you're using Excel for Mac, click Page Layout instead.
  3. This will be between the Workbook Views and Zoom sections.
    • You should see a list of options, such as Ruler, Gridlines, Formula Bar, etc.
  4. When this box is checked, you'll see the gridlines appear on your Excel worksheet.
    • On Mac, check the View box underneath Gridlines . To print the gridlines, check the box for Print .
  5. Gridlines do not print by default. If you want to print a spreadsheet with the gridlines on, do the following:
    • Click the Page layout tab at the top.
    • Find the Sheet Options section.
    • Check the box next to Print underneath Gridlines .
    6. Advertisement

Expert Q&A

Ask a Question
200 characters left
Include your email address to get a message when this question is answered.
Submit
      Advertisement

      Tips

      Submit a Tip
      All tip submissions are carefully reviewed before being published
      Name
      Please provide your name and last initial
      Submit
      Thanks for submitting a tip for review!

      wikiHow Video: How to Insert Borders in Excel

      Watch


      You Might Also Like

      How to
      Merge Cells in Microsoft Excel: A Quick Guide
      How to
      Unprotect an Excel Sheet
      How to
      Unhide All Rows and Columns in Microsoft Excel
      How to
      Use If‐Else in Microsoft Excel: Step-by-Step Tutorial
      How to
      Insert Pictures in Excel That Automatically Size to Fit Cells
      How to
      Create a Mortgage Calculator With Microsoft Excel
      How to
      Create a Graph in Excel
      How to
      Show Hidden Columns in Microsoft Excel & Unhide Column A
      How to
      Fix Ethernet Doesn't Have a Valid IP Configuration on Windows
      3 Easy Ways to Freeze Panes to Lock Columns or Rows in Excel
      How to
      Change from Lowercase to Uppercase in Microsoft Excel
      How to
      Make a Spreadsheet in Excel
      New to Excel? Here's Super Easy Tricks to Get You Started
      How to
      Link Sheets in Excel
      Advertisement

      References

      1. ↑ https://support.microsoft.com/en-us/office/apply-or-remove-cell-borders-on-a-worksheet-dc8a310b-92e3-46a7-9f17-2ab745810f4a
      2. ↑ https://support.microsoft.com/en-us/office/create-a-new-workbook-ae99f19b-cecb-4aa0-92c8-7126d6212a83

      About This Article

      Article Summary X

      To insert borders in excel, open your excel document and select the cells where you would like to add a border. Click the down arrow next to the Borders button on the Home tab which is located next to the Fonts group button. Then, select the border type from the dropdown menu.

      Did this summary help you?
      Thanks to all authors for creating a page that has been read 44,983 times.

      Is this article up to date?

      Advertisement