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 to Manually Group Data in Excel
It's so quick to group data in Excel if you select your columns and go to Outline and then select Group. That's it!
Copilot
How to Create your first SharePoint agent
If you've got the Copilot licence - it's time to take the next step! Jump into SharePoint and create an agent. It's easy and this short video will get you up and running and will show you how to share your agent in Teams.
Teams
How to export a Microsoft Planner Plan to Excel?
Exporting Your Microsoft Planner Plan to Excel has Got Easier!