Fill down a column.. Never used macros

[Narseman]

Hi. I want to fill down a known quantity of records. A single column, alpha numerical.
I've never had occasion to use macros, don't know how.
Office 2013 version.

I have a beginning "number" and an ending number. e.g. 34AB20001 - 34AB23009

Is there a simple way to fill the column without dragging down thousands of rows.?

[SlipEternal]

In cell A1, enter the formula ="34AB"&20000+ROW()
Press Ctrl+C to copy that formula (and keep it on the clipboard).
Press Ctrl+G, enter A3009, and click Go To.
Hold down the Shift key. While still holding the shift key, press and release the End key, then press and release the up directional arrow on the keyboard, all while still holding the shift key.
This should result in every cell from A1 through A3009 being selected.
Now, press Ctrl+V to paste the formula to all of those cells.
Then press Ctrl+C to copy all of those cells (this changes the copied range from a single cell to 3009 cells). Right click on the selected cells and click Paste Special -> Values.
It replaces the formulas with the string you want.

[SlipEternal]

Oh, another way to select all of those cells (some people do not like the Shift+End+Arrow shortcut) is to simply type the range you want selected in the box in the top left corner that tells you what named range you are currently looking at. So, another way to do the same thing:
In cell A1, enter the formula ="34AB"&20000+ROW()
Select cell A1, then press Ctrl+C to copy that formula (and keep it on the clipboard).
Click the Name Box and type A1:A3009, then hit Enter
Press Ctrl+V to paste the formula to the range.
Press Ctrl+C to copy the range
Right click and choose Paste Special -> Values.