filmov
tv
Make the same changes to multiple Excel sheets

Показать описание
How to use Excel's grouping sheets feature to make a change on one sheet and have the exact same change happen to many other sheets instantly. Useful for formatting and name changes (client name) as well as correcting formula on many sheets at the same time.
------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------------------------------------
⏲Time Stamps
00:00 Making the same change to multiple worksheets in Excel
00:20 Change the name cell on all sheets (client name)
01:00 Change colors on all sheets at the same time
01:07 Change the formula on all sheets at the same time
01:45 SWITCH OFF GROUPING WHEN DONE- Sheets will have contents of other sheets
------------------------------------------------------------------------------------------------------------------------------------------------------
------------------------------------------------------------------------------------------------------------------------------------------------------
⏲Time Stamps
00:00 Making the same change to multiple worksheets in Excel
00:20 Change the name cell on all sheets (client name)
01:00 Change colors on all sheets at the same time
01:07 Change the formula on all sheets at the same time
01:45 SWITCH OFF GROUPING WHEN DONE- Sheets will have contents of other sheets
-
AuditExcel Advanced Excel and Financial Model Training and Consulting
-
making the same change to multiple worksheets
-
how to enter same data in multiple sheets in excel
-
example of using multiple worksheets
-
enter data in multiple worksheets at the same time
-
how to create multiple sheets in excel with same format