Fill Serial Numbers in Excel Efficiently with Formula
#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
Watch video Fill Serial Numbers in Excel Efficiently with Formula online without registration, duration hours minute second in high quality. This video was added by user Jan Composing Centre 04 July 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 540,045 once and liked it 12 thousand people.