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
Discover the New Outlook Features: Snooze and Org Explorer
Outlook has introduced two amazing new features: Snooze and Org Explorer. With Snooze, you can temporarily remove emails from your inbox and bring them back at a time that suits you, helping you stay organised and stress-free. Org Explorer lets you easily navigate your company's structure, making it simple to find colleagues and understand reporting lines. Give these features a try and see how they can enhance your productivity and connectivity!
Teams
How to Manage Teams Notifications
Too many notifications on Teams? Try muting a chat and turning off a channel.
365 Productivity
How to add a File Path to Word and Excel Documents
It's great to know where things are stored, particularly when sharing files. Include the file path to make it easy!