As a default Excel worksheets show gridlines between cells.
These can be helpful in seeing when different cells start and end, but when creating reports or dashboards, or if you want to customise borders in your report, it can be helpful to remove them.
Gridlines can be removed from just one worksheet, multiple worksheets or all worksheets.
Removing and adding back the gridlines is very simple and can really help with visualising your data in Excel.
Download File
If you would like to follow along download the attachment below.
Remove Gridlines From One Worksheet
To remove the gridlines from a worksheet make sure you are in the worksheet that you want the gridlines removed, then complete the following steps:
·       Select the View tab
·       Click the tick next to Gridlines to remove or add back the gridlines
This will remove the gridlines from the entire worksheet.
Removing Gridlines From Multiple Worksheets
If you want to remove gridlines from more than one or all worksheets this can be done by grouping your worksheets.
The benefit of grouping worksheets together means any changes made to the worksheet that you are on will apply to all worksheets.
This means that if you have selected more than one or all of the worksheets, when you go to View and untick Gridlines the gridlines will be removed from all grouped worksheets.
Group Worksheets
By default you will have only one worksheet selected, this will be the worksheet you are working on and it will be highlighted in white, with the non-selected sheets showing as grey.
To select more than one worksheet at the same time hold the Ctrl key and click on the other tabs you want to group.
All selected worksheets will go white, all non-grouped worksheets will remain grey.
The worksheet you are on will not change, and you can see which tab is displaying the worksheet you are on as although the background will be white the sheet name will have a green line under it.
Once you have grouped worksheets as well as all grouped worksheets going white you will see ‘Group’ in the header of your workbook.
Group All Worksheets
If have lots of worksheets and want to select all of them without clicking on them one by one you can right click on one of the worksheets and select ‘Select All Sheets’.
Ungroup Worksheets
If you want to remove a worksheet from your grouping hold the Ctrl key and click on the worksheet you want removed.
This will change the worksheets colour from white to grey showing it is no longer part of the grouping.
To ungroup all worksheets right click on the worksheet tab you want to remain on and select Ungroup Sheets.
This will leave you on the worksheet you right clicked on and remove all other sheets from the grouping.
Conclusion
Removing the gridlines is a simple and quick way to make reports look better and easier to read, and can give you more control over how you want your data displayed.
As a default if you remove gridlines they will only be removed from the worksheet you have selected, although it is possible to group worksheets together to remove them from more than one worksheet at a time.
Comentários