#Some gridlines not printing in excel how to

Go to the Sheet tab and select the Gridlines under the Print group. Figure 8- You can also access the Page Setup dialogue box via the Print menu.Ĥ. To do so, go to File, click on Print, and select Page Setup on the bottom.

You can also access “Page Setup” from the Print action.

Click on the small arrow in the corner of the Page Setup block to open the settings.įigure 7- Open the Page Setup dialogue box.ģ.

Go to the Page Setup group under the Page Layout tab.

There is also another way to print the gridlines in Excel. You can also print your worksheet with their headings by selecting the Print checkbox under the Headings Title.įigure 6- To print the gridlines, you can simply select the Print checkbox under the Gridlines title.

Select the Print checkbox under the Gridlines title.

Needless to say, you can print gridlines in Excel too. Normally, Excel sheets are printed without their grids unless you have made a table that fills all the cells. Figure 5- Reading a chart will be easier while there are no Gridlines on the Excel sheet. Then, after finishing your report, you can make the grids invisible to make it more understandable and clear to read, especially when you have a chart on the page. However, it will be easier to insert your data in the Excel sheet while it has its gridlines. You may think about why we need to hide the grids in Excel? That’s simple it makes your sheet more presentable.

You can press the keys again to show the grids on the Excel sheet. You only need to press the”Alt + W+V+G” keys on the sheet, and you can see the grids fade away. There is a shortcut to hide the gridlines in the Excel sheet. Method 4- Hiding The Gridlines In Excel Using The Shortcut Key Go to the Home tab and change the background color to white.įigure 4- Simply change the background color to white to hide the gridlines in the Excel sheet.Select all the cells by pressing Ctrl + A keys.This is another trick to hide the gridlines in Excel. Just go to the View tab and uncheck the Gridline checkbox in the Show group. Method 2- Removing Excel Grids In The View Tab Although the grids are not visible, the sheet still has its cells like before.įigure 3- Simply uncheck the View checkbox to remove gridlines on the Excel worksheet. If you want to hide the headings too, you can deselect the View checkbox under the Heading title too.Uncheck the checkbox of View under the Gridlines title.Go to the Sheet Options group in the Page Layout tab.Hiding Excel gridlines is as easy as adding them.

#Some gridlines not printing in excel how to

How To Remove Gridlines In Excel? Method 1- Removing Gridlines In Excel Via Page Layout Method 2- Adding Gridlines In Excel Via The View Tabįigure 2- Adding Excel grids via the View tab.

If the headings have been hidden too, simply click on the View checkbox on the Headings group.įigure 1- Adding gridlines in Excel via Page Layout.

The gridlines will be visible on the sheet.

To add gridlines in Excel, easily select View by clicking on its checkbox.

There are two options dedicated to gridlines and two for Headings, which are the numeric and alphabetic titles on the top and side of the worksheet.

Find Gridlines in the Sheet Options group.

In this case, you can easily add gridlines in Excel as follow: However, you may open a file and wouldn’t be able to see the grids because someone has hidden it before. How To Add Gridlines In Excel? Method 1- Adding gridlines in Excel via Page LayoutĪs mentioned earlier, the gridlines are visible in any Excel worksheet, by default. In this post, we are going to teach you how to add, remove, and print gridlines in Excel. Generally, when you open the Excel files, you see the grids, and you have control over these lines. This is done by Excel gridlines, the horizontal and vertical gray lines that help you distinguish the spaces assigned to each cell on the Excel worksheet. Excel can help you read the data more clearly by organizing them in different cells.