How to get rid of grid lines in Excel

how to get rid of grid lines in Excel

1. The grid lines displayed in the Excel interface are in worksheet units. That is, removing gridlines from one worksheet does not affect other worksheets, including other worksheets in the same workbook as it does.

2, it is best to complete all the contents of a table and then remove the grid line, otherwise it may not be easy to find the cell location.

3, the grid lines described in this tutorial are divided into grid lines displayed in the worksheet interface, and two kinds of grid lines that are output when printed.

One, hidden gridlines

1, hidden gridlines is hidden in the worksheet interface grid lines. Just position the cursor in the worksheet where you want to hide gridlines, and then switch to the Page Layout tab, and uncheck the view gridlines in the sheet Options group.

2, now, the grid line has been hidden, the effect of the following figure.

Second, remove the print grid line

Also position the cursor in the worksheet where you want to remove the print gridlines, go to the sheet Options group on the Page Layout tab, and remove the hook before "print" under grid lines.