Select a Range of Cells By Clicking and Dragging

Selecting non-contiguous cells in Excel 2007

To upgrade to the new Google Sheets, click on the settings gear inside Google Drive and click settings. Join over , IT pros Subscribe to our newsletter today. Thank you for Subscribing! By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service , privacy policy and cookie policy , and that your continued use of the website is subject to these policies. Home Questions Tags Users Unanswered.

7 Keyboard Shortcuts for Selecting Cells and Ranges in Excel

There is a way to: Toaster Toaster 1 9. I think there is yet another command to do exactly what is wanted.

Also, OSX defaults this shortcut to the 'applications' command via Mission Control, so this needs to be disabled. I thought you just needed one way, not all possible ways to do it.

  • Office 2011 for Mac All-in-One For Dummies;
  • western digital my passport ultra not recognized mac;
  • mac mail not working well;
  • Select a Large Range of Cells With the Shift Key.
  • How to Easily Select a Block of Cells in Excel!
  • free music download for mac 10.5?

Please update your question if so. Hope it helped either way!

Keyboard Shortcuts to Select Cells

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.


This does not require holding down keys during selection. The Microsoft Excel's Go to command can help you select non-adjacent cells or ranges quickly with following steps:. This method requires user to figure out the cells or ranges position before selecting them.

  • mac os x shortcut app;
  • adobe video converter for mac!
  • pdf annotator for mac free download.
  • Select Non-Adjacent Cells in Excel With Keyboard and Mouse.
  • How to select multiple non adjacent cells… - Apple Community!
  • microsoft lifecam cinema hd mac os x.
  • Selecting non-adjacent cells - Mac Office Excel.

If you have Kutools for Excel , its Select Range Helper tool can help you select multiple non-adjacent cells or ranges in the whole workbook easily. In the Select Range Helper dialog box, check the Union Selection option, next select multiple ranges as you need in the whole workbook, and then click the Close button.

Cell Manipulations (Mac) | ERC

See screenshot:. If need it, please click here to have a day free trial without limitation! Reverse selections of selected ranges.

MS Excel: How to Select Different Multiple Cell, Columns & Rows

Select all cells with data in selections. Increase your productivity in 5 minutes. Don't need any special skills, save two hours every day! Other languages are Google-Translated.