How to Turn Scroll Lock Off (or On) in Microsoft Excel

How to Turn Scroll Lock Off (or On) in Microsoft Excel

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.

How to Turn Scroll Lock Off (or On) in Microsoft Excel

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.

How to Turn Scroll Lock Off (or On) in Microsoft Excel

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

How to Turn Scroll Lock Off (or On) in Microsoft Excel

To deactivate the lock, click the same key again.

How to Turn Scroll Lock Off (or On) in Microsoft Excel

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?

News Related

OTHER NEWS

How to get Brittle Whetstone in Grounded

Screenshot by Pro Game Guides Brittle Whetstone can be helpful in helping you survive for longer and more efficiently navigate the large yard around your miniature self in Grounded. But ... Read more »

Should I fix my mortgage now? UK mortgage rates latest - how much will interest rates rise, will they go down?

UK mortgage rates look set to rise in the coming months, after the announced a While on one of their key policies – the – they appear to be sticking ... Read more »

How to get and use the Grizzco Stringer in Splatoon 3 Salmon Run

Image via Nintendo The Grizzco Stringer is a brand new weapon introduced Splatoon 3’s Salmon Run through the first all-random rotation on October 1. It’s a modified Tri-Stringer that is ... Read more »

Inter vs Barcelona: How to watch on TV live stream, team news, lineups & prediction

Inter & Barcelona will face off | Timothy Rogers | Alex Caparros/Getty Images Inter will host Barcelona on Tuesday in the third round of Champions League group-stage fixtures of the ... Read more »

3 ways to install Win 11 for a machine that does not have enough configuration you should try

Use PC Check Health and be told that it does not meet the minimum configuration to upgrade to Windows 11. This article of GhienCongList will show you 3 ways to ... Read more »

Grounded: How to open the Haze lab and survive the gas

While it might not be as massive as the others, the Haze Lab in Grounded is in the most inhospitable area yet. The whole area around Haze Lab is toxic, ... Read more »

Wondershare Recoverit 2022 review

Slick, powerful, and effective photo recovery, despite high prices and some missing features Read more »

Microsoft APT: North Korean Lazarus Threat Group Targeting Social Media Accounts

Microsoft APT says a threat group is using social media for a phishing campaign that uses bogus job posts to trick workers. Read more »

Windows 11 preview update restores Task Manager button on taskbar

Windows 11’s taskbar is built from scratch and many features are still missing, such as the ability to change its location or a full-fledged right-click menu housing all your favourite ... Read more »

How to get the free Too Cool Fire Fox avatar item in Roblox

Image via Roblox Avatar Shop Did you hear? A new Roblox promo code has finally been released thanks to Amazon! The Too Cool Fire Fox can be redeemed with the ... Read more »

Valkyrie Elysium demo stuck – How To Fix

Image via Sony Valkyrie Elysium is the latest entry in Square Enix Valkyrie series and brings upgraded graphics and gameplay. Fans of the series will be excited, and those new ... Read more »

2022 F1 Japanese GP – How to watch, session timings and more

Fresh from the Singapore GP, where Verstappen endured a messy race weekend to finish in seventh place, the Dutch driver has his second shot at wrapping up the F1 world ... Read more »

Giants Vs. Packers Week 5 Start Time, How to Watch Live From London

Giants-Packers will be the second of five NFL games played outside the U.S. this season Read more »

Leaky Liverpool may have to learn how to defend differently, says Jurgen Klopp

Liverpool — Liverpool are conceding too many similar goals in their matches this season and the players may need to get “back to basics” to tighten the defence to return ... Read more »

9 Of The Best Laptop For Drawing in 2022 – Reviewed

This is a complete buyer’s guide to Best Laptop For Drawing in 2022. 🤴 The best part? All the laptop mentioned in this buyer’s guide is based on the Speed ... Read more »

Halo Developer 343 Industries Swapping Slipspace Engine for Unreal Engine – Rumour

343 Industries is reportedly abandoning its internal Slipspace Engine, which made its debut with Halo Infinite, in favour of Epic's Unreal Engine. Read more »

How Do QR Codes Work?

Sasin Paraksa / Shutterstock.com The humble QR code often feels like a trend or an annoyance. But this technology, which is over 25 years old, is much more useful and ... Read more »

Call Of Duty Modern Warfare 2 Preorders: Bonuses, Editions, And More

Modern Warfare 2 launches October 28 on Xbox, PlayStation, and PC. Read more »

AndaSeat Kaiser 3 XL gaming chair review: "A decently dignified chair for work and play"

GamesRadar+ Verdict The AndaSeat Kaiser 3 boasts all the best bells and whistles for comfort, and its perks largely make up for an annoying assembly process. Pros + Lots of ... Read more »

How to Prepare for a Personal Injury Lawsuit

Photo : cottonbro If you’ve been injured due to someone else’s negligence, you may be considering filing a personal injury lawsuit. While nobody wants to go through the litigation process, ... Read more »

Today in Apple history: CEO Michael Spindler denies Apple is a ‘lame duck’

Apple faced big challenges during the Michael Spindler era. Photo: Ste Smith/Cult of Mac October 3, 1994: Apple CEO Michael Spindler reassures the world that Apple “is not a lame-duck ... Read more »

Inter Milan vs. Barcelona: Preview, date, time, live stream and how to watch Champions League match in Canada

Inter Milan vs. Barcelona: Preview, date, time, live stream and how to watch Champions League match in Canada Inter Milan are in need of a victory. A poor run of ... Read more »

New Maserati GranTurismo fully unveiled with electric and petrol V6 powertrains

Maserati’s Porsche 911 rival will be available with a 750bhp electric powertrain, as well as V6 engine from MC20 supercar Read more »

Steph Curry Is A Playable Character In PGA Tour 2K23

Basketball star Steph Curry is a playable golfer in this year's PGA Tour entry. Read more »

AirPods Pro 2: How to Block Out Loud Noises With Adaptive Transparency Mode

Unveiled with the debut of AirPods Pro 2, Adaptive Transparency is designed to allow the AirPods to block out loud sounds without blocking out all noise. This article explains how ... Read more »

How to Enable Keyboard Haptic Feedback on iPhone

In iOS 16, Apple has included an option for you to turn on haptic feedback when using the onscreen virtual keyboard. This article explains how to turn it on and ... Read more »

BLUELOCK Offers a Grim View of Sports Anime You’ve Never Seen Before (Episode 1 Preview)

If one were to base their opinion of the new Football anime BLUELOCK on the Sports anime genre’s norms, they wouldn’t be blamed for expecting another show about hot guys ... Read more »

Cyno’s Special Dish Recipe and how to cook it in Genshin Impact

Screenshot by Pro Game Guides Cyno, the General Mahamatra, may seem stern at first glance, but his penchant for throwing the dryest of jokes (and making it a point to ... Read more »

Get Microsoft’s Ultra Thin Surface Pro X For $400 Off This Week

Microsoft Microsoft’s vision of mobile laptop computing has often differed from Apple’s perspective. While the latter prefers to sell two different devices with overlapping qualities (MacBook + iPad), the former’s ... Read more »

Amazon’s Fire TV Sticks Are at Their Lowest Prices Yet

Picturesque Japan/Shutterstock.com Amazon’s Fire TV lineup of streaming sticks is very popular. Any of them can be a great addition to any TV, and they’re also pretty cheap. Right now, ... Read more »

PC Power Consumption Is Getting Out of Control

Kreabobek/Shutterstock.com Innovation in the PC space is fast-paced these days, but that’s coming at a cost. As the hardware in our PCs keeps getting better, power consumption is spiraling out ... Read more »

Lenovo’s Smart Clock With Alexa Is $30, Its Lowest Price Yet

Lenovo Lenovo’s lineup of tiny smart speakers with clock displays has been around for a while, available with either Google Assistant or Alexa. Now you can grab the Lenovo Smart ... Read more »

Studying in UK? ICICI Bank announces bank accounts for Indian students; learn how to activate

Representational image | (Photo by Punit PARANJPE / AFP) One of India’s most prominent banks, ICICI Bank, has announced services for Indian students in the United Kingdom (UK) called ‘‘HomeVantage ... Read more »

How to Make Money with NFTs - 8 Best Methods for 2022

Disclaimer: The Industry Talk section features insights by crypto industry players and is not a part of the editorial content of Cryptonews.com. Non-fungible tokens (NFTs) operate in a fast-growing marketplace. ... Read more »

YouTube starts asking users to subscribe to Premium for 4K videos

WTF?! It might sound like a terrible idea, but YouTube could start charging users who want to watch videos on the platform in 4K, making the resolution exclusive to its ... Read more »

Dead Space Remake Gameplay Reveal Coming On October 4

In space, no one can hear you livestream. Read more »

Google Stadia Had Big, Disruptive Ideas That Others Should Steal

A Stadia that resembled Google's original pitch could have had a major impact on the industry. Read more »

Giant Bomb, GameSpot, MetaCritic, GameFAQs and more have been acquired by Fandom

As of late, the games industry has felt a little all over the place. We’ve seen countless acquisitions: Microsoft bought ActiBlizz, Sony acquired Valkyrie Entertainment, Quantic Dream was more recently ... Read more »

Best 12V tyre inflators 2022

We put the pressure on eight rivals to find the top performer Read more »

First Drive: 2023 Chevrolet Corvette Z06

There will never be another Chevrolet Corvette like the C8-generation Z06. I am certain that faster Corvettes will come in the future, but they won’t be like this. Let me ... Read more »
Breaking thailand news, thai news, thailand news Verified News Story Network