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 save your Signature for use in Microsoft Word.
Never lose your signature or have to create it again! Use an electronic pen to draw your signature. Click Win + Shift to screen capture your signature. Paste into a new page by clicking on Ctrl + V. Go to Insert and save image as a QuickPart. Create new a new Building Block. Insert Quickpart! Now your signature will always be there for you to use!
Teams
How to use Teams to book your Hot Desk
Use the Microsoft Bookings app to manage your Hybrid work needs from inside Teams. Book a desk before you go into the office and have visibility of who is sitting where. Perfect when you need to be socially distant.
365 Productivity
How to show all formulas in Excel
Next to your number 1 key on the keyboard is the magic "tilde" button.
Use ctrl + ` to show formulas and ctrl + ` to hide formulas.