You are viewing the article How to Print Fixed Pane on Every Page in Excel at Tnhelearning.edu.vn you can quickly access the necessary information in the table of contents of the article below.
This article is co-authored by a team of editors and trained researchers who confirm the accuracy and completeness of the article.
The wikiHow Content Management team carefully monitors the work of editors to ensure that every article is up to a high standard of quality.
This article has been viewed 1,895 times.
The fixed panes (aka “locked” or “freeze”) appear on every Excel sheet of the screen, but what about when you print the spreadsheet? This wikiHow teaches you how to print freeze panes (or “columns and rows”) on any page in Excel.
Steps
- If the Print Titles option is grayed out, it may be because you are editing a cell (check if the mouse pointer is in the cell), or the computer is not currently connected to the printer.
- For example, if you want to repeat the first row, enter “$1:$1.” [1] X Trusted Source Microsoft Support Go to Source
- You can also click on the row title to select it.
- You can also click on a column header to select something like “$A:$A” to freeze column A.
- Click Print Preview to preview the page layout. [2] X Research Source
This article is co-authored by a team of editors and trained researchers who confirm the accuracy and completeness of the article.
The wikiHow Content Management team carefully monitors the work of editors to ensure that every article is up to a high standard of quality.
This article has been viewed 1,895 times.
The fixed panes (aka “locked” or “freeze”) appear on every Excel sheet of the screen, but what about when you print the spreadsheet? This wikiHow teaches you how to print freeze panes (or “columns and rows”) on any page in Excel.
Thank you for reading this post How to Print Fixed Pane on Every Page in Excel at Tnhelearning.edu.vn You can comment, see more related articles below and hope to help you with interesting information.
Related Search: