|
I'm not sure if this will help but it's worth knowing anyway.
If you highlight a cell, then put you cursor near the bottom right corner of that cell, you should see a small cross appear. Dragging this cross down the column, or across the row, fills those cells with various values which reflect what the first cell contains. It works with formulas, ascending or descending values, days of the week etc. It might do what you require. Using crtl at the same time changes the behaviour of the resulting cell contents.
Have a fiddle and see if it does what you want.
Cheers
Edit, Damien posted his reply while I was typing!
|