#short #exceltipsandtricks #exceltips #excel #jcc
in today’s video, we’ll learn how to fill serial number column in Excel in an efficient way with the help of a simple formula.
click in the first cell;
enter the formula: =()-RowsAbove
*RowsAbove means the number of Rows above the cell in which you are entering the formula.
Hit enter after the formula and then flash fill the serial numbers.
Now if you want to delete a row or two, the serial numbers won’t be affected.
excel tips and tricks, excel tutorial, microsoft excel, ms excel tips and tricks, excel tips, flash fill in excel,s erial numbers formula,f lash fll serial no, serial no formula, serial no, excel serial number, excel serial no formula, how to fill serial no in excel, fill serial no in excel, autofill serial number, auto fill serial number in excel
Jan Composing Centre