Buzz
Fixed panes (also referred to as 'locked' or 'frozen') remain visible on every Excel screen page, but what happens when you print the spreadsheet? Today, Mytour will guide you on how to print these frozen panes (or 'columns and rows') on every page in Excel.
Steps
Open your project in Excel. You can right-click the file in File Explorer (Windows) or Finder (Mac). If Excel is already open, go to File > Open and select the file you want to open.
Click on the Page Layout tab located next to other tabs like File and Insert.
Click on the Print Titles option. This option is located within the Page Setup group, represented by an Excel sheet and printer icon.
- If the Print Titles option is grayed out, it might be because you are editing a cell (check if the cursor is inside a cell), or your computer is not currently connected to a printer.
Enter the rows you want to print on each page in the "Rows to repeat at top" field. If you don't see the "Rows to repeat at top" and "Columns to repeat at left" fields, ensure the Sheets tab is selected.
- For example, if you want to repeat the first row, enter "$1:$1."
- You can also click on the row header to select it.
Enter the columns you want to print on each page next to the "Columns to repeat at left" field. If you don't see the "Rows to repeat at top" and "Columns to repeat at left" fields, check if the Sheets tab is selected.
- You can also click on the column header to select it, such as "$A:$A" to freeze column A.
Click Ok. Once ready, you can proceed to print the document.
- Click Print Preview to preview the page layout.
