How to do an Autofill without numeric increase? 4

[feipezi]

Hi,

This is an Excel question.

If I want to do an Autofill, say, 'ABC1', for 10 cells on the same column. It will turn out like 'ABC1', 'ABC2', 'ABC3',...,'ABC10'. If I want 'ABC1' to repeat for all 10 cells, I will have to Copy. Is there any way like Autofill of producing 'ABC1' for 10 cells and no copying?

Thanks in advance.

 

[SkipVought]

Hi,

Auto fill has the feature of incriminating numeric values. Very helpful.

Copy/Paste has a different feature. Very helpful.

Can't have it both ways.



Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[kjv1611]

I sometimes will autofill, and then tap the pop-up square for "Autofill Options", and from there I can choose "copy" instaed of "autofill". It still doesn't fully help for wanting to do a mix of copy and autofill for a series of columns at the same time. Only way I know to make that work is use formulas in those that should increment and then copy the entire row however many times down.

"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57

 

[SkipVought]

Steve, I do it the hard way. Thx for pointing out the Copy feature in AutoFill.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[apstef]

Hold Ctrl down while dragging down your mouse to autofill by copying and not incrementing values.

 

[kjv1611]

Cool! One thing Microsoft does well is give you oodles of options to do the same thing different ways. Thanks for sharing, apstef!

"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57

 

[mintjulep]

Highlight top cell with desired value and empty cells below it.

CNTL+D

 

[kjv1611]

That's true, but not 100% the same. I do use that one all the time, though. The OP was asking about controlling copy vs autofill when you're copying down multiple rows. Ctrl+D only works for one row at a time.

"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57

 

[feipezi]

Thanks apstef! That's exactly what I wanted. I was not smart enough to have thought about that. Thanks again.

 

[combo]

Resize range holding right mouse button instead left one. Before filling the range excel will display data sensitive (text, number, date) popup menu, choose the option you need.

combo

 

[kjv1611]

Pretty cool, combo! Thanks for sharing. Now if only I can remember the different methods.

"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57