A simple solution to numbering a row even if we delete or add a rows in between the serial numbers.
Formula for numbering the row is “=Row()”
What this formula do Row formula allow us to know the row no. in which we are working.
The question raise how we can use this formula for no the rows?
Answer is simple if you had start the counting from row no 10 then the formula will be “=Row()-9” than the cell will reflect value 1.
Use and enjoy working.
Formula for numbering the row is “=Row()”
What this formula do Row formula allow us to know the row no. in which we are working.
The question raise how we can use this formula for no the rows?
Answer is simple if you had start the counting from row no 10 then the formula will be “=Row()-9” than the cell will reflect value 1.
Use and enjoy working.
I was searching this for so log, thanks for sharing.
ReplyDeleteI will follow this blog for my excel learning as i follow http://www.excelrush.com/
That's a very shortcut key. It helps to save time and operate it with more ease. Thank you so much for your useful article.
ReplyDeleteCtrl + ' (apostrophe) To Fill Cell Formulas Down From The Adjacent Cell Above
Very Helpful and informative for me. Find and Replace in Excel tool with additional features..
ReplyDeleteOne of the best Education Pinterest Account.
ReplyDelete