Thread: Stop Scrolling?

Originally Posted by aldawson38

how do i "lock" a worksheet so someone cannot keep scrolling forever and the sheet will stop scrolling at the edge of the last column?
i've already frozen some rows so i'm fine there, just scrolling thats foxed me today!

Hi,
The simplest way to set your scroll area would be this
At the top menu, select View=>toolbars=>Control Toolbox then select the properties icon, from there you will see a place to set you scroll area,
enter something like:
A1:G20

Another way would be to hide the columns and rows that are not being used, or you don't want viewed..
Select the 1st empty column and press "Shift+end+right arrow", all the columns should be selected, goto format,columns,select hide, do the same for rows...

There are also Keyboard shortcuts to hide rows and columns
Ctrl+0 will hide selected columns
Ctrl+Shift+0 will unhide selected columns
Ctrl+9 will hide selected rows
Ctrl+Shift+9 will unhide selected rows
Select rows or columns that are hidden by selecting the rows or columns around them, or just select the entire sheet and then unhide the hidden rows or columns,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.

You can use the big, orange "Post new thread" button at the top of the forum view.

The button is visible at the top of each forum, not in a thread. Open the forum into which you want to post your question. Hit the button.