Forum Discussion
Numbering with prefix, without dragging
- Let's say you want to start in row 2. Select the range, starting in that row, that you want to number, for example A2 to A100. Enter the formula ="AHJS"&(ROW()+998) Confirm with Ctrl+Enter.
How to do it so that the numbers remain the same even after moving to another row? To make them static values.
That is what you would get if you entered the first value in a cell, then dragged down. But you didn't want that...
Because I have thousands of lines, do you know of any alternative?
If you want the values in a column adjacent to a populated column that has no blanks, you can enter the starting value in the first cell, then double-click the fill handle in the lower right corner of the cell. Excel will automatically fill the column down to the last used row.
Alternatively, enter the starting value in the first cell. With that cell still selected, scroll down and then hold down Shift while selecting the last cell. On the Home tab of the ribbon, click Fill > Flash Fill.
Thank you very much 😉