How to Unlock Scroll Lock in Excel
How to plough on/off the gyre lock in Excel?
In Excel, when you printing Upwardly and Down arrows or Left and Right arrows incautiously, the active cell moves at the same time. Sometimes, this is quite annoying, and you want to turn it on. Hither, I talk nigh how to plow this scroll lock on or off in Excel.
Turn on/off scroll lock past press Scroll Lock push on the keyboard
Turn on/off roll lock past click Gyre Lock button on the On-Screen Keyboard
Set coil surface area in Excel
Turn on/off scroll lock by printing Scroll Lock push button on the keyboard
A very easy way to turn on or turn off coil lock is to printing the Scroll Lock button on the keyboard.
Open the Excel, and and so printing
Scroll Lock
push button on the keyboard to plow on information technology. By default, the
Whorl Lock
is off.
If yous want to plough gyre lock off, just need to press the
Curlicue Lock
push again.
Turn on/off scroll lock by click Roll Lock button on the On-Screen Keyboard
If there is no Scroll Lock cardinal in your keyboard, y’all can apply this this method.
Turn on/off scroll lock on the On-Screen Keyboard in Windows seven/Vista
ane. Click
Start
>
All Programs. See screenshot:
2. Then click
Accessories
>
Ease of Access
>
On-Screen Keyboard. See screenshot:
three. And then the
On-Screen Keyboard
appears on the screen, and just click the
ScrLk
button. See screenshot:
Turn on/off scroll lock on the On-Screen Keyboard in Windows 8
ane. Correct click whatsoever blank identify on the screen in the Windows 8, and click the
Personalize
from the context menu.
ii. In the opening folder, click the
Command Pane Home
in the left.
3. Then click the
Ease of Admission
>
Ease of Access Centre
>
Start On-Screen Keyboard
successively in the post-obit iii dialog boxes. See screen shots below.
4. Click the
ScrLk
button on the popping up
On-Screen Keyboard.
Set curlicue expanse in Excel
If you lot just want to display a working area in a sheet i Excel, you lot can apply the
Set Scroll Area
utility of
Kutools for Excel
to set a scrolling area of data you need to read.
After installing
Kutools for Excel, please do as beneath:
（Gratis Download Kutools for Excel Now!)
Select the range y’all want to read and click
Kutools
>
Range
>
Set Scroll Expanse.
If yous want to show all range of the sheet, click
Kutools
>
Range
>
Unhide All Ranges to display the whole canvass.
Relative Articles:
The Best Office Productivity Tools
Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity past lxxx%
-
Reuse:
Quickly insert
complex formulas, charts
and annihilation that you take used before;
Encrypt Cells
with password;
Create Mailing List
and send emails… -
Super Formula Bar
(easily edit multiple lines of text and formula);
Reading Layout
(easily read and edit large numbers of cells);
Paste to Filtered Range… -
Merge Cells/Rows/Columns
without losing Data; Separate Cells Content;
Combine Duplicate Rows/Columns… Foreclose Duplicate Cells;
Compare Ranges… -
Select Duplicate or Unique
Rows;
Select Blank Rows
(all cells are empty);
Super Find and Fuzzy Discover
in Many Workbooks; Random Select… -
Exact Copy
Multiple Cells without irresolute formula reference;
Car Create References
to Multiple Sheets;
Insert Bullets, Cheque Boxes and more… -
Extract Text, Add Text, Remove by Position,
Remove Space; Create and Print Paging Subtotals;
Convert Betwixt Cells Content and Comments… -
Super Filter
(salvage and employ filter schemes to other sheets);
Avant-garde Sort
by month/calendar week/day, frequency and more;
Special Filter
by assuming, italic… -
Combine Workbooks and WorkSheets; Merge Tables based on key columns;
Carve up Data into Multiple Sheets;
Batch Catechumen xls, xlsx and PDF… - More than 300 powerful features. Supports Office/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or arrangement. Full features 30-day free trial. 60-day money back guarantee.
Office Tab Brings Tabbed interface to Office, and Make Your Piece of work Much Easier
-
Enable tabbed editing and reading in Give-and-take, Excel, PowerPoint
, Publisher, Access, Visio and Project. - Open and create multiple documents in new tabs of the same window, rather than in new windows.
- Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!
