Tag Archives: excel autofill

How to Use AutoFill in Excel without Changing the Formatting

One of the many tools in Excel that speeds up how you work is Fill, used to be called AutoFill way back, it is how you can quickly make a series or copy values or formulas by simply clicking and … Continue reading

Posted in Excel | Tagged , , , , , , , , , , | Leave a comment

How to Use Excel Flash-fill

Excel has many wonderful features but this is one of my favourites. Its called Flash-fill. It might be easier to watch the video but will try and explain it. If you have a list of data and need to say … Continue reading

Posted in Excel, excel data | Tagged , , , , , , , , , , , , | Leave a comment

Excel: How to Enter the Same Day but Different Month and Year

We all want faster ways to enter data and you’re probably already aware of the autofill feature in Excel. To enter a series of consecutive dates you just need to enter the one date and then click and drag on … Continue reading

Posted in Excel, Microsoft Office | Tagged , , , , | Leave a comment