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
How to use Sparklines in Excel
Go to the Insert Ribbon and select the Sparkline you wish to use - Microcharts contained in one cell can help give you a quick visual to analyse data.
365 Productivity
Mastering Outline Numbering in Microsoft Word
Using Tab and Shift and Tab you can quickly change levels for your outline numbering. Tab moves forward and Shift and Tab moves you back a level.
Teams
How to Manage Teams Notifications
Too many notifications on Teams? Try muting a chat and turning off a channel.