| 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 | |||
Hybrid Mode
