Freeze a title only

S

smartin

Judy said:
Why can't I freeze a row only to put at the top of every page of my worksheet.
Click to expand...

If you are talking about the printed rendering of your worksheet, try

File | Page Setup | Sheet | Rows to Repeat at Top

and enter $1:$1
 
G

Gord Dibben

What makes you think it can't be done?

Select A2 and Window>Freeze Panes


Gord Dibben MS Excel MVP

On Sat, 26 Jul 2008 16:18:00 -0700, Judy Kay <Judy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Space at end of multi page list to accommodate new entries 1
Macro to Select text from a point given to a specific word 2
Freeze Panes loss 3
Unable to freeze panes 15
freeze column and row on same spread sheet 2
Re-title multiple MS Project .mpp files at once 0
Solved Disk Full error message when exporting PDF 0
I selected row 1 and row 2 to freeze and it is freezing at row 12 2

Top