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
Teams
How to Save a Post in Teams
It's great to know how to save a post in Teams in case you wish to find it again later - this works for Chat messages that you want to save too!
365 Productivity
Outlook Timezones
Working with people in different time zones can be tricky. Even with a simple two-hour difference, use this tip so you can also be mindful of where your overseas colleagues are at.
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!