If you want to apply the Fill Color feature to the entire worksheet, click Ctrl+A to select all the cells in the worksheet. You can apply a fill color to a specific region of the worksheet or to the entire worksheet and the gridlines will disappear. Remove gridlines by applying background fillĪnother way to remove gridlines is to use the Fill Color feature. You can also use the following options to remove the gridlines: 1. The command will remove the gridlines if they are visible or make the gridlines visible if they are not visible. The keyboard shortcut option to remove the gridlines is to press Alt and enter W, V, G. Click the Page Layout tab to expand the page layout commands and then go to the Gridlines section. The easiest way to remove gridlines in Excel is to use the Page Layout tab. The “Remove Gridlines” setting is specific to each worksheet, and removing gridlines will remove gridlines from the entire worksheet, but will still be visible in other worksheets in the workbook. Select the color you want to use and then go back to the worksheet. If you want o change the gridline colors, Go to the File tab, Options, Advanced and then click Grid Color. Gridlines are displayed in a workbook using a grey color that is applied automatically. If you want to make a certain section of the worksheet different from the rest, use border lines to make customizations to specific cells or group of cells. Gridlines in Excel apply, by default, in the whole worksheet or workbook, and cannot be applied to a specific section of the worksheet. Also, when printing a worksheet, the gridlines are not printed on the paper, whereas any borders applied to the worksheet appear on printed worksheets. Unlike borders, gridlines are visible on the entire worksheet and cannot be applied to a specific region of the worksheet compared to the borders. Also, most users confuse gridlines with cell borders, which are applied to specific regions of the worksheet. Without gridlines, users would face difficulties reading the data due to the lack of organization. They also help users navigate through the worksheet columns and rows with ease. The gridlines guide users to differentiate between the specific cells and read the data in an organized manner. Gridlines in Excel are the horizontal and vertical gray lines that differentiate between cells in a worksheet.