Freezing Panes

cfarley

New Member
Joined
Apr 21, 2006
Messages
13
Is there any way to freeze BOTH a row and a column on the same spreadsheet?
 

Some videos you may like

Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

erik.van.geit

MrExcel MVP
Joined
Feb 1, 2003
Messages
17,832
Hi,

click in B2
freeze panes (menu window)
first column as well as first row are "frozen"

kind regards,
Erik
 

cfarley

New Member
Joined
Apr 21, 2006
Messages
13
You are the bomb!!! Thank you. I have tried to do this for years and could not figure it out. How simple was that!!! Much thanks.
 

erik.van.geit

MrExcel MVP
Joined
Feb 1, 2003
Messages
17,832
you're welcome

it's just a question of playing with the stuff to discover it's secrets ;)
 

Watch MrExcel Video

Forum statistics

Threads
1,114,385
Messages
5,547,650
Members
410,805
Latest member
Ginoji
Top