"Offering free computer help, hints, and tips to the Internet populace." Now with over 3,820 tips!

Microsoft Excel 2010

Add Caps Lock, Num Lock, Scroll Lock Indicators

SUMMARY: See at a glance whether or not the Caps Lock, Num Lock, or Scroll Lock buttons have been pressed via indicators on the Excel 2010 Status Bar.

By default, Microsoft Excel 2010 displays an indicator in the status bar whenever the Scroll Lock key has been pressed. This is useful as when Scroll Lock is selected, pressing cursor keys do not move the cell selection, instead scrolling through the current worksheet.

However, keyboards normally have two other locks available - Caps Lock and Num Lock. Unless you have software that automatically displays this information in the Windows taskbar or other location, might it be useful to see onscreen whether one or all of these locks are active? Luckily making this change is easy:


1. Right-click an empty area of the Excel 2010 Status Bar.

2. Underneath the pop-up menu "Customize Status Bar", check or uncheck "Caps Lock", "Num Lock", and / or "Scroll Lock" as desired.


Customizing the Excel 2010 Status Bar to show indicators for the Caps, Num, and Scroll Lock keys

Return to the Microsoft Excel 2010 page.

Print this tip


Get the Newsletter

blog comments powered by Disqus

Thanks For Sharing!



Newest Tips:

Mozilla Firefox - Plugins and Extensions
Grab a Word Count and Readability Score of Selected Text
Internet Explorer 11
Place Sites Directly in the Start Menu for Easy Access
Windows 8
Tweak the Explorer Navigation Pane
Windows 8
Stop Rearranging My Windows!

Follow Us!

About MalekTips and the Author

The MalekTips website was created in 1998 by Andrew Malek of Envision Programming. The page's goal is to freely disperse computer-related tips, hints, and informative articles. Tips are organized to be easy to find, and are presented clearly, in easy-to-understand language. MalekTips also provides information and links to public-domain, open source, freeware, shareware, and commercial software available for download.