| Channel | Publish Date | Thumbnail & View Count | Actions |
|---|---|---|---|
 TeachExcel | 2020-05-28 12:00:10 |  108,231 Views |
A quick way to copy entire tables, ranges, data or formatting to multiple worksheets at once; this allows you to quickly cascade changes to multiple worksheets after you have perfected them on one worksheet.
Excel Quickie 46: https://www.youtube.com/watch?v=AWK3jmmMdAs
Excel File: https://www.teachexcel.com/excel-tutorial/2102/apply-worksheet-changes-to-all-worksheets-in-excel?src=yt
Microsoft Docs: https://support.microsoft.com/en-us/office/enter-data-in-multiple-worksheets-at-the-same-time-6223d385-4c75-4dff-9881-67d17972a6c9
This is a great little feature in Excel that I feel like almost no one knows about – usually we just copy/paste or copy/paste special our data and that is usually fine, but it really can be prone to errors and take a lot of time, especially when copying different parts of a spreadsheet in different ways, such as formatting only for some parts and formatting+data for other parts.
Hopefully, this tip can save you some time and make life in Excel a bit easier!
I hope you find this quickie helpful)
TeachExcel.com
#excel #tutorial #excelquickie
Please take the opportunity to connect and share this video with your friends and family if you find it useful.
