Excel Fill Series
The first video of 2017 demonstrates how easy it is to enter repetitive data into Excel.
Whether you are compiling lists of dates, or amounts, or even months of the year, Excel makes it really simple to do this.
It is clever enough to pick up sequences in your data as well, for instance if you wanted a list of Mondays for the rest of the year. All you need to do is give it enough examples for it to know the sequence you require, and hey presto!
This is one of the reasons I love Excel so much, and why I would recommend it for compiling tables of information rather than using Word. It’s just so much quicker.
To see the library of previous Sarah’s Office Snippets click here