 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / November 2006Drag down to fill in, but copy, not increment?
I can hold the CTRL key and copy a cell down one row. Is there any way to drag the corner down like you do to fill in an incrementing series, but instead copy the same value down through the whole range? Ed It depends on what you select. If you select two cells (say A1:A2 and a1=a2), then you'll get what you want. But personally, if I don't remember what excel will do when I drag down, I'll rightclick on that autofill button and drag down. When I let go, I'll see a menu of choices and I can do what I want. > I can hold the CTRL key and copy a cell down one row. Is there any way to > drag the corner down like you do to fill in an incrementing series, but > instead copy the same value down through the whole range? > > Ed  SignatureDave Peterson *Right* click and drag - I'd forgotten that one! Thanks, Dave! Ed > It depends on what you select. If you select two cells (say A1:A2 and > a1=a2), [quoted text clipped - 12 lines] >> >> Ed Saves wear and tear on the brain, too! > *Right* click and drag - I'd forgotten that one! Thanks, Dave! > [quoted text clipped - 20 lines] > > > > Dave Peterson SignatureDave Peterson Ed, Hold Ctrl as you drag the Fill Handle. SignatureEarl Kiosterud www.smokeylake.com ----------------------------------------------------------------------- >I can hold the CTRL key and copy a cell down one row. Is there any way to >drag the corner down like you do to fill in an incrementing series, but >instead copy the same value down through the whole range? > > Ed I tried that, Earl, but it kept wanting to increment. I'm using XL 2002. Ed > Ed, > [quoted text clipped - 5 lines] >> >> Ed Ed Earl's method should work. Try this one............ Right-click and drag. Release button and select "Copy Cells" Gord Dibben MS Excel MVP >I tried that, Earl, but it kept wanting to increment. I'm using XL 2002. > [quoted text clipped - 9 lines] >>> >>> Ed Ed, Interesting. If it's text ending in digits, e.g.: "Dept1", the Fill Handle it normally increments, but the Ctrl key stops the incrementing. If it's a number, it's the other way around. I'm wondering what you have in the cell. SignatureEarl Kiosterud www.smokeylake.com ----------------------------------------------------------------------- >I tried that, Earl, but it kept wanting to increment. I'm using XL 2002. > [quoted text clipped - 9 lines] >>> >>> Ed Ed, If you let go of Ctrl before you've released the mouse button, the Ctrl has no effect. It only looks at the Ctrl key at the moment you let go of the mouse button (you don't have to have pressed it when you first started dragging). Could that be it? SignatureEarl Kiosterud www.smokeylake.com ----------------------------------------------------------------------- > Ed, > [quoted text clipped - 16 lines] >>>> >>>> Ed Earl: That's exactly the behavior - with a number in the cell, I'm trying to copy the contents down, so I hold the Ctrl key, and it increments! _Now_ I find that it's ~supposed~ to work that way??! 8>O Okay - so for numbers I _don't_ use Ctrl, but for text I _will_. Got it! Thanks. Ed > Ed, > [quoted text clipped - 16 lines] >>>> >>>> Ed >Earl: > [quoted text clipped - 5 lines] >Thanks. >Ed As an aside (and IIRC :) ) you can make this explicit by filling the first 2 cells, then dragging the 2 cells down. eg 2 in the first cell and 2 in the second and dragging both will copy 2 and not increment. In fact, this is a great way to repeat any pattern (1,2,3 ... or whatever). :)
|
Reply to this Message |
 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.