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
The Quickest Way Possible To Format Text in Microsoft Word
Microsoft Word is turning 40 and here is our favourite trick to celebrate! Here is how to quickly format text in Microsoft Word. Selecting the Text with Similar Formatting can be made easy, especially handy when you want to change all the headings in a document to a different style, switch a certain font size or even change a footer or header. This can be done by selecting the text in your document that has the formatting you want to change. On the Home tab, click the Editing Group button, Select and Select All with Similar Formatting. Apply a different style or change the formatting for the selected text.

365 Productivity
How to 'copy as a pdf' from OneDrive in a simple step
Once your Word doc is finalised, you'll probably want to 'copy as a pdf' before you forward it on to your client or team. Now it's easy from within OneDrive. Click the three dots next to the File name for more options, go to Automate, and select 'Copy as a PDF' to run the automated flow - it's all set and ready to go, you don't need to do a thing!
365 Productivity
How do I edit multiple Excel sheets at the same time.
To do this, 'Ctrl + Click' each sheet at the bottom of your worksheet. While you have these selected, your formatting changes and formulas will happen across all the selected sheets. What a great time saver!