Exceljet

Quick, clean, and to the point

Select one character left

Windows shortcut

Shift←

Mac shortcut

⇧←

Inside a cell, this shortcut will extend the selection by one character to the left each time the left arrow key is pressed.

222 Excel Shortcuts for Windows and Mac

I now work for a homeless charity and wanted to be able to see how many rooms we have free in the hostel at any given time without manually counting them each time. I knew there would be a way to do it but didn't know how! I spent only a couple of minutes on your site and found the answer: I needed "countif" instead of "count" which I'd been trying and it worked straight away once I got my brackets in the right place!! -Annette

Excel foundational video course

Excel Pivot Table video training course

Excel formulas and functions video training course

Excel Shortcuts Video Course

Excel Charts video training course

Video training for Excel Tables