AutoFill Options in MS Excel
Loading...
4,643
Loading...
Uploader Comments (DannyRocksExcels)
see all
All Comments (7)
-
learn from you again. Thank you!
-
Excellent instructional video
-
you are the best, thanks for the excellent explaination.
Loading...
Is there a way to autofill letters & numbers? Such as 1a, 1b, 1c...or 1/3/11a, 1/4/11b...
Thanks! This video really helped me!!
Yankitt 11 months ago
@Yankitt
Hello - Sorry for the delay in responding. In order to AutoFill 1a, 1b,1c, etc. you first need to add these values as a "Custom List" in Excel. If you have a "numeric value" as the 1st or last character in a cell, Excel automatically increments the number (Area 1m Area 2 or 1st Grade, 2nd Grade, etc.
"Custom Lists" are easy to create - I have several videos that show you how - and they are available to all Excel workbooks on your computer.
Danny Rocks
DannyRocksExcels 11 months ago
wow thank u for that sooo much i had been typing in one by one for about 1 yr now..................no more thnx 2 u ;)
cnunez2008 1 year ago
@cnunez2008
I am so pleased that I could help you to save time and keystroks. Thank you for writing to tell me this!
Danny Rocks
The Company Rocks
DannyRocksExcels 1 year ago