How to Make a Grid in Excel?

  • Home
  • / How to Make a Grid in Excel?

Have you just received an important file from your colleague but after opening it you’ve realized that there are no grids in it? Or have you just accidently hid the gridlines and now can’t get them back? If that’s so, don’t worry, it happens most of the time.

Lucky for you, it is very easy to make grids visible in Excel again. You just have to follow a few simple steps and you’ll be good to go. So, without further ado, let’s get started!

Introduction to Excel Grids                      

In Excel, there are two types of grids: worksheet grids and chart grids.

  • Worksheet grids are the ones you’re probably most familiar with.
  • They’re the rows and columns that make up your spreadsheet. Chart grids are used for creating charts and graphs. Both types of grid have their own set of rules.

You can then use the grid to perform calculations or visualize data in various ways. For example, you could create a bar chart to show how sales have increased over time.

Or you could use a formula to calculate the average price of a product. The possibilities are endless!

However, there are some projects that need to be done without grids, or some people simply doesn’t want to show the grids in their worksheet and hence hide them, which is not very pleasing to the ones that receive that file.

So if you’re new to Excel, make sure you get familiar with the grid system and how to show and hide gridlines in your worksheet. It’s the foundation on which all your spreadsheet wizardry will be built.

Showing Gridlines in Excel – A Detailed Step-Wise Guide

Now that you know what grids are and why they’re important, let’s move on to the main part of this article – how to show gridlines in Excel.

Just follow the steps below and you’ll have those grids back in no time!

Step 1:

First things first, open up the worksheet from which you want to show the gridlines.

Step 2:

Once your file is open, locate and click on the ‘View’ tab present in the topmost menu bar. This will allow access to many more advanced features.

Step 3:

After clicking on the ‘View’ tab, you should see a number of options appear in a drop-down menu. Scroll down until you find the ‘Show’ group. In this group, there is a checkbox next to the ‘Gridlines’ option.

Step 4:

Click on this checkbox to select it and show the gridlines in your Excel worksheet.

Step 5:

If the checkbox is already selected, then this means that the gridlines were previously visible but got hidden somehow. In that case, simply uncheck and recheck the box to make the gridlines appear again.

And that’s it! These were the five simple steps you need to follow in order to show gridlines in Excel.


So there you have it, a simple way to show a grid in Excel. This method can be great for visualizing data or creating a custom background for your worksheet. With a little practice, you’ll be able to show and hide the gridlines easily. Thanks for reading!

Write your comment Here