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.
 
Top