3 Easy Ways Add Grid Lines to Your Excel Spreadsheet

PDF download Download Article
Learn how to enable and show gridlines on a worksheet in Excel
PDF download Download Article

Grid lines, which are the faint lines that divide cells on a worksheet, are displayed by default in Microsoft Excel. You can enable or disable them by worksheet, and even choose to see them on printed pages. These are different from cell borders, which you can add to cells and ranges and customize with line styles and colors. Here's how to add grid lines to your Excel spreadsheet on Windows and Mac computers.

Showing Gridlines in Excel for Windows

  • To display the default gridlines on your Excel worksheet, click View at the top. Find the Show section and check the box for Gridlines . [1]
  • To print the gridlines, click Page Layout → Sheet Options → check the box for Print underneath Gridlines . [2]
  • For more border customizations, add a cell border to your data instead.
Method 1
Method 1 of 3:

Enabling Gridlines (Windows)

PDF download Download Article
  1. Open a worksheet in Microsoft Excel . You can use an existing project or create a new spreadsheet . [3]
    • Gridlines can't be customized in the same way borders can. For more customization options with cell borders, see this section .
  2. This is the tab at the top.
    Advertisement
  3. This will be between the Workbook Views and Zoom section.
    • You should see a list of options, such as Ruler, Gridlines, Formula Bar, etc. [4]
  4. When this box is checked, you'll see the gridlines appear on your Excel worksheet. [5]
    • Gridlines do not print by default. If you want to print 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 .
    5. Advertisement
Method 2
Method 2 of 3:

Enabling Gridlines (Mac)

PDF download Download Article
  1. You can use an existing project or create a new spreadsheet.
  2. This is in the top toolbar.
  3. This will be underneath Gridlines . When this box is checked, you'll see the gridlines appear on your Excel worksheet. [6]
    • If you want to print with the gridlines on, check the box next to Print .
    4. Advertisement
Method 3
Method 3 of 3:

Adding Cell Borders

PDF download Download Article
  1. You can use an existing project or create a new spreadsheet.
    • Gridlines appear on all sheets by default, but they may not be bold enough to make your data stand out. If you want to surround certain data with more visible lines, you can add borders to those cells.
  2. You will be able to add a border that surrounds the entire selected range, and/or around each individual cell in the range. [7]
  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 that surround each selected cell, choose All Borders . Otherwise, choose any of the other options, such as Outside Borders , which adds one solid border around the selected range. [8]
  6. Now that you've inserted some cell borders, you can customize how they look.
  7. It's at the bottom of the menu.
  8. You can customize the line style, border style, and even color. [9]
    • To customize the actual line used in the border (such as changing a solid line to a dotted line), select one of the line styles from the Styles area.
    • To make the border a different color, choose a color from the Color menu.
  9. This adds your border preferences to the selected range.
    • To remove cell borders, 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.
    10. 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

      Video

      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!

      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
      How to
      Link Sheets in Excel
      New to Excel? Here's Super Easy Tricks to Get You Started
      Advertisement

      References

      1. ↑ https://support.microsoft.com/en-gb/office/show-or-hide-gridlines-on-a-worksheet-3ef5aacb-4539-4ad5-9945-5ed53772dc4d
      2. ↑ https://support.microsoft.com/en-gb/office/print-gridlines-in-a-worksheet-fdb32f2a-8a5a-41fe-a5b0-0a734fdfade1
      3. ↑ https://support.microsoft.com/en-us/office/create-a-new-workbook-ae99f19b-cecb-4aa0-92c8-7126d6212a83
      4. ↑ https://support.microsoft.com/en-us/office/show-or-hide-gridlines-on-a-worksheet-3ef5aacb-4539-4ad5-9945-5ed53772dc4d#OfficeVersion=Windows
      5. ↑ https://support.microsoft.com/en-us/office/show-or-hide-gridlines-in-word-powerpoint-or-excel-47b1189c-f867-479e-a208-34ee54055f6f
      6. ↑ https://support.microsoft.com/en-gb/office/show-or-hide-gridlines-on-a-worksheet-3ef5aacb-4539-4ad5-9945-5ed53772dc4d#OfficeVersion=macOS
      7. ↑ https://support.microsoft.com/en-us/office/apply-or-remove-cell-borders-on-a-worksheet-dc8a310b-92e3-46a7-9f17-2ab745810f4a
      8. ↑ https://support.microsoft.com/en-us/office/apply-or-remove-cell-borders-on-a-worksheet-dc8a310b-92e3-46a7-9f17-2ab745810f4a
      9. ↑ https://support.microsoft.com/en-us/office/apply-or-remove-cell-borders-on-a-worksheet-dc8a310b-92e3-46a7-9f17-2ab745810f4a

      About This Article

      Article Summary X

      1. Click the File menu and select Options .
      2. Click Advanced .
      3. Select the sheet from the "Display options for this worksheet" menu.
      4. Check the box next to "Show gridlines."
      5. Click OK .

      Did this summary help you?
      In other languages
      Thanks to all authors for creating a page that has been read 140,694 times.

      Is this article up to date?

      Advertisement