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! Plan My Week!
Maximize Your Productivity with Copilot in Microsoft Edge
Got a busy week ahead? Don’t worry, Copilot is here to help you stay on top of all your meetings and tasks. With Copilot integrated into Microsoft Edge, you can streamline your workflow and ensure you’re always prepared.
Teams
How to Colour Code Folders in Microsoft Teams
If you're a colour coding sort of person, you'll love the new ability to colour code your folders in Microsoft Teams. Just right click, go to Colour and select from the options available.
365 Productivity
Viva Amplify
Maximise your Employee Engagement with Viva Amplify