Print headings or titles on every page in Excel for Mac 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
Print rows with column headers on top of every page If a worksheet spans more than one page, you can print row and column headers or labels (also called print titles) on every page For example, you can repeat the first row of column headers on all pages when you have large, complex worksheets
Repeat specific rows or columns on every printed page On the Sheet tab, under Print titles, do one—or both—of the following: In the Rows to repeat at top box, enter the reference of the rows that contain the column labels In the Columns to repeat at left box, enter the reference of the columns that contain the row labels For example, if you want to print column labels at the top of every printed page, you could type $1:$1 in the Rows to
Print the top row on every page - Microsoft Support In a worksheet that will take more than one page to print, you can print column headers on each page so the column headings can be seen on each page On the Page Layout tab, in the Page Setup group, click Print Titles If the Print Titles ribbon button is grayed out, check to ensure that you’re not currently editing a cell or an area chart
Print row and column headings - Microsoft Support By default, Excel doesn't print the column headings (A, B, C, etc ) or row headings (1, 2, 3, etc ) that appear along the borders of the sheet 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
Headers and footers in a worksheet - Microsoft Support You can add headers or footers at the top or bottom of a printed worksheet in Excel For example, you might create a footer that has page numbers, the date, and the name of your file You can create your own, or use many built-in headers and footers Headers and footers are displayed only in Page Layout view, Print Preview, and on printed pages You can also use the Page Setup dialog box if
Repeat table header on subsequent pages - Microsoft Support Notes: Repeated table headers are visible only in Print Layout view or when you print the document If you change a table header on the first page, the header changes on all other pages also You can only modify the table header on the first page—the header rows on subsequent pages are locked Although Word automatically repeats table headers on new pages that result from automatic page
Insert page numbers on worksheets - Microsoft Support If you want page numbers shown on pages when you print a Microsoft Excel worksheet, you can insert page numbers in the headers or footers of the worksheet pages Page numbers that you insert are not displayed on the worksheet in Normal view, they are shown only in Page Layout view and on the printed pages
Turn Excel table headers on or off - Microsoft Support Notes: The table header row should not be confused with worksheet column headings or the headers for printed pages For more information, see Print rows with column headers on top of every page When you turn the header row off, AutoFilter is turned off and any applied filters are removed from the table When you add a new column when table headers are not displayed, the name of the new table
Add a header, footer, or legend when printing - Microsoft Support In the File tab, click Print, then click Page Setup On the Header, Footer, or Legend tab, click the Left, Center, or Right tab In the text box, type or paste the text, add the document or project information, or insert or paste a graphic To add page numbers, click Insert Page Number , Insert Total Page Count , or both