Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how to freeze only one row
when i chose freeze frame from the windows menu it freeez the first 17 rows.
how do i get it to reeze row 1 only ? -- huggy |
#2
|
|||
|
|||
Freeze panes freezes above the cursor, sol select A2 first.
-- HTH Bob Phillips "huggybear" wrote in message ... when i chose freeze frame from the windows menu it freeez the first 17 rows. how do i get it to reeze row 1 only ? -- huggy |
#3
|
|||
|
|||
The panes that freeze are above and/or to the right of the location of your
cursor when who select Windows Freeze Panes. If you are getting the first 17 rows freezing, than your cursor was in Cell A18 when you froze the panes. Click Window Unfreeze panes, move your cursor to Cell A2 and click Window Freeze panes. This will freeze row 1. "huggybear" wrote: when i chose freeze frame from the windows menu it freeez the first 17 rows. how do i get it to reeze row 1 only ? -- huggy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Freeze Panes | Excel Discussion (Misc queries) | |||
Freeze Pane problem in shared workbooks | Excel Discussion (Misc queries) | |||
Shared File & Freeze panes issue | Excel Discussion (Misc queries) | |||
How do I change the colour of/remove the Freeze Panes line in Exce | Excel Worksheet Functions | |||
Id like to freeze the first row for headers and freeze the very b. | Charts and Charting in Excel |