Fill series like Excel
I couldn't find a discussion for adding the "fill series" ability that Excel has.
For example,
Cell 1 = you type in "LM.001.01
Cell 2 = you type in "LM.001.02"
These two entries are enough to establish the rules for the series. In Excel, you then grab the two cells, right click, and drag the selection through the following empty cells. Excel then automatically fills in the correct sequence number for each cell (LM.001.03, LM.001.04 etc).
I'm having to do a lot of manual typing that could be saved with the ability to fill in series. I don't think writing equations would help but I'm open to a suggestion of how it could. Keep in mind that my series definitions are changing constantly, so having to re-do some equation each time is going to be more trouble than it's worth. That's the advantage of Excel's select and drag featu
- Read more about Fill series like Excel
- 12 comments
- Log in or register to post comments