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 Tidy up Your Microsoft Teams Chat
Pin to find later, Mute if the chat is too noisy and now you Delete - use the three dots next to the Chat to find delete and clear your chat history of any irrelevant chat messages.
365 Productivity
Are Microsoft Lists better than Excel?
Lists are so versatile - add images, hyperlinks, conditional formatting, send alerts and trigger workflows - and they work inside Teams! Get in touch and we'll show you how in our live webinars.