how to freeze horizontal & vertical at same time ?

[junedonofrio]

i am trying to freeze the header at the top & also more than one column at the side & middle, but i can only seem to freeze one at at time. i know it must be simple, but i can't figure it out !
any help will be appreciated.
thanks,
June

 

[sfvb]

Here's an example of how to freeze the rows above row 3 and to the left of column E:

Go to cell F4
select Window-->Freeze Panes

Steve

 

[junedonofrio]

thank you so much, i knew it had to be simple
thanks again it works !
June

 

[xlbo]

For future reference - this question should've been asked in the MSOffice forum. This is a VBA forum and should therefore be used for PROGRAMMING questions relating to VBA

Rgds, Geoff

Never test the depth of water with both feet

Help us to help you by reading FAQ222-2244 before you ask a question

 

[junedonofrio]

all noted about the correct forum, i didnt realize, this is where it came up when i searched for microsoft excel only one forum.

thanks for the heads up
June