Excel Hide Gridlines How To Remove Them

Once you finish, the changes to the document will apply to the online version too.

When you open a blank worksheet, the first thing youll see are these transparent lines that define the position of the cells.

Although this is generally convenient and useful, you may need to work on sheets where gridlines are unnecessary and can even interfere with your work.

Luckily, you can easily remove the gridlines regardless in any version of Excel.

Excel Hide Gridlines How To Remove Them

This article will show you how to remove them depending on the platform that you use.

How to Hide Gridlines in Windows You can hide the gridlines in Microsoft Excel for Windows in a few simple steps.

Regardless of the version that youre using (365, 2007, or older), the process is the same.

Find the Show section (or ShowHide if youre using Excel 2007) Untick the Gridlines option.

This should remove the transparent lines behind your document and make it blank.

Removing Grids from Multiple Sheets in Excel 365 If you have Microsoft Excel 365, you can remove the grid from multiple worksheets.

When you choose two or more sheets, youll see Group written next to the title on the top of the page.

Printing the Grids If you wish to print the Excel document, the grids wont show up on the printed sheet.

Select Print. Click on the Page Setup (Page Layout in some versions).

Tick the Gridlines box under the Print section.

Press OK. Now all of your Microsoft Excel sheets will be printed with the gridlines included.

How to Hide Gridlines in MacOS Hiding gridlines in MacOS is very similar to the Windows version.

If you have Excel for Mac 2012 and above, you should follow these steps: Open the Excel app.

If youre using Excel for Mac 2011, the process is slightly different: Select the sheet.

How to Hide Gridlines in Online Excel The web version of Microsoft Excel can display a worksheet with hidden grids, but there isnt an option to modify this in the web tool.

Instead, you can only modify the document via the desktop app and sync it with the online version.

To do this, you need to: Open the document in the Excel online version.

Select Edit in Excel to open the document in the desktop version.

Follow the same steps from the previous sections (depending on your Excel version) to hide or show the gridlines.

Excel For Mac Hide Gridlines