ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Spreadsheet will not allow me to freeze row & column (https://www.excelbanter.com/excel-discussion-misc-queries/228210-spreadsheet-will-not-allow-me-freeze-row-column.html)

Jane01

Spreadsheet will not allow me to freeze row & column
 
I put the curser in Cell B2 and select Window/Freeze. Nothing happens.
--
Jane

Jacob Skaria

Spreadsheet will not allow me to freeze row & column
 
Check whether the sheet is protected..

If this post helps click Yes
---------------
Jacob Skaria


"Jane01" wrote:

I put the curser in Cell B2 and select Window/Freeze. Nothing happens.
--
Jane


Jane01

Spreadsheet will not allow me to freeze row & column
 
How do I find that out? Also, I now notice when I have the Freeze on and
move the bar at the bottom, the screen will not move at all. But it does
move when I up & down with the side bar.
--
Jane


"Jacob Skaria" wrote:

Check whether the sheet is protected..

If this post helps click Yes
---------------
Jacob Skaria


"Jane01" wrote:

I put the curser in Cell B2 and select Window/Freeze. Nothing happens.
--
Jane


Jacob Skaria

Spreadsheet will not allow me to freeze row & column
 
Right click on the sheet tab...
--
If this post helps click Yes
---------------
Jacob Skaria


"Jane01" wrote:

How do I find that out? Also, I now notice when I have the Freeze on and
move the bar at the bottom, the screen will not move at all. But it does
move when I up & down with the side bar.
--
Jane


"Jacob Skaria" wrote:

Check whether the sheet is protected..

If this post helps click Yes
---------------
Jacob Skaria


"Jane01" wrote:

I put the curser in Cell B2 and select Window/Freeze. Nothing happens.
--
Jane


David Biddulph[_2_]

Spreadsheet will not allow me to freeze row & column
 
Have you tried to move your cursor more than a screenful down or right? Try
to scroll, or just GoTo Z55 or somewhere. Then what columns are visible at
the left of your window, and what rows at the top?
--
David Biddulph

"Jane01" wrote in message
...
I put the curser in Cell B2 and select Window/Freeze. Nothing happens.
--
Jane




Jane01

Spreadsheet will not allow me to freeze row & column
 
Right clicking on sheet tab does not solve the problem.
--
Jane


"Jacob Skaria" wrote:

Right click on the sheet tab...
--
If this post helps click Yes
---------------
Jacob Skaria


"Jane01" wrote:

How do I find that out? Also, I now notice when I have the Freeze on and
move the bar at the bottom, the screen will not move at all. But it does
move when I up & down with the side bar.
--
Jane


"Jacob Skaria" wrote:

Check whether the sheet is protected..

If this post helps click Yes
---------------
Jacob Skaria


"Jane01" wrote:

I put the curser in Cell B2 and select Window/Freeze. Nothing happens.
--
Jane


Jane01

Spreadsheet will not allow me to freeze row & column
 
No matter where I put the curser the same thing happens. When I apply the
Freeze, the column and rows to the left and above the curser do not freeze,
but the bottom scroll bar does not move anything. I use the Freeze option
a lot and this is the only spreadsheet I have had problems with. I
imported it from another sight and it may have to do with how it was set up
during the transition. I will be inporting data from this sight a lot so
would like to figure out how to correct ir. Thanks for trying to help. --
Jane


"David Biddulph" wrote:

Have you tried to move your cursor more than a screenful down or right? Try
to scroll, or just GoTo Z55 or somewhere. Then what columns are visible at
the left of your window, and what rows at the top?
--
David Biddulph

"Jane01" wrote in message
...
I put the curser in Cell B2 and select Window/Freeze. Nothing happens.
--
Jane






All times are GMT +1. The time now is 12:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com