Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

At work, we use Microsoft Office 2003, and we have to write many numbers that are sequential, e.g. 2590, 2591, 2592, etc. These numbers are either in Excel or in a Word table.

How can I automatically get one (or both) of these programs to automatically write out or provide the next number in the sequence?

share|improve this question
    
As part of a list, table, within the text? –  random Jul 22 '10 at 21:43
    
i have a full page table in MSWord that has a column of just the sequential numbers, not necessarily within text, but the numbers are each in their own box, make sense? –  studiohack Jul 22 '10 at 21:59

2 Answers 2

up vote 2 down vote accepted

Highlight one or more cells in the sequence and drag the bottom right-hand corner to the cells you want to fill with that sequence. If, for example, you highlight the first three rows that are filled with 1, 2 and 3 and drag down the bottom-right corner, it'll determine the pattern and fill accordingly. If you only highlight one cell, it may copy that number to all of the target cells or it may fill them in sequentially -- the more data you give it (highlighted cells before you grab and drag), the better it'll guess what the pattern is. If it chooses incorrectly (usually based upon what you did last time -- either copy cell contents or continue the sequence), there's a little icon that pops up after the operation on the lower-right corner. Select that icon and select "Fill Series."

This works with Excel, but not sure about tables in Word.

share|improve this answer
    
works really well! Thanks! –  studiohack Aug 4 '10 at 13:21

About Word, you should use a "seq" field. All you have to do is press ctrl-f9 and type SEQ followed by a space and a name for your numbering (in order to remember it, if you use multiple numberings), SEQ sequential_test1 for example. This should appear like {SEQ sequential_test1} . Each time you use this field, it will be replaced by a sequential number. You can learn more about this particular handy feature, in Microsoft's Office help website

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.