• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Gridlines in Excel

August 16, 2021 by Andrew Childress

As soon as you open Excel, you're bound to notice the grid. Let's learn more about gridlines in Excel and how to control them.

As soon as you open Excel, you’re bound to notice the grid. It’s the series of lines that create the grid that stores all of our data. Rows and columns connect to form cells, with gridlines separating each cell.

So, how do you control gridlines in Excel? Maybe you don’t want to see them all the time, after all. Let’s learn more about gridlines in Excel and how to control them.

Hide and Show Gridlines in Excel

By default, you’re going to see gridlines in Excel. But, you can also turn them off if you want your spreadsheet to be “cleaner” with fewer lines. Find the View menu on Excel’s ribbon, then click on Gridlines to toggle the dividing lines off and on.

Gridlines in Excel toggle

That’s all there is to it. This doesn’t actually change the spreadsheet, (such as turning cell borders off or on) it simply alters the spreadsheet’s view options.

How to Make Your Own Gridlines in Excel

If you toggled the gridlines off for a cleaner spreadsheet, you might be asking yourself: “how do I add back some of the gridlines without covering the entire spreadsheet?”

In this case, it helps to use table borders to create our own grid. Take the example below. It’s a clean spreadsheet because it includes plenty of whitespace and doesn’t have too many borders. But, it can be hard to follow data across the page. Let’s use cell borders to create our own gridlines.

No gridlines in table Excel

First, start by highlighting the data that you wish to surround with borders. Then, click on the dropdown for Borders as you see in the screenshot below. Choose a bordering option, and your data is surrounded with gridlines.

Add borders table gridlines

If you want to learn how to print gridlines in Excel, we’ve got you covered with another tutorial. Check out Print Gridlines in Excel to control how the grid shows in a printed or PDF-exported copy.

Category: Excel FunctionsTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:Subtotal at each changeSubtotals in Excel
Next Post:Highlight Cells Rules in ExcelHighlight conditional formatting in Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top