Go Back   TechArena Community > Technical Support > Computer Help > Office Help > Microsoft Project
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Formula for serial number in Excel Sheet

Microsoft Project


Reply
 
Thread Tools Search this Thread
  #1  
Old 08-01-2012
Member
 
Join Date: Dec 2011
Posts: 64
Formula for serial number in Excel Sheet

Hi friends recently I have got the problems while working with excel that when I?m making too much rows data like more than 30 thousand, I want to put the serial number by putting formula and it put serial number without scroll or copy system. I don?t know why such thing happen in Excel is there any way to do this in Excel. Is there any built in formula that I can make use for inserting the serial number in Excel Sheet. If you guys have any of the information or any of the suggestion then please let me know. Can anyone help me on this or how to create the formula that works?

Reply With Quote
  #2  
Old 08-01-2012
Member
 
Join Date: Aug 2011
Posts: 539
Re: Formula for serial number in Excel Sheet

According to my suggestion you should try this out May it will help. Place this in the start cell, say in A2: =ROWS($1:1) Then just drag A2 down all the way Or just double click on A2's fill handle (if the adjacent column is filled)
Reply With Quote
  #3  
Old 08-01-2012
Member
 
Join Date: Aug 2011
Posts: 578
Re: Formula for serial number in Excel Sheet

This is simple to do in Excel 2003, so may this will also works on the higher version of excel. For inserting the serial number in to the Excel Sheet, use the List feature in the Data Menu. Use the Table feature in the Insert Tab from the main Ribbon.
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > Microsoft Project
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Formula for serial number in Excel Sheet"
Thread Thread Starter Forum Replies Last Post
How to use Mail Merge from one Excel Sheet to another Excel Sheet Abélard MS Office Support 2 23-02-2012 02:59 PM
How to find total number of duplicates from lists of sheet in excel Kungfu Pandey MS Office Support 2 08-01-2012 04:51 PM
ID and serial number IJAYA Media Player 4 01-05-2011 10:46 PM
Where is the Serial number? Duncan McC MS Office Support 1 29-04-2008 12:47 AM
Win XP serial number Delil Windows XP Support 2 23-03-2008 07:34 PM


All times are GMT +5.5. The time now is 06:58 PM.