Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / July 2006

Tip: Looking for answers? Try searching our database.

copying multiple cells

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Big Jim - 13 Jul 2006 23:14 GMT
When I try to copy multiple cells that are not in sequence I highlight the
first cell then I use the Ctrl key to highlight the second and after I have
highlighted several cells it wants to jump off the first cell and only
highlight the last cell.  Can someone tell me why?

Signature

Jim

Gord Dibben - 13 Jul 2006 23:50 GMT
Sounds like a light or greasy finger on the CTRL key<g>

Gord Dibben  MS Excel MVP

>When I try to copy multiple cells that are not in sequence I highlight the
>first cell then I use the Ctrl key to highlight the second and after I have
>highlighted several cells it wants to jump off the first cell and only
>highlight the last cell.  Can someone tell me why?
JLatham - 15 Jul 2006 17:01 GMT
I get the 'light-finger' syndrome at times myself <g>

For the copying process there's not much cure except extra care.  For doing
the same type of thing when you're formatting a separated bunch of cells, I
find it safest (even at the cost of a little convenience) to select a bunch,
do the format, select another bunch, repeat...  Nothing like having selected
about a zillion cells and just when you get ready to select the very last
one, having your finger get tired, become slippery or suddenly lose weight!  
[Murphey rules - and he was an optimist]

> Sounds like a light or greasy finger on the CTRL key<g>
>
[quoted text clipped - 4 lines]
> >highlighted several cells it wants to jump off the first cell and only
> >highlight the last cell.  Can someone tell me why?
Gord Dibben - 15 Jul 2006 17:38 GMT
I prefer to use SHIFT + F8 to go into ADD mode.

Then select non-contiguous cells without need for CTRL key.

While on this subject, Chip Pearson has written code which I have on my
right-click menu.

Allows you to de-select a cell or area.

http://www.cpearson.com/excel/unselect.htm

Gord

>I get the 'light-finger' syndrome at times myself <g>
>
[quoted text clipped - 14 lines]
>> >highlighted several cells it wants to jump off the first cell and only
>> >highlight the last cell.  Can someone tell me why?

Gord Dibben  MS Excel MVP
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.