Who Needs Mice? Smart Selection In Excel


Mice were good for Cinderella.  For Excel users?  Not so much.

Here at Spreadsheet Sherpa, we work with clients all the time who take the loooooong road using their mouse because the shortcut--using the keyboard--feels just a bit too scary.

Let's start simple!  As the video shows...

SHIFT + ARROWS

This turns multiple cells dark gray, letting you know they are ready for all kinds of fun activities... cutting, copying, bolding, deleting, and so on.

CTRL + LEFT MOUSE BUTTON

Ok, so we couldn't completely get rid of our mouse... but you won't use this one that often.  You're MUCH more likely to use...

CTRL + SHIFT + RIGHT/LEFT ARROW

No lie, this feature was my turning point from hating to loving Excel.  Holding CTRL, then holding SHIFT, then pressing the RIGHT ARROW selects every cell in the row until it hits a blank cell.  WHOA!

CTRL + SHIFT + UP/DOWN ARROW

Selects all the filled cells upwards or downwards.  YES!

CTRL + SHIFT + RIGHT + DOWN

Selects a whole block of text, great for copying and pasting everything you're working on.

Need help?  Just call!  Rather than spend your time trying to become an Excel expert, we can fix it for you in minutes!  Give us a jingle at 877.851.0132 today.