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
Windows 11 to help you focus!
There's new features and a clock app in Windows 11 - do a search and check it out. It even syncs with Spotify!
Copilot
Why Does Archiving Matter for Copilot Readiness?
Microsoft Copilot can do incredible things, summarize documents, surface insights, automate tasks, but only if it has clean, well-structured content to work with.
365 Productivity
Viva Amplify
Maximise your Employee Engagement with Viva Amplify