Hide Gridlines In Excel 2010 Spreadsheet

Excel 2010, like previous versions, shows gridlines in the spreadsheet to let users easily add/remove cells’ values, and adjust height and width of row and columns, respectively. You may know that Excel 2010 doesn’t print the guidelines unless you manually add them to printable elements. Most users choose to apply border style to gridlines to make their data sets prominent in the spreadsheet, but there is another rather easy way to make your data set prominent, and that is by hiding the gridlines and then applying the guidelines border style to selected rows and fields; using the Gridlines view toggle button, you can hide the gridlines and then apply border to selected cells. However, if gridlines are distracting your work, you can make them invisible. This post will let you know how to make gridlines invisible to view only the cells’ values.

Open the spreadsheet in which you need to hide gridlines. Navigate to the View tab and from Show group, disable Gridlines option.

362d1274091122hidegridlinesspreadsheet Hide Gridlines In Excel 2010 SpreadsheetView in gallery

This will conceal gridlines in the spread sheet.

363d1274091124hidegridlinesspreadsheet Hide Gridlines In Excel 2010 SpreadsheetView in gallery

It’s worth mentioning here that Excel 2010 doesn’t provide you with an option to permanently disable gridlines. You can only disable them on your current sheet, or choose to disable gridlines on your entire workbook. The Excel 2010 Options window (accessible from File->Options) lets you select the current workbook to disable gridlines on all sheets. In addition, you can choose to change the default color of gridlines. Just open the Options window, and head over to Advanced window, scroll down to Display Options for this worksheet section, and then choose your favorite gridline color.

View in gallery