Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do i freeze multiplue areas?
I'm trying to freeze panes verically and horizantly, can any one help with
this? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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? |
#5
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Shared File & Freeze panes issue | Excel Discussion (Misc queries) | |||
Id like to freeze the first row for headers and freeze the very b. | Charts and Charting in Excel | |||
Why does freeze panes work on one sheet but not on another in sam. | Excel Worksheet Functions | |||
Freeze Pane command freezes more cells than I selected. | Excel Worksheet Functions | |||
Countif & ranges consisting of multiple areas | Excel Worksheet Functions |