How to Make a Grid on Excel: Fastest Ways to Do It

You might be wondering what Grid lines are and how exactly do they help us in using Microsoft Excel? These faint lines basically serve the purpose of dividing cells in a worksheet. However, I should let you know that they’re different from cell borders.

These grids help to clearly distinguish the rows, and columns of the worksheet that you’re working on. Not only that, but these can actually help you read and understand the data that’s on the worksheet.

So, if you’re wondering how to make a grid on Excel, you’ve just hit the jackpot. In this one, we’ll be talking about what Grid lines are, how they work, and how you can use them. So, let’s get into it straight away.

What are Gridlines in Excel?

Well, Gridlines are seen as dotted lines that are used to visually separate cells from each other in Excel worksheets. Note that these lines are quite faint when it comes to visibility. The Gridlines option can be found under the Page Layout tab.

If you want to turn them on, all you have to do is, check the box. Similarly, you have to uncheck the box to turn Gridlines off.

What Exactly Do They Do?

Well, now that we know what Grids in Excel are, let’s point out the purpose they serve.

  • These lines help to separate data in computational programming which is used to track/keep records or valuable information.
  • Gridlines are horizontal or vertical lines that create a visual representation of separation. These really do help in distinguishing data. This helps to organize and categorize data better.
  • Since the thickness, color, and pattern of Gridlines can be customized according to user needs, they can accommodate to user preferences.

Quickest Ways to Add a Grid on Excel

Let’s divide the procedures based on the Operating system, shall we? It’s possible to enable Grid lines on both Mac and Windows. Just follow the steps that I’m about to describe below:

 Enabling Gridlines on Windows

As you open a workbook, the Gridlines should be there by default. However, you can enable or disable them in any particular worksheet using the settings option. Here’s how to do it:

  • Firstly, you have to go to the File menu on the top left side of the ribbon.
  • Select Options and the Excel Options window should pop up.

Enabling Gridlines on Windows 1

  • Over there, you’ll need to go to Advanced in the panel on the left.
  • Scroll down to find the”Display options for this worksheet”  It’s located just below the “Display options for this workbook” group on the right panel.
  • There, you’ll want to check “Show Gridlines”.

Enabling Gridlines on Windows 2

  • You can even select the color in the Gridline color option.
  • After pressing Ok, the Gridline should appear in the chosen worksheet.

Enabling Gridlines on Mac

Just like before, open the Excel workbook. Go to the sheet that you want to add the Gridlines in. Then, follow the steps:

  • Go to the Page Layout tab.
  • Then check the box that’s beside “View” under the “Gridlines” panel.

Enabling Gridlines on Mac 1

  • If you want to see the Gridlines in the printed copy, check on Print as well.

Enabling Gridlines on Mac 2

  • That’s pretty much all you need to do in order to see the Gridlines in Excel.

The Benefits and Drawbacks of Gridlines in Excel

Now that we’ve discussed how to make Gridlines appear in Excel, let’s take a look at the pros and cons that they have to offer.

Pros Cons
Gridlines are fairly customizable. You can choose the thickness, color, and the pattern. The Gridline colors are too light to be noticed easily.
Gridlines can easily be enabled or disabled. Gridlines are enabled by default and requires unchecking an option to remove them.
It really helps out in organizing data.
This doesn’t require any additional settings or external software.

Parting Tips

Let’s share some handy tips before we part ways. These small pointers should help you quite a bit regarding the usage of Gridlines.

  • “ALT+W+VG” is the shortcut that can be used to make Gridlines appear or disappear.
  • If you want to use an alternate method to hide Gridlines, you can just apply the “No fill” background color in the worksheet.
  • It’s a wise idea to remove the Gridlines once our work is done. As it’s quite confusing to know whether we’ve hidden the Gridlines or not.

Final Words

If you’ve gone through the whole thing, you’ll agree with me that hiding or enabling Gridlines isn’t all that hard. You just have to go through a few options and check or uncheck the right boxes. Enabling Gridlines is far easier in Mac to be honest. But hey, it all comes down to personal preference.

With that said, let’s close this one up for now. Farewell!

See Also:

Leave a Comment