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 hide your messy Desktop in Windows 10 or 11
You're busy and maybe you're lazy and that desktop has turned into a junk yard of files. But what if you want to create a good impression -then get some housework done and file them away correctly - or you could just brush those files under the carpet until you have time to sort them!

365 Productivity
How Engaged is your Team on Teams?
Now we can see the Teams Analytics in real time with a Power BI Dashboard - inside Teams!

Teams
How to get your Colleagues in the same room - virtually!
Shake up your virtual meetings by utilising the 'Together Mode' in your next Teams meeting.