ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Worksheet is scroll LOCKED (https://www.excelbanter.com/excel-discussion-misc-queries/203411-worksheet-scroll-locked.html)

Ayo

Worksheet is scroll LOCKED
 
I can't scroll to the right in my worksheet. And I can't select a whole
column or a whole row but I can select cells.
Any ideas?

Roger Govier[_3_]

Worksheet is scroll LOCKED
 
Hi

It sounds as though Scroll Area has been set.
This may have been done to prevent insertion of rows and Columns, and to
keep the user within a confined area.
The Workbook may have been protected to prevent you altering this, but if
not
Right click on Sheet tabView Codepress F4 to bring up PropertiesClear
values in Scroll Area

--
Regards
Roger Govier

"Ayo" wrote in message
...
I can't scroll to the right in my worksheet. And I can't select a whole
column or a whole row but I can select cells.
Any ideas?



Ayo

Worksheet is scroll LOCKED
 
Thanks

"Roger Govier" wrote:

Hi

It sounds as though Scroll Area has been set.
This may have been done to prevent insertion of rows and Columns, and to
keep the user within a confined area.
The Workbook may have been protected to prevent you altering this, but if
not
Right click on Sheet tabView Codepress F4 to bring up PropertiesClear
values in Scroll Area

--
Regards
Roger Govier

"Ayo" wrote in message
...
I can't scroll to the right in my worksheet. And I can't select a whole
column or a whole row but I can select cells.
Any ideas?




All times are GMT +1. The time now is 05:59 PM.

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