Рет қаралды 277,713
How to Insert Serial Number Automatically in Excel
Recommend WPS Office-Best FREE alternative to Microsoft Office, Download for Win & Mac & Mobile. Free Download link: bit.ly/3TTDOu6
In this intermediate excel tutorial, I’ll explain an excellent trick for auto numbering in excel. I’ll be using tables and formula for this demonstration. It’s fairly easy and accurate. Let’s follow the instruction below to Add Automatic Serial Number in Excel using formula.
Step 1: First you need to create a table. To do that you need to select the data range. Now from the insert menu click on Table. Or you can press the Keyboard Shortcut CTRL + T. Our table is ready
Step 2: Now we need to write the formula. We are going to use the Rows function here. Learn to use the rows function here: • How to Use ROWS Functi... In the first cell of our table we need to write =ROWS($A$2:[@[Serial No]])
Here $A$2 is the cell from where we need to start auto numbering. [@[Serial No]] this is the column name of the table where we are going to do the automatic numbering. Watch the video for clear understanding.
Important Note: A few things you should consider while using this technique.
1. You can’t delete or remove the first cell where you’ve written the formula
2. If your table has several columns, no matter where you write if the table expands, so does the serial number.
This is how you insert automatic serial number using formula and table in Microsoft excel. Checkout our related video:
How To Insert Date and Serial Number Automatically in Excel Using Formula: • How To Insert Date and...
How to Enter Date and Serial Number Automatically When data is entered in excel:
• How to Enter Date and ...
#Automatic #Serial #Excel
Thanks for watching.
----------------------------------------------------------------------------------------
Support the channel with as low as $5
/ excel10tutorial
----------------------------------------------------------------------------------------
Please subscribe to #excel10tutorial
goo.gl/uL8fqQ
Here goes the most recent video of the channel:
bit.ly/2UngIwS
Playlists:
Advance Excel Tutorial: goo.gl/ExYy7v
Excel Tutorial for Beginners: goo.gl/UDrDcA
Excel Case: goo.gl/xiP3tv
Combine Workbook & Worksheets: bit.ly/2Tpf7DB
All About Comments in Excel: bit.ly/excelco...
Excel VBA Programming Course: bit.ly/excelvba...
Social media:
Facebook: / excel10tutorial
Twitter: / excel10tutorial
Blogger: excel10tutoria...
Tumblr: / excel10tutorial
Instagram: / excel_10_tutorial
Hubpages: hubpages.com/@...
Quora: bit.ly/3bxB8JG
Website: msexceltutoria...