New Horizons Get Schooled Blog

Deselect a cell without starting over with your selection (Excel 2016)

Posted on 12/27/18 10:00 AM by Get Schooled in Microsoft Excel, in excel training, in excel tips & tricks

While selecting a number of cells, it’s easy to accidentally click on a cell you didn’t intend to include. But you don’t have to start over with your selection after every misclick. You can deselect the mistakes.

Press and hold the [Ctrl] key while clicking on any cells you want to deselect. While holding down [Ctrl], you can also click on any additional cells you want to add to your selection.

This feature is only available with an Office 365 subscription.

0 CommentsContinue Reading →

Keep leading zeros in Excel

Posted on 9/30/13 2:18 PM by Get Schooled in Excel, in excel training, in Microsoft, in tips and tricks, in Tips & Tricks

If you need to enter the Zip code 02364 in your Excel spreadsheet, you'll probably throw your hands up when Excel automatically changes the value to 2364. Your Zip code must have five digits, but by default Excel doesn't display leading zeros.

0 CommentsContinue Reading →

Search by Topic

    Lists by Topic

    see all

    Be at the center of it all.


    Knowledge Ninjas

    a web-based service that allows software application end users to access a subject matter expert in real-time via a chat interface to resolve questions or problems they encounter in their specific software.