This article was co-authored by How.com.vn staff writer, Darlene Antonelli, MA. Darlene Antonelli is a Technology Writer and Editor for How.com.vn. Darlene has experience teaching college courses, writing technology-related articles, and working hands-on in the technology field. She earned an MA in Writing from Rowan University in 2012 and wrote her thesis on online communities and the personalities curated in such communities.
This article has been viewed 52,152 times.
Learn more...
Frozen panels will appear on every page of Excel on your screen, but what if you print the spreadsheet? This How.com.vn will teach you how to print frozen panes (also known as "columns and rows") on every page in Excel.
Steps
- Open your project in Excel. You can right-click the file in File Explorer (on Windows) or in Finder (on Mac). If you already have Excel open, go to File > Open and select the file you want to open.
- Click the Page Layout tab. It's next to File and Insert.Advertisement
- Click Print Titles. You'll see this in the "Page Setup" grouping with an icon of an Excel sheet and a printer.
- If that's greyed out, you might be actively editing a cell (check to see if your cursor is in a cell) or you might not have a printer connected to your computer.
- Enter the rows that you want to print on each page next to "Rows to repeat at top." Make sure you're in the Sheets tab if you don't see "Rows to repeat at top" and "Columns to repeat at left."
- For example, if you want to repeat the first row, enter "$1:$1."[1]
- You can also click the header of the row to select it.
- Enter the columns that you want to print on each page next to "Columns to repeat at left." Make sure you're in the Sheets tab if you don't see "Rows to repeat at top" and "Columns to repeat at left."
- You can also click the header of the column to select it, like "$A:$A" to freeze column A.
- Click Ok. When you're ready to continue, you can print the document.
- Click Print Preview instead to see a preview of your page layout.[2]
Expert Q&A
Tips
References
About This Article
1. Open your project in Excel.
2. Click the Page Layout tab.
3. Click Print Tiles.
4. Enter the rows that you want to print on each page next to "Rows to repeat at top."
5. Enter the columns that you want to print on each page next to "Columns to repeat at left."
6. Click Ok.
Is this article up to date?
⚠️ Disclaimer:
Content from Wiki How English language website. Text is available under the Creative Commons Attribution-Share Alike License; additional terms may apply.
Wiki How does not encourage the violation of any laws, and cannot be responsible for any violations of such laws, should you link to this domain, or use, reproduce, or republish the information contained herein.
- - A few of these subjects are frequently censored by educational, governmental, corporate, parental and other filtering schemes.
- - Some articles may contain names, images, artworks or descriptions of events that some cultures restrict access to
- - Please note: Wiki How does not give you opinion about the law, or advice about medical. If you need specific advice (for example, medical, legal, financial or risk management), please seek a professional who is licensed or knowledgeable in that area.
- - Readers should not judge the importance of topics based on their coverage on Wiki How, nor think a topic is important just because it is the subject of a Wiki article.