How do i freeze multiplue areas?
I'm trying to freeze panes verically and horizantly, can any one help with
this? |
Hi
for example move your cursor to cell C4 and goto 'Windows - Freeze panes'. This freezes rows 1-3 and column A:B. You can only freeze the top and left though -- Regards Frank Kabel Frankfurt, Germany Quiana wrote: I'm trying to freeze panes verically and horizantly, can any one help with this? |
Hi,
Ok i was able to freeze column A & B. Is it possible to freeze the top as well, row 1-4? Thanks! "Frank Kabel" wrote: Hi for example move your cursor to cell C4 and goto 'Windows - Freeze panes'. This freezes rows 1-3 and column A:B. You can only freeze the top and left though -- Regards Frank Kabel Frankfurt, Germany Quiana wrote: I'm trying to freeze panes verically and horizantly, can any one help with this? |
Hi
as said: Move the cursor to C5. This feature freezes all rows to the top and all columns to the left of the active cell -- Regards Frank Kabel Frankfurt, Germany Quiana wrote: Hi, Ok i was able to freeze column A & B. Is it possible to freeze the top as well, row 1-4? Thanks! "Frank Kabel" wrote: Hi for example move your cursor to cell C4 and goto 'Windows - Freeze panes'. This freezes rows 1-3 and column A:B. You can only freeze the top and left though -- Regards Frank Kabel Frankfurt, Germany Quiana wrote: I'm trying to freeze panes verically and horizantly, can any one help with this? |
That worked, thanks so much for your help!
"Frank Kabel" wrote: Hi as said: Move the cursor to C5. This feature freezes all rows to the top and all columns to the left of the active cell -- Regards Frank Kabel Frankfurt, Germany Quiana wrote: Hi, Ok i was able to freeze column A & B. Is it possible to freeze the top as well, row 1-4? Thanks! "Frank Kabel" wrote: Hi for example move your cursor to cell C4 and goto 'Windows - Freeze panes'. This freezes rows 1-3 and column A:B. You can only freeze the top and left though -- Regards Frank Kabel Frankfurt, Germany Quiana wrote: I'm trying to freeze panes verically and horizantly, can any one help with this? |
All times are GMT +1. The time now is 05:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com