Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Select multiple rows not next to each other

How do I select multiple cells, rows, or columns that are not next to each
other?
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: Select multiple rows not next to each other

To select multiple cells, rows, or columns that are not next to each other in Microsoft Excel:
  1. Click on the first cell, row, or column that you want to select.
  2. Hold down the Ctrl key on your keyboard.
  3. Click on the next cell, row, or column that you want to select.
  4. Repeat step 3 for each additional cell, row, or column that you want to select.

To select a range of cells, rows, or columns that are not next to each other in Microsoft Excel:
  1. Click on the first cell, row, or column in the range that you want to select.
  2. Hold down the Shift key on your keyboard.
  3. Click on the last cell, row, or column in the range that you want to select.
  4. Excel will select all of the cells, rows, or columns between the first and last cells, rows, or columns that you clicked on.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1,358
Default Select multiple rows not next to each other

Make your first selection, press and hold the CTRL key, then make your
additional selections.
--
John C


"LarryJNX" wrote:

How do I select multiple cells, rows, or columns that are not next to each
other?

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,856
Default Select multiple rows not next to each other

Hold the CTRL key down while making your selections.

Hope this helps.

Pete

On Oct 14, 4:59*pm, LarryJNX
wrote:
How do I select multiple cells, rows, or columns *that are not next to each
other?


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
select multiple rows and format sdg8481 Excel Discussion (Misc queries) 7 October 5th 08 03:46 PM
How do I Select Multiple Non Adjacent Rows based on a cell value? avalynch Excel Worksheet Functions 2 October 1st 06 07:45 PM
Filter/Select multiple rows a_moron Excel Discussion (Misc queries) 5 January 20th 06 02:41 PM
How do I select multiple rows randomly in MS Excel? Varun Excel Discussion (Misc queries) 2 April 18th 05 08:10 AM
Select all data, multiple rows George Wilson Excel Discussion (Misc queries) 6 December 5th 04 08:16 PM


All times are GMT +1. The time now is 12:23 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"