Excel 2013 Print 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 2013 Print 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.

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.

Hold Ctrl and left-click on all the worksheets that you want to select from the bottom of the page.

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.

You can include the grids in the printed file by following these steps: Open the Excel document.

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.

To hide the gridlines, simply follow steps 1-5 from above and untick the Gridlines options again.

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.

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 2013 For Mac Print Gridlines