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
Those App Icons in Copilot Actually Mean? (And Why It Matters for Your Team)
Have you or someone in your team opened Copilot and wondered what all those app icons actually mean?
Copilot
How to Share a Teams Meeting Recap to Email
Sending a follow-up email after a meeting is a common task. But copying notes from Microsoft Teams and pasting them into Outlook takes time. Teams Meeting Recap now has a Share to email button that does this for you.
Copilot
Use /remember to Make Microsoft Copilot More Personal