If you have a large spreadsheet that contains many columns with similar types of information, then that information can become much more difficult to read when the reader gets to the second page and loses the identifying column title that appeared on the first page. Our Excel print guide offers many of these solutions, but one of the more commonly used print adjustments involves print the first row of your spreadsheet at the top of every page. There are many ways that you can format a printed spreadsheet so that it is easier to read on paper.
Select the row 1 heading at the left side of the window.Click inside the Rows to repeat at top field.Select the Page Layout tab at the top of the window.We list the steps at the beginning of the article, but you can continue reading after to see the steps with pictures. This guide is going to show you how to set row 1 to print on every page.
