October 8, 2013

Excel Tricks: Format Multiple Sheets at the Same Time

Written by
Why is TechnologyAdvice Free?

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.

To take your Excel skills to another level check out these courses at TechRepublic Academy.

Technology Advice is able to offer our services for free because some vendors may pay us for web traffic or other sales opportunities. Our mission is to help technology buyers make better purchasing decisions, so we provide you with information for all vendors — even those that don't pay us.