Print gridlines in a worksheet - Microsoft Support
Gridlines print only around actual data in a worksheet. If you want to print gridlines around empty cells also, you must set the print area to include those cells. Or, you can apply borders around the cells instead.
Change the color of gridlines in a worksheet - Microsoft Support
If you want gridlines to appear on the printed page, select the worksheet or worksheets that you want to print. On the Page Layout tab, in the Sheet Options group, select the Print check box under Gridlines. To print, press CTRL+P. In Excel, you can change the color of …
Show or hide gridlines on a worksheet - Microsoft Support
Show or hide gridlines in Word, PowerPoint, and Excel. Print gridlines in a worksheet. Gridlines are the faint lines that appear around cells to distinguish them on the worksheet. By default, gridlines are displayed in worksheets using a color that is assigned by Excel.
Insert, move, or delete page breaks in a worksheet
Microsoft Excel inserts automatic page breaks based on the paper size, margin settings, scale options, and the positions of any manual page breaks that you insert. To print a worksheet with the exact number of pages that you want, you can adjust the …
Print gridlines in a worksheet - Microsoft Support
Gridlines print only around actual data in a worksheet. If you want to print gridlines around empty cells also, you must set the print area to include those cells. Or, you can apply borders around the cells instead.
Set or clear a print area on a worksheet - Microsoft Support
If you frequently print a specific section of your worksheet, you can set a print area for it. That way, when you print your worksheet, only that section will print. You can enlarge the print area by adding adjacent cells.
Apply or remove cell borders on a worksheet - Microsoft Support
If you want to print the same border on cells that are separated by a page break, but the border appears on only one page, you can apply an inside border. This way, you can print a border at the bottom of the last row of one page and use the same border at the top of the first row on the next page. Do the following:
Display or hide chart gridlines - Microsoft Support
To make the data in a chart that displays axes easier to read, you can display horizontal and vertical chart gridlines. Gridlines extend from any horizontal and vertical axes across the plot area of the chart. You can also display depth gridlines in 3-D charts.
Show or hide gridlines in Word, PowerPoint, or Excel
Work with gridlines and use snap-to-grid in PowerPoint. Turn the snap to grid and snap to object options on or off in Excel. Print gridlines in a worksheet. Show or hide the ruler in PowerPoint. Show or hide rulers in Word. Turn gridlines on or …
Print row and column headings - Microsoft Support
Follow these steps to print the column and row headings for a worksheet: Click the worksheet. If you want to do this for multiple worksheets, you can group them. On the Ribbon, click the Page Layout tab. In the Sheet Options group, under Headings, select the Print check box.
Set page margins before printing a worksheet - Microsoft Support
To better align an Excel worksheet on a printed page, you can change margins, specify custom margins, or center the worksheet—either horizontally or vertically on the page. Excel for the web. Page margins are the blank spaces between your data and the edges of the printed page.