How do I freeze 2 top rows in Excel 2007

D

drumz

I only see the options of Unfreeze, Freeze top row and Freeze first column
from View/Window group. Problem is I want the first 2 rows to freeze. So how
do you do that?
Thanks,
 
M

muddan madhu

select the 3rd row, go to view tab | click freeze panes | again choose
freeze panes
 
S

Shane Devenshire

Hi,

You need to do this:

1. Choose View, Freeze Panes, Unfreeze Panes
2. Select A3 and choose View, Freeze Panes, Freeze Panes.
 

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

How do I freeze the swimlane headers? 0
Unable to freeze panes 15
Freeze top 2 rows - how 3
Freeze multiple rows/columns in Excel 2007 7
Keep Headers at top of page 5
How do I freeze/ unfreeze a window pane in Excel 2007? 2
Freeze Panes? 2
Any way to get Freeze Panes to work with Split View? 2

Top