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
Watch video Excel: Autofill Weekdays online without registration, duration hours minute second in high quality. This video was added by user jargonfreehelp 07 July 2020, don't forget to share it with your friends and acquaintances, it has been viewed on our site 14,126 once and liked it 71 people.