Sure, Excel can fill January, February, March, but what about A, B, C or I, II, III? For the upper case alphabet, use a formula of =CHAR(ROW(65:65)) and copy down. For the lower case alphabet, use =CHAR(ROW(97:97)) For upper case Roman numerals: =ROMAN(ROW(1:1)) For lower case Roman numerals =LOWER(ROMAN(ROW(1:1))) Tip: After filling any of these,(…)
Let us suppose that you have serial numbers like “AA10D”, “AA11D” and what you’d like to do is quickly fill Back
1Q and not Q1? What’s with the Fill Handle anyway?
Using the Macro Recorder to Record ‘Fill Down’
Think that you know everything that there is to know about Microsoft Excel? Guess again…