Excel for Microsoft 365 for Mac Excel 2021 for Mac Excel 2019 for Mac Excel 2016 for Mac Excel for Mac 2011 More...Less Show
If you want to print a sheet that will have many printed pages, you can set options to print the sheet's headings or titles on every page. Excel automatically provides headings for columns (A, B, C) and rows (1, 2, 3). You type titles in your sheet that describe the content in rows and columns. In the following illustration, for example, Projected is a row title and 2nd QTR is a column title.
Row headings Column headings Column titles Row titles Click the sheet. On the Page Layout tab, in the Sheet Options group, select the Print check box under Headings.
On the File menu, click Print. You can see how your sheet will print in the preview pane. Print row or column titles on every page
Click the sheet. On the Layout tab, under Print, select the Headings check box. On the File menu, click Print. You can see how your sheet will print before you print it by clicking Preview. Print row titles on every page
Print column titles on every page
See alsoPrint part of a sheet Print with landscape orientation Scale the sheet size for printing Preview pages before you print Need more help?How do I repeat footer in Excel?Print row or column titles on every page. Click the sheet.. On the Page Layout tab, in the Page Setup group, click Page Setup.. Under Print Titles, click in Rows to repeat at top or Columns to repeat at left and select the column or row that contains the titles you want to repeat.. Click OK.. On the File menu, click Print.. How do I make a footer the same on every sheet in Excel?If you want to add a header or footer to all sheets, select every sheet by right-clicking one of the sheet tabs at the bottom of the Excel screen and clicking "Select All Sheets" in the pop-up menu. It's fairly common to put an Excel header on all pages of all worksheets in your document.
How do you repeat rows at the bottom?To do this, you'll need to use a macro. First, open your Excel workbook and select the worksheet that you want to modify. Then, click on the "View" tab and select "Macros". This code will loop through all of the rows in your selected worksheet and copy the data from the last row to every 56th row.
|