K
Ken_Ohio
I am running Office 2007.
I am trying to freeze the top two rows in an Excel spreadsheet.
I highlight the top two rows and use "Freeze based on selection" option.
The app does not freeze the panes I have selected.
It freezes 11 rows down and 3 columns across (?????) even though it still
shows that I have the first two rows selected.
I tried just selecting two rows and five columns, which is where my titles
are, but the same results occur when I select the "Freeze based on selection"
option: 11 rows down and 3 columns across.
There doesn't seem to be any other way of doing this, or am I missing
something?
The option to freeze the top one row does work, but that is not what I need
to do.
Can anyone offer help with this?
Sincerely,
Ken
I am trying to freeze the top two rows in an Excel spreadsheet.
I highlight the top two rows and use "Freeze based on selection" option.
The app does not freeze the panes I have selected.
It freezes 11 rows down and 3 columns across (?????) even though it still
shows that I have the first two rows selected.
I tried just selecting two rows and five columns, which is where my titles
are, but the same results occur when I select the "Freeze based on selection"
option: 11 rows down and 3 columns across.
There doesn't seem to be any other way of doing this, or am I missing
something?
The option to freeze the top one row does work, but that is not what I need
to do.
Can anyone offer help with this?
Sincerely,
Ken