microsoft office, microsoft excel, how to, microsoft, windows, microsoft

xpixel/Shutterstock.com

Scroll Lock in Microsoft Excel makes your Up, Down, Right, and Left Arrow keys either move between cells or scroll the entire worksheet. We’ll show you how to switch between these functionalities on your Windows 10 or 11 PC.

What Does Enabling and Disabling Scroll Lock Do in Excel?

When you disable Scroll Lock and press the arrow keys, Excel lets you move between cells in your spreadsheet. For example, if you press the Down Arrow key, you go down a cell in your worksheet. This is usually the default behavior and allows for quick editing.

If you enable Scroll Lock, on the other hand, Excel lets you scroll your entire worksheet instead of individual cells. For example, if you press the Right Arrow key, your entire worksheet scrolls to the right.

Depending on what feature you feel comfortable using, you can keep Scroll Lock enabled or disabled on your computer.

Enable or Disable Scroll Lock When Using Excel

One way to toggle Scroll Lock on Windows is to press the dedicated Scroll Lock key on your keyboard. This key is usually located in the top-first row of your keyboard, to the right of the Print Screen key.

microsoft office, microsoft excel, how to, microsoft, windows, microsoft

When you press the key, you’ll see the Scroll Lock light turn on on your keyboard (if your keyboard has one). This indicates the option is enabled. To turn off Scroll Lock, press the same key again.

On a MacBook, you can use the key combination Fn+Shift+F12 to toggle scroll lock.

Toggle Scroll Lock Without a Keyboard

If your keyboard doesn’t offer a dedicated Scroll Lock key, use the on-screen keyboard to enable or disable the feature. Open that keyboard by accessing the “Start” menu, searching for “On-Screen Keyboard”, and selecting the app in the search results.

microsoft office, microsoft excel, how to, microsoft, windows, microsoft

When you see the virtual keyboard, to activate Scroll Lock, click the ScrLk button. It will turn blue indicating the lock is enabled.

microsoft office, microsoft excel, how to, microsoft, windows, microsoft

To deactivate the lock, click the same key again.

microsoft office, microsoft excel, how to, microsoft, windows, microsoft

And that’s all there is to using the Scroll Lock in Microsoft’s spreadsheet program. We hope you find it useful.


Did you know you can remap the Scroll Lock button to make it even more useful?

TECH NEWS RELATED

Why You Should Use Multiple Browsers

Google, Mozilla, Microsoft The days of the browser wars are over. Pretty much everybody has decided which browser works best for them. However, you don’t need to be in an exclusive relationship with Chrome, Edge, or Safari. In fact, there are plenty of good reasons to have two or ...

View more: Why You Should Use Multiple Browsers

Q&A with Jeffrey Hicks: The PowerShell 7 Era Is Here

Even if you're PowerShell IQ is somewhat lacking, there's never been a better time to jump in to the powerful automation tool.

View more: Q&A with Jeffrey Hicks: The PowerShell 7 Era Is Here

Microsoft’s SwiftKey Is Leaving the iPhone

Microsoft Microsoft plans to delist its SwiftKey predictive keyboard from the iOS App Store on October 5th, according to a report by ZDNet. The news comes in the form of an email to Senior Contributing Editor Mary Jo Foley replying to a query about why the iOS app hasn’t ...

View more: Microsoft’s SwiftKey Is Leaving the iPhone

10 of the Best Windows App Docks

Windows added – and is still adding – a variety of features to become more user-friendly. However, anyone who’s used macOS would notice one glaring omission: an app dock. As with most things Windows is missing, there are third-party tools to fix it, including Windows app docks, which give ...

View more: 10 of the Best Windows App Docks

How to add Glass effect to Picture, Shape, WordArt in PowerPoint

Microsoft PowerPoint users not only can use PowerPoint only for presentations, but they can also edit or format images as well. If you add certain effects to a picture or shape, PowerPoint has plenty of features that you can use to make your images look artistic. In this tutorial, we ...

View more: How to add Glass effect to Picture, Shape, WordArt in PowerPoint

How to configure and test a Microphone on Steam

Steam is one of the popular gaming platforms with a library of more than 30000 games. These games include both free-to-play and paid games. You can download Steam on your Windows 11/10 PC from its official website. To use Steam, you should have a Steam account. If you do not ...

View more: How to configure and test a Microphone on Steam

Spotify Local Files not showing on Windows PC

Many users complain that Spotify Local Files are not showing on their computers. The Local Files are the ones you add to the Spotify player from your computer. As per the reports, Spotify is either not able to fetch some of the files or show them to the user. In ...

View more: Spotify Local Files not showing on Windows PC

Ion Fury (Mac) 

Ion Fury on Mac Ion Fury is a first-person shooter video game inspired by shooters from the 1990s. The game gives players hours of action and exploration. Old fans of this genre would appreciate the hallmarks of Ion Fury, which are true to a classical ‘90s FPS game. There is ...

View more: Ion Fury (Mac) 

Internet Connection Not Working? 10 Troubleshooting Tips

How to Run Windows 11 in a Virtual Machine

Activision lawsuit demands all the money made from Call of Duty cheats

Persona 5 Royal system requirements – still not Steam Deck verified

Vampire Survivors release date announced for v1.0 update

Intel Unison Will Let Phone Users Text, Share Files From Their PCs

Xbox Has Been in Acquisition Talks with “Major Japanese Publishers” – Rumour

Best N64 Games Of All Time

Hybrid work creating disconnect between employees, leaders: Microsoft survey

Windows 11’s redesigned Outlook app is now rolling out to more users

Windows 11’s new feature to give power users greater control over processes and files

Xbox Games With Gold for October 2022 Revealed

OTHER TECH NEWS

Top Car News Car News