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
Смотрите видео Excel: Autofill Weekdays онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь jargonfreehelp 07 Июль 2020, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 14,126 раз и оно понравилось 71 людям.