Microsoft excel non adjacent range

Back to English. Log in. Remember Me Forgot your password? Password Reset. Please enter the email address for your account. A verification code will be sent to you. Once you have received the verification code, you will be able to choose a new password for your account.

About Us Our team. How to quickly select non-adjacent cells or ranges in Excel? Select non-adjacent cells or ranges with hotkeys Select non-adjacent cells or ranges with Go To feature Select non-adjacent cells or ranges with Kutools for Excel Quickly select non-adjacent cells or ranges with keyboards 1.

With Ctrl key Just press and hold down the Ctrl key, and you can select multiple non-adjacent cells or ranges with mouse clicking or dragging in active worksheet.

The Microsoft Excel's Go to command can help you select non-adjacent cells or ranges quickly with following steps: 1. See screenshot: Note : This method requires user to figure out the cells or ranges position before selecting them. We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at info exceltip. Your email address will not be published. Displaying the Serial Number Behind the Date Selecting Special Cells Adding a Linked Picture to a Chart in Microso Selecting Cells in Horizontal or Vertical Ran Updating Charts by Dragging and Dropping in M Google serves cookies to analyse traffic to this site.

Information about your use of our site is shared with Google for that purpose. This website uses cookies so that we can provide you with the best user experience possible. Cookie information is stored in your browser and performs functions such as recognising you when you return to our website and helping our team to understand which sections of the website you find most interesting and useful.

Strictly Necessary Cookie should be enabled at all times so that we can save your preferences for cookie settings. Thanks for your feedback, it helps us improve the site.

Thanks again Karen. In reply to KarenCharnock's post on March 25, Can you clarify what Excel version and process you used previously for any of the other advisers who may respond here. I also have to apologize for having overlooked that this applies to Excel for Mac - not a platform I use so have no way of checking anything directly.

Vijay A. Verma Volunteer Moderator. What is the method you followed earlier?