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

How To Select Non-Adjacent Cells In Excel

select non-adjacent cells in excelI can bet, you never heard that you can select non-adjacent cells in excel without using a mouse.

To select the non-adjacent cells most of the times you use CTRL + Click.

But, now it’s time to change that way.

In this post, I will show you how to select non-adjacent cells in excel without using ctrl key & even without using the mouse.

Without Using Ctrl Key

Just follow these simple steps to do it.

  • Select the cell from where you want to start your selection.
  • Press Shift + F8 for once.
  • You get a message “Add To Selection” on your status barbottom of your excel window. 

Select Non-Adjacent Cells Without Holding Ctrl Key

  • Now, you can select your cells just by clicking on them.

select non continues cells in excel

  • So, you can do anything with your selection (formatting, deleting etc.).
  • Just press ESC to release your selection.

Without Using Mouse

To select non-continues cells without using your keyboard follow these simple steps.

  • Press shift + F8 to activate “Add To Selection” Mode.
  • Navigate to the range you want to include in your selection, Press Shift + F8 again.
  • And, so on.

select no-adjacent cell without using mouse
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.

Conclusion

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.

What is Next?

I hope you like this quick tip. Here are some other quick tips to fasten your work.



  • John Michaloudis

    Hey what a wonderful tip that I have never come across! Great stuff 🙂

    John Michaloudis

    • Puneet Gogia

      Hey John, Welcome to Excelchamps.

      When a master praise you, its an inspiration.

      Thanks for your words.

      Love
      PG

  • عارف وحید کشمیری

    Excellent tricks & useful for office use

    • Puneet Gogia

      ,عارف وحید کشمیری Thanks

  • Pingback: How to Enable PowerPivot In Excel 2010 Using Simple Steps()