how to remove the gridlines in excel for mac

Although they help navigate around a sheet or workbook, you can turn them off without affecting cells or data.

However, the program takes an all-or-nothing approach to grid line views.

You can see them all or switch them all off, but you cant remove lines around individual cells or selected areas in your sheet unless you use a workaround with the programs border tools.

When you uncheck the Gridlines box now, youll remove lines from the whole workbook.

To hide them on adjacent sheets, select the first sheet in the menu, hold down the Shift key and select the next sheet; to hide them on non-adjacent sheets, use the same process but hold down the Ctrl key instead.

Select the cells whose lines you want to remove and go to the Borders button on the Home tab.

For example, to remove lines from one cell, use Outside Borders; to remove them from a selection of cells, use All Borders.

When you select a border, the grid lines on your cell or selection turn white and look like theyve been removed.

For example, you can set lines to print or change their color on sheets or workbooks.

If you want to work with selected cells within a sheet or apply other effects, use the programs Border tools.

Open the Advanced tab and scroll down to Display Options for This Worksheet.

If you want only selected lines to print, use Border tools to add borders( ) to your cells.

You can also use borders to change the color or thickness of lines around selected cells.

How To Remove The Gridlines In Excel For Mac