Excel.Tips.Net: Fix Cap Lock Mistakes

By Allen Wyatt for Excel.Tips.Net

Correcting a Cap Lock Mistake in Microsoft Excel

I can’t tell you the number of times that I’ve been feverishly typing away, without glancing up at my worksheet. I get in a “groove,” and I keep typing away, figuring I will check things out when I get to the end of a row or a column. When I finally look up, I notice that I had the Caps Lock key selected, so all my normal text is in uppercase, and everything I wanted in upper case is in lowercase. This happened because I hit the Caps Lock key by mistake, and didn’t notice the mistake until I’d already entered quite a bit of data.

Fortunately, Excel can catch this type of mistake for me—if I tell it to catch it. Follow these steps:

Steps Continued Here

(Visited 12 times, 1 visits today)

2 thoughts on “Excel.Tips.Net: Fix Cap Lock Mistakes

Leave a Reply

Your email address will not be published. Required fields are marked *