|
Autonumbering will advance your numbered rows and keep them current, even if you should delete or add a row. Unfortunately, MS Excel does not ship with an autonumbering feature (like that found in MS Access), that increments a number each time you add a new row. In Excel 2003 and 2007 however, you can use the Row function to add your own autonumbering to a list. Say you want to create a list of all of your school's classes and their corresponding learning materials.
Follow the steps below to add autonumbering to the list: - In A1, enter the formula below:
- =TEXT(Row(A1),"000-000")
- Enter the name of the first class in B1.
- Enter the learning material of the first class in C1.
- Copy cell A1 to A2.
- Enter the name of the second class in B2.
- Enter the learning material of the second class in C2.
- Select A1:C2.
- Go to Data | List and select Create List.
- In Excel 2007, press CTRL + T and then click OK.
Notice, that when you type the name of the next class in B3 and press Tab, MS Excel will automatically provide the next number for you. When you become a member at CarolsCornerOffice.com, you have access to this and many, many more articles that include screenshots. Don't delay: visit us today!
-- Related newsletter articles:
2007/11/29 Use Shortcut Keys to Evaluate Data in MS Excel (row)
2007/09/20 YouTube 101 (class)
2007/02/13 New Excel Attack Threatens Office (excel)
2004/10/21 Change MS Word user ID? (ms)
2007/11/12 Multiple Sheet Selections in MS Excel (excel)
2007/05/17 Microsoft's Latest Fiasco: Reader Response (ms)
2006/07/13 MS Excel Security Leaks Becoming Flood (excel)
-- Recent articles (from all channels): 2008/05/12 Today in History: for Monday, May 12, 2008
2008/05/12 [ShellX 20080512]: 'Remote Manager', and 'Cyber Bandwidth ...
2008/05/12 Video Gaming Trade Group Struggling
2008/05/12 T-Mobile Finally Joins 3G Phone Race
2008/05/12 Apple Slammed by Environment Watchdog
2008/05/09 [ShellX 20080509]: 'Advanced Run', and 'Diver Windows Manager'
2008/05/09 Texas Refuses Facebook Friend Request
2008/05/09 Photo-Enforcement Technology Replaces Officers On Patrol
2008/05/09 Cuban Government Says 'Ok Computer'
2008/05/09 Excel Can E-Mail Your Weekly Reports For You!
2008/05/08 [ShellX 20080508]: 'Shell Enhancer', and 'Lansweeper'
2008/05/08 Xobni: MS Outlook Social Networking Technology for your Inbox
2008/05/08 Music Companies Jump on GTA IV Bandwagon
2008/05/08 Fascinating: Memristor to replace Binary
2008/05/08 Adobe Hopes To Make Flash Master Of The (Mobile) Universe
2008/05/08 Spiffy Envelopes and Labels in MS Word
2008/05/07 [ShellX 20080507]: 'Winbin2iso', and 'Loop Typer'
2008/05/07 Yahoo Adds Security Warnings To Search Results
2008/05/07 Apple to Lose Money on iTunes Movie Releases
2008/05/07 Amazon.com takes New York Tax to Court
2008/05/07 Need Glasses for the Slide Sorter View in MS PowerPoint?
2008/05/07 After Winning The DVD Format War, Blu-Ray Sales Tank
2008/05/06 [ShellX 20080506]: 'Visual Basic 6.0 Portable', and 'Double-...
2008/05/06 Yahoo Outsources to Jajah
2008/05/06 New HP Circuit Could Change Technology Forever
2008/05/06 Movie Downloads To Match DVD Release Dates
2008/05/06 Microsoft Ends Yahoo Bid
2008/05/05 [ShellX 20080505]: 'Ie7 Pro', and 'Desktop Ok'
2008/05/05 The WB Network Hops Online
2008/05/05 Microsoft Slashes Price of Xbox 360 Overseas
2008/05/05 Google CEO Wants YouTube to Take More of Your Money
|
