Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
I dont' want the automatic fill in EXCEL 2
- Thread starter Davefeet
- Start date
-
1
- #2
SkipVought
Programmer
Dave,
Copy & Paste
1. Copy the Value
2. Select the Range into which you want the value copied to
3. Right-click in the Selection and select Paste from the pop-up menu.
Skip,
metzgsk@voughtaircraft.com
Copy & Paste
1. Copy the Value
2. Select the Range into which you want the value copied to
3. Right-click in the Selection and select Paste from the pop-up menu.
Skip,metzgsk@voughtaircraft.com
- Thread starter
- #3
dirkthedog
Programmer
What version of excel are you using, I have 2002?
[ul][li]If you drag the values using the little black square on the bottom right-hand corner, it drags and auto fills incrementally (big black plus sign).[/li]
[li]If the information is a plain numberic value, it chooses the copy to fill option, if it is a number like yours with the hyphen, it chooses the fill series option. [/li]
(A little menu pops up when you finish dragging so you can choose options for the filling.)
[li]If you drag by pulling anywhere else on the border it moves the information (four-headed arrow).[/li][/ul]
: dirkthebigdog
[ul][li]If you drag the values using the little black square on the bottom right-hand corner, it drags and auto fills incrementally (big black plus sign).[/li]
[li]If the information is a plain numberic value, it chooses the copy to fill option, if it is a number like yours with the hyphen, it chooses the fill series option. [/li]
(A little menu pops up when you finish dragging so you can choose options for the filling.)
[li]If you drag by pulling anywhere else on the border it moves the information (four-headed arrow).[/li][/ul]
:
dirkthebigdog- Thread starter
- #5
-
1
- #6
dianemarie
Instructor
Hi everyone, here's the really quick easy way to control incrementing. Hold Control while you drag. It won't increment. UNLESS it's an integer or decimal with no associated text, hyphens, etc. (such as "1" or "153.2"
. Then you have to hold Control to make it increment (because Excel isn't sure what you want to increment by.) UNLESS you highlight and drag two value cells. For instance you have 5 in the first cell and 10 in the second. If you highlight both cells, you can then drag and you won't have to hold the CNTRL, because Excel will assume you want to increment by 5. Try it, it's a cool trick. Using Control comes in handy if you're copying addresses (10 Main St.) and you don't want the number to increment.
. Then you have to hold Control to make it increment (because Excel isn't sure what you want to increment by.) UNLESS you highlight and drag two value cells. For instance you have 5 in the first cell and 10 in the second. If you highlight both cells, you can then drag and you won't have to hold the CNTRL, because Excel will assume you want to increment by 5. Try it, it's a cool trick. Using Control comes in handy if you're copying addresses (10 Main St.) and you don't want the number to increment.- Thread starter
- #8
DaleWatson123321
Programmer
My 2 cents worth... I'm betting on the "keyboard" - NOT the "mouse" - because the "mouse method" in many situations is SLOWER.
I agree it's nice to know about the "Control" key when "dragging and dropping", and you DON'T want any increment. Thanks, dianemarie!!!
HOWEVER, I have to agree with Skip... i.e. using Copy & Paste can be EASIER and FASTER - especially if one uses <Control> C for Copy, and <Control> V for Paste.
Steps:
1) Use <Control> C on the cell you want to copy.
2) Highlight the "Paste range" (hold down the SHIFT key, and use the DOWN Arrow key and/or PAGE Down key).
3) <Control> V.
I suppose it's always a "personal" thing, perhaps depending on one's "knowledge of the keyboard". However, one should not overlook the FASTER methods.
Hope this is a useful contribution.
Regards, ...Dale Watson dwatson@bsi.gov.mb.ca
I agree it's nice to know about the "Control" key when "dragging and dropping", and you DON'T want any increment. Thanks, dianemarie!!!
HOWEVER, I have to agree with Skip... i.e. using Copy & Paste can be EASIER and FASTER - especially if one uses <Control> C for Copy, and <Control> V for Paste.
Steps:
1) Use <Control> C on the cell you want to copy.
2) Highlight the "Paste range" (hold down the SHIFT key, and use the DOWN Arrow key and/or PAGE Down key).
3) <Control> V.
I suppose it's always a "personal" thing, perhaps depending on one's "knowledge of the keyboard". However, one should not overlook the FASTER methods.
Hope this is a useful contribution.
Regards, ...Dale Watson dwatson@bsi.gov.mb.ca
SkipVought
Programmer
PS...
If you are doing ANY kind of a copy and paste of ONE cell into a column for an ENTIRE table, particularluy a LONG table...
this does it QUICK!
1. Copy
2. If the column does NOT have contiguous data, move active cell to a column that does.
3. Key, End, Down Arrow - this gets you the the last row in the table
4. Move active cell back to the column to paste in.
5. Key, Shift+End, Up Arrow - this selects the paste range
6. Right click in the paste range and select Paste.
Skip,
metzgsk@voughtaircraft.com
If you are doing ANY kind of a copy and paste of ONE cell into a column for an ENTIRE table, particularluy a LONG table...
this does it QUICK!
1. Copy
2. If the column does NOT have contiguous data, move active cell to a column that does.
3. Key, End, Down Arrow - this gets you the the last row in the table
4. Move active cell back to the column to paste in.
5. Key, Shift+End, Up Arrow - this selects the paste range
6. Right click in the paste range and select Paste.
Skip,metzgsk@voughtaircraft.com
- Status
Similar threads