Fill Handle

Excel Fill Alphabet or Roman Numerals

               

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,(…)

Learn Excel – “Fill AA99D Series”: Podcast #1801

               

Let us suppose that you have serial numbers like “AA10D”, “AA11D” and what you’d like to do is quickly fill Back

Learn Excel – “Filling Quarters and Years”: Podcast #1722

               

1Q and not Q1? What’s with the Fill Handle anyway?

Learn Excel 2010 – “Record Fill Down”: Podcast #1519

               

Using the Macro Recorder to Record ‘Fill Down’

Learn Excel 2010 – “Excel Outside The Box”: Podcast #1457

               

Think that you know everything that there is to know about Microsoft Excel? Guess again…

Learn Excel from MrExcel