How to Hide Gridlines in Microsoft Excel | TechBuzz

- Advertisement -


Gridlines on Microsoft Excel make organizing and working with data easier. It lets you apply formulas and manipulate data in countless ways, but there may be times when you don’t need those gridlines.

Perhaps, you might want the data in the worksheet sans the gridlines for a presentation or printing. Whatever your reason, we’re going to tell you how you can make those gridlines vanish with a few clicks.

1. How to Hide Gridlines From the View Tab

Excel has a built-in method for hiding the gridlines. When you’re in an Excel worksheet, click on the View tab in the ribbon at the top. Search for Gridlines in the Show group and uncheck the box next to it.

- Advertisement -

When you do this, you’ll see the gridlines disappear from your worksheet. You’ll still see the outline of a cell when you select it, though. If you want to bring the gridlines back, just check the box next to Gridlines in View > Show.

2. How to Hide Gridlines Using a Shortcut

There’s a nifty shortcut to hide gridlines if you’re running Windows. Press Alt + W + V + G and that should hide the gridlines from your worksheet. Press the same shortcut to bring the gridlines back.

3. How to Hide Gridlines by Filling Color

This is a handy method when you want to hide the gridlines for only a section of the worksheet. The built-in option wipes gridlines off the entire worksheet, but when you fill color, you’ll have the option to select specific cells.

MAKEUSEOF VIDEO OF THE DAY
- Advertisement -

Start by selecting the section of the worksheet where you want to hide the gridlines. If you want to hide cells for the entire worksheet, press Ctrl + A to select all cells.

Select the fill tool from the Home tab > Font group. Apply the color white. Doing this should have the same effect as hiding gridlines using the built-in option when you apply the color white to all cells.

4. How to Hide Gridlines With VBA

- Advertisement -

In most cases, you’ll be better off with the previous methods of hiding gridlines because they’re simple. However, sometimes, you might need to use VBA to hide gridlines. Perhaps, you’re using macros in Excel for a task. And as part of that task, you need a code that will hide the gridlines.


Here’s a VBA code that will help you hide gridlines on Excel:

  1. To run a VBA code, you need to press Alt + F11 when you’re in the worksheet. Doing this will open the VBA code editor.
  2. Select Insert > Module in the editor.
  3. Paste the code and press F5.

Go back to the worksheet. It should now be blank.

5. How to Hide Gridlines When Printing

Gridlines look great on the screen. It makes organizing the data easier. But on paper, they can get in the way. Fortunately, there’s a way to print Excel sheets without the gridlines.

To do this, go to the Page Layout tab from the ribbon at the top. Look for the Sheet Options group and uncheck the box next to Print under Gridlines.

Gridlines No More

Gridlines are an excellent visual tool when used the right way. Sometimes, you can do without them. Getting them out of the way can make working with the sheet easier, or help you make it more presentable, depending on the elements you’re adding to your worksheets.

Fortunately, Excel lets you hide gridlines and offers a ton of other formatting options and features. For instance, did you know that you can print vertically formatted spreadsheets beautifully on a single page?


An illustration of a person thinking of Excel spreadsheets
How to Print an Excel Spreadsheet on One Single Page

Read Next


About The Author



Source link

- Advertisement -
Adminhttp://techbuzz.asia
I am admin of techbuzz.asia blog & I provide tech-related news. As a part of my hobby, I make content related to technology and gadgets reviews too. I love to be a content creator apart from it, I am a full-time employee in an MNC company and manage blogs systematically. You can mail me at [email protected]

More from author

Related posts

Advertisment

Latest posts

Xiaomi Mega Bundle: Redmi Note 11, Earbuds & 10 GB for less than €13/month | TechBuzz

Are you looking for a powerful smartphone including a tariff at a reasonable price? In the Curved Shop you can get the Xiaomi...

WWDC: macOS Alcatraz? | TechBuzz

The name macOS Alcatraz was, of course, just a joking name for Apple's next operating system. Nevertheless, in this issue we also speculated about...

Windows 11 version 22H2 – a new major update coming to us in the second half of the year | TechBuzz

Microsoft is currently working intensively on a new version of Windows known as 22H2 version and codenamed Sun Valley 2. This is the...

Want to stay up to date with the latest news?

We would love to hear from you! Please fill in your details and we will stay in touch. It's that simple!