Excel: Autofill Weekdays
If you have ever used the fill option in Excel, you know, when you want to fill a series or copy something from a cell just by clicking on the bottom right hand corner of the cell and dragging, then you probably have had it mess up your formatting. I have found this particularly annoying when it comes to borders.
However there is an option to fill without formatting so that it doesn't change the formatting you already have. Whilst I was doing this recording I took the opportunity to show you how to fill just the formatting and not change the data.
Related videos:
Excel Fill/Autofill: • Using AutoFill in Excel
Excel Flash-Fill: • Excel Flash-fill Feature. This is an ...
Excel Fill months and years: • Excel: Fill Months and Years Using Au...
If you want to see more then check out my website http://www.jargonfreehelp.com