Excel: How to Use Fill Without Formatting

Published: 02 February 2022
on channel: jargonfreehelp
12,641
58

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...  
Excel Fill weekdays:    • Excel: Autofill Weekdays  

This video, like many on my channel, has been created using Camtasia https://techsmith.z6rjha.net/zaqjq0

For more tutorials see my website http://www.jargonfreehelp.com

I am an Amazon an Techsmith affiliate and might earn when purchasing from any of these links. However, this does keep my free tutorials to you going.


Watch video Excel: How to Use Fill Without Formatting online without registration, duration hours minute second in high quality. This video was added by user jargonfreehelp 02 February 2022, don't forget to share it with your friends and acquaintances, it has been viewed on our site 12,641 once and liked it 58 people.