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

Copilot
Copilot and Dog Tricks
AI technology can be a game-changer in how we interact with our pets. It can analyse patterns in your dog's behavior and suggest new tricks tailored to their learning style.

Copilot
How to Use Copilot in Teams Meetings for AI Summaries
If you've got Teams Premium or the Microsoft 365 Copilot licence, then you've just saved yourself some hours with this feature.

365 Productivity
How to Format Slicers in Excel
Slicers are a winning feature in Excel - Slice and Dice data in a simple and user-friendly interface