Рет қаралды 68,856
Download the featured file here: www.bluepecant...
In this video, I demonstrate how to automate row numbers in Excel. This will be useful if you are looking for Excel to auto-generate a number sequence or create serial numbers for you. Row numbers can be used to revert back to an original sort order or create a useful ID for your records.
The video will also demonstrate auto-numbering in Excel after a new row has been inserted at the end of your data or between existing rows of data.
The methods shown in this video are:
1) Dragging the fill handle to auto-generate a number sequence
2) Using the Fill Series dialog box to generate a number sequence
3) Using the ROW function to generate a number sequence
4) Using the ROW function within an Excel table to further automate number sequence functionality
5) Using the RIGHT function to add leading zeros to your number sequence
6) Prefixing text to your number sequence, for example XYZ004. This can be achieved with concatenation
7) Using the new SEQUENCE function in Excel 365 with COUNTA to generate row numbers.
------------------------