Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

2 Answers 2

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 pdf995.com 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
1  
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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.