#1
|
|||
|
|||
Excel sheet Sequence Number
hello,
i have newly joined with this forum. i have query about making sequence number. we can do by using just drag and drop the cell value with series number. But i am having huge number of records it would be about 85000 records which makes me wearied. could i have any suggestion to achive my destination. i would be greatfull if could help me out. Thanks, Bell |
#2
|
|||
|
|||
Hi,
perhaps this is what you want: In cell A1 enter: 1 In cell A2 enter: =A1+1 Now goto cell a85000 (one quick way of doing this is pressing F5 and then enter a85000 + "OK") Now hold down the shift key (don't release it!) Press the button "End" once Press the button "arrow up" once. Now you can release the shift key. You have now marked the area a2:a85000 Now press CTRL+D (or menu: Edit / Fill / Down) Now you have numbers 1-85000 in the cells a1:a85000. If you like to avoid formulas in these cells, do the following. You should still have the area a2:a85000 marked. Press CTRL+C Select menu: Edit / Paste special / values. Best regards Bjorn |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
copy cell from sheet 2 to sheet 3 macro | slipperyjim | Excel Programming | 1 | 02-18-2010 01:31 AM |
Word - Calculate and paste values from Excel sheet | Augf87 | Word | 1 | 07-06-2009 10:26 AM |
Template for Noting Sheet. | Goldenbird | Word | 8 | 05-25-2009 05:48 AM |
Compare data in different columns in an Excel sheet | kgfendi | Excel | 5 | 05-16-2009 05:42 PM |
Enter Number on any sheet one time only. | paulrm906 | Excel | 1 | 04-28-2006 07:35 AM |