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
Excel Conditional Formatting Dates
Start by selecting a column of dates.
Click conditional formatting.
Highlight Cell Rules.
Click A Date Occurring.
Now choose your Date Occurring and Format Colour.

365 Productivity
How to Crop an Image to a Shape
Jump into PowerPoint and on the Picture tools ribbon, you'll find the option to 'Crop to Shape'

365 Productivity
Power Query to Fill Up and Fill Down - super quickly!
Jump in and out of Power Query to clean your data - even for pesky small jobs - so much quicker!