October 8, 2013

Excel Tricks: Format Multiple Sheets at the Same Time

Written by

Have you ever been frustrated by the amount of time it takes to format your Excel documents? Good news, there’s no need to keep wasting time by applying the same formatting styles over and over. With this easy trick you can select multiple sheets and format them all at once. It’s easy and will save you lots of frustration. Check out the video below:

As a recap – here’s how to format multiple sheets at the same time:

1. Ctrl + Click each sheet tab at the bottom of your worksheet (selected sheets will turn white).

2. While selected, any formatting changes you make will happen in all of the selected sheets.

3. Double-click each tab when you are done to un-select them.


Check out all all of our videos and subscribe to our official YouTube channel.