Excel grid lines display and print

Excel gridlines are used to help us edit worksheets. If you want, you can also print Excel gridlines. The knowledge points related to Excel grid lines are described below.

First: Excel shows grid lines

In Excel2007 and Excel2010, click the View tab, check the Display-gridlines check box, and Excel can display gridlines.

Second: Excel does not display (cancel) grid lines

Click the View tab again, uncheck the Display-gridlines check box, and Excel does not display (cancel) gridlines, so that the gridlines are removed.

Check and uncheck the gridlines to set the grid line to display and hide when editing the table.

Excel 2003 does not display gridlines by clicking Options on the Tools menu, and then selecting View, without selecting gridlines. "

Third: Output grid line settings when printing

The default gridlines in Excel are not printed when you print. If you need to output the gridlines when printing, you need to make some settings, as follows:

Click the Start tab, select the Border Line tool icon in the Font bar of the menu, and through the Border Line tool icon, you can set any settings that are currently selected in the left and right border of the cell that will take effect when the document is printed.

IV: How to print gridlines and row-Number column labels in Excel 2007

As with 2003, set on the Sheet tab of page Setup, but 2007 is more convenient, directly on the Page Layout tab, in the Sheet Options group, select the Print check box for gridlines and titles, and so on.

The operation of the row number column of the worksheet in the Excel2010 print result is as follows: Click the file tab → print → page setup, switch to the Sheet tab, and then check the row Number column label checkbox to confirm it.

To sum up, this article describes the Excel grid-related knowledge, including: Excel to remove the elimination of the grid line, Excel display grid lines, Excel grid line printing and output.