How do I edit multiple Excel sheets at the same time.
When you have data set out in the same format on multiple sheets, you can select all the sheets and perform the same tasks / formulas on each sheet at the same time! Select the first sheet, hold the control key and select the subsequent sheets. These sheets are now grouped. To ungroup the sheets, select any of the sheets that are not part of the group.
Keen to stay up to date on anything 365?
Sign up for tips and updates
You may also like
365 Productivity
How do I edit multiple Excel sheets at the same time.
To do this, 'Ctrl + Click' each sheet at the bottom of your worksheet. While you have these selected, your formatting changes and formulas will happen across all the selected sheets. What a great time saver!
365 Productivity
How to find emails in Outlook by Date
Click the Search bar to activate it - and from there use Advanced Search features to drill down to the required dates.
365 Productivity
How to use Viva to Protect your Time
Microsoft Viva can help you get your work done - Use Viva from your navigation bar in Teams to schedule time to do the doing!