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: https://youtu.be/2FTxjK60gKM
Excel Flash-Fill: https://youtu.be/18Tirc-VVPA
Excel Fill months and years: https://youtu.be/PC5SguigBYs

If you want to see more then check out my website http://www.jargonfreehelp.com

Please take the opportunity to connect and share this video with your friends and family if you find it useful.