Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-14-2011, 03:20 PM
mit mit is offline need autonumber in my excel file Windows XP need autonumber in my excel file Office 2003
Novice
need autonumber in my excel file
 
Join Date: Jun 2011
Posts: 2
mit is on a distinguished road
Default need autonumber in my excel file


hi,
I have an excel file with data,I need to add an Id column and create numbers from 1 to .... (as much as records It has).like autonumber in access.
It has already had data,I do not want to enter data for other columns.
Reply With Quote
  #2  
Old 06-15-2011, 11:20 AM
OTPM OTPM is offline need autonumber in my excel file Windows 7 32bit need autonumber in my excel file Office 2010 32bit
Expert
 
Join Date: Apr 2011
Location: West Midlands
Posts: 981
OTPM is on a distinguished road
Default

Hi
Please find herewith a solution. I have put an auto number formula in the first 100,000 rows. When you enter a value in each consecutive cell in column B from B2 downwards the number in column 1 will automatically increase by 1 from the previous row.
Bear in mind that if you use this you will need to specify which pages to print when you want to print the document or you will end up printing 100,000 rows.
Hope this helps.
Tony (OTPM)
Attached Files
File Type: zip Auto Number column 1.zip (306.8 KB, 23 views)
Reply With Quote
  #3  
Old 06-21-2011, 10:56 PM
Catalin.B Catalin.B is offline need autonumber in my excel file Windows Vista need autonumber in my excel file Office 2007
Expert
 
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default

or you can view this thread for another option..
https://www.msofficeforums.com/excel...numbering.html
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
need autonumber in my excel file Excel File Association freeworld Excel 3 12-09-2011 10:07 AM
need autonumber in my excel file File 'Versions' in Excel 2010 keithg Excel 2 02-19-2011 07:44 AM
need autonumber in my excel file Help with Excel file cjv4life Excel 2 01-24-2011 12:53 PM
need autonumber in my excel file Need an Automated sql query for the Excel file Karthick Excel 3 12-20-2010 04:52 AM
need autonumber in my excel file Some Excel File Will Not Open cgoodlein Excel 5 05-19-2009 04:46 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 04:48 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2023, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2023 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft