Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm using Excel 2013. I have a spreadsheet where the first row is "frozen". So when I scroll up and down that first row stays put. It contains the titles for each row. When I save the file as a PDF, the ability to freeze the first row goes away. I know its possible because I've done it before. But I can't for the life of me do it again. Please help.

EDIT: Here is an example

share|improve this question
up vote 3 down vote accepted

Repeat title rows at the top of each page as suggested by Travis. Now every page has the same header.

In Acrobat Reader, select View > Page Display > Single Page View

At the same time, scrolling is de-selected. So, the visible part of the page never changes. While scrolling through pages, which all have the same header, it appears as if the header is frozen and the content below the header scrolls. But that's an optical illusion. If you look closely, you'll see that the screen content changes one page at a time, not one row at a time, so it's paging rather than scrolling. With the header in a fixed position, the illusion is almost perfect.

It is not an Excel setting, but an Adobe Reader setting. I don't know if this setting can be manipulated from Excel, or if it requires a PDF creator like Acrobat.

share|improve this answer
Your right Teylyn, thank you. The setting in Acrobat was what I was missing. – JimDel May 8 '13 at 20:42
Thanks for this teylyn! I'll know it is possible from now on! – Travis May 10 '13 at 14:51

Page Layout, Print Titles. Rows to repeat at top.

share|improve this answer
That does add the title to the top of each page. But I'm looking for the same functionality that Excel gives by freezing the top row. Then when scroll up and down the first row will always be on screen. – JimDel May 6 '13 at 19:51
Maybe you can print the file to PDF using something like pdf995 or similar tools? – Jan Doggen May 6 '13 at 20:02
Tried that with no success. – JimDel May 6 '13 at 20:28
That cannot be done with PDFs. A PDF shows the content as it would appear on printed paper. PDF is not a spreadsheet. – teylyn May 6 '13 at 20:28
I found some articles elsewhere that shows exactly what you are talking about. I would say it is probably an Adobe Pro header function, not something that is in the free reader. – Travis May 7 '13 at 12:21

Go to the page layout tab at the top, select the "Print Titles" pull down menu and a page setup box will pop up. In the "Rows to Repeat" at the top bar, click on the icon on the right, then click on the top row in your excel file.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .