Download Article
Download Article
This article was co-authored by wikiHow staff writer, Darlene Antonelli, MA. Darlene has been writing and editing tech content at wikiHow since 2019. She previously worked for AppleCare, served as a writing tutor, volunteered in IT at an animal rescue, and taught as an adjunct professor for EN101 and EN102. Darlene has completed Coursera courses on technology, writing, and language. She holds both a BA (2011) and an MA (2012) from Rowan University in Writing, with a focus on workplace communication. With her extensive experience, academic background, and ongoing learning, Darlene has become the go-to grammar expert for her friends and family, as well as a skilled wordsmith for anyone in need.
This article has been viewed 66,973 times.
Learn more...
Frozen panels will appear on every page of Excel on your screen, but what if you print the spreadsheet? This wikiHow will teach you how to print frozen panes (also known as "columns and rows") on every page in Excel.
Quick Steps
- Open your Excel document.
- Click the Page Layout tab at the top of the screen.
- Choose Print Titles in the "Page Setup" section.
- Enter the rows and columns you want to print on each page.
- Click OK to save your selection.
Steps
Download Article
-
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
You Might Also Like
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.
