#1   Report Post  
Wazooli
 
Posts: n/a
Default selecting cells

When working with a large group of cells, I find it easier to click the top
cell, scroll to the bottom, and click the last cell while holding the shift
key down. The problem is, when I want to select a second column of data, I
have to select the top cell using the control key, the pull down the cursor
manually. Is there a way to select 2 or more non-adjacent columns without
having to scroll down using the mouse?
  #2   Report Post  
Wazooli
 
Posts: n/a
Default

Nevermind - figured it out myself. The easiest things are often so obvious
they are hard to see.

"Wazooli" wrote:

When working with a large group of cells, I find it easier to click the top
cell, scroll to the bottom, and click the last cell while holding the shift
key down. The problem is, when I want to select a second column of data, I
have to select the top cell using the control key, the pull down the cursor
manually. Is there a way to select 2 or more non-adjacent columns without
having to scroll down using the mouse?

  #3   Report Post  
FGM
 
Posts: n/a
Default

What was the obvious as that is a problem I have had also
and would like to know the answer.

thanks.


-----Original Message-----
Nevermind - figured it out myself. The easiest things

are often so obvious
they are hard to see.

"Wazooli" wrote:

When working with a large group of cells, I find it

easier to click the top
cell, scroll to the bottom, and click the last cell

while holding the shift
key down. The problem is, when I want to select a

second column of data, I
have to select the top cell using the control key, the

pull down the cursor
manually. Is there a way to select 2 or more non-

adjacent columns without
having to scroll down using the mouse?

.

  #4   Report Post  
Wazooli
 
Posts: n/a
Default

If you select a column as described, then select the topmost cell in the
next column you want while holding the control key, simply let go of the
control key and press and hold the shift key while selecting the bottomost
cell of the second row. Try it - - it works!

"FGM" wrote:

What was the obvious as that is a problem I have had also
and would like to know the answer.

thanks.


-----Original Message-----
Nevermind - figured it out myself. The easiest things

are often so obvious
they are hard to see.

"Wazooli" wrote:

When working with a large group of cells, I find it

easier to click the top
cell, scroll to the bottom, and click the last cell

while holding the shift
key down. The problem is, when I want to select a

second column of data, I
have to select the top cell using the control key, the

pull down the cursor
manually. Is there a way to select 2 or more non-

adjacent columns without
having to scroll down using the mouse?

.


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
To safety merge cells without data destroyed, and smart unmerge! Kevin Excel Discussion (Misc queries) 0 December 30th 04 07:17 AM
Heps to design Locked/Unlocked cells in protected worksheet Kevin Excel Discussion (Misc queries) 0 December 30th 04 07:09 AM
Convert data of cells to any type: Number, Date&Time, Text Kevin Excel Discussion (Misc queries) 0 December 30th 04 06:55 AM
Count number of shaded cells Maddoktor Excel Discussion (Misc queries) 2 December 20th 04 08:35 PM
Cells losing formatting BdgBill Excel Discussion (Misc queries) 1 November 26th 04 08:03 AM


All times are GMT +1. The time now is 08:30 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"