Excel Productivity Guide
Useful Excel Tips | Keyboard Shortcuts | VBA Codes
Download this Free E-Book to take your excel skills to a whole next level using some smart Excel tactics.
Worth $20, Absolutely Free
Normally, when you need to select multiple cells which are not continuing, you press and hold the control key and then select each cell with the mouse.
That’s the simple method.
But I can bet that you have never heard about selecting non-continues cells without using a mouse.
The reason for this is no one ever found this method.
But here’s the kicker:
There’s also a way which you can use to select non-continues cells [non-adjacent] without using control key.
But in today’s post, I’m going to show you exactly two different ways to select all the non-adjacent cells.
Just follow these simple steps to do it.
To select non-continues cells without using your keyboard follow these simple steps.
Note: While trying to select non-adjacent range without the keyboard. When you try to add single cells in your selection, this method will not work.
So, here is the story about this quick and smart way to select non-adjacent cells in excel.
What do you think which method is better to use? First or second. Or, you still want to use ctrl key to select non-adjacent cells in excel.
Give me the answer in the comment box.
I hope you like this quick tip. Here are some other quick tips to fasten your work.