Locked view
 

For some reason Ive accidentally pressed a series of buttons and it wont
let me scroll down when looking at the whole sheet, but if I filter or go to
another sheet it will. I'm not sure whether I have just locked certain cells
on the screen or whether the view is locked somehow as I can scroll across
but not down.

Ta

Locked view
 

Not sure but you can try pressing the scroll lock button

--
--
-John
Please rate when your question is answered to help us and others know what
is helpful.

"Pasty" wrote in message
...
For some reason I've accidentally pressed a series of buttons and it won't
let me scroll down when looking at the whole sheet, but if I filter or go
to
another sheet it will. I'm not sure whether I have just locked certain
cells
on the screen or whether the view is locked somehow as I can scroll across
but not down.

Ta

Locked view
 

Did that but doesn't seem to work! And it seems to have saved it in that way
as well so I can't get out of it.

"John Bundy" wrote:

Not sure but you can try pressing the scroll lock button

--
--
-John
Please rate when your question is answered to help us and others know what
is helpful.

"Pasty" wrote in message
...
For some reason I've accidentally pressed a series of buttons and it won't
let me scroll down when looking at the whole sheet, but if I filter or go
to
another sheet it will. I'm not sure whether I have just locked certain
cells
on the screen or whether the view is locked somehow as I can scroll across
but not down.

Ta

Locked view
 

maybe
check <window and unfreeze panes

"Pasty" wrote:

For some reason Ive accidentally pressed a series of buttons and it wont
let me scroll down when looking at the whole sheet, but if I filter or go to
another sheet it will. I'm not sure whether I have just locked certain cells
on the screen or whether the view is locked somehow as I can scroll across
but not down.

Ta

Locked view
 

Already checked that as well. it's a bit of a nightmare to be honest coz I've
tried almost everything!

"bj" wrote:

maybe
check <window and unfreeze panes

"Pasty" wrote:

For some reason Ive accidentally pressed a series of buttons and it wont
let me scroll down when looking at the whole sheet, but if I filter or go to
another sheet it will. I'm not sure whether I have just locked certain cells
on the screen or whether the view is locked somehow as I can scroll across
but not down.

Ta

Locked view
 

??
<tools <protection<unprotect sheet
??

a possible workaround is to copy all; put on a new sheet and delete the
current sheet. Not a good option if there are a lot of interacting formulas;
but

"Pasty" wrote:

Already checked that as well. it's a bit of a nightmare to be honest coz I've
tried almost everything!

"bj" wrote:

maybe
check <window and unfreeze panes

"Pasty" wrote:

For some reason Ive accidentally pressed a series of buttons and it wont
let me scroll down when looking at the whole sheet, but if I filter or go to
another sheet it will. I'm not sure whether I have just locked certain cells
on the screen or whether the view is locked somehow as I can scroll across
but not down.

Ta