Format Multiple Sheets At The Same Time

Many times we have wanted to format more than one sheet in a workbook, so they all look the same way. For example, we want to fill in the first row and first column of the three worksheets with a light red color. We also want, when we type in the cells for the font to be bold, and the text to be justified in the center.

Well, we don’t have to do the formatting as many times depending on how many sheets we have in our workbook.

The procedure is simple and fast. All we have to do is to press Ctrl+click on the tabs of the worksheets that we want to format. Once we do that, the sheets group together, and the color of the grouped sheets turn white as shown in the image below.

01

If we have a hard time using the Ctrl + click, we can also do a right click on one sheet and from the shortcut menu that appears to select the command Select All Sheets, as shown in the image below.

01a

Now, once the sheets are grouped, whatever we enter into one sheet gets entered in the rest of the sheets. Even in we type in something in a cell of a worksheet; the same text will be entered in the same cell of the other sheets. As mentioned above, I want to fill in the first row and the first column of the worksheets with a light red color, and the font of the text to be bold and justified to the center when I type in something.

In the image below I have arranged the worksheets of the workbook to be shown horizontally at the same time.

While the worksheets are grouped together, I select the first row and the first column and do all the formatting that I mentioned above. For example in the image below I have selected the Home tab and then from the area of the ribbon named Font I have selected the Color Fill button and then selected the color that I wanted to use.

02

In the image below I have finished with all the formatting needed and have even typed in the A1 cell of the first sheet the word January. All the formatting and text appear immediately in the rest of the sheets.

03

Once finished formatting group sheets, we should remember to click on the tabs of the sheets to ungroup them, or right click on them and from the shortcut menu that appears we select the command Ungroup Sheets as shown below.

04

You can also check out the video below, showing the steps in order to apply quick formatting to all the sheets.

About officesmart

MVP: Honored with the MVP (Most Valuable Professional) for OFFICE SYSTEM title for the years 2011, 2012, 2013, 2014 and 2015 by Microsoft, for my contribution and commitment to the technical communities worldwide. Microsoft Master Specialist: This certification provides skill-verification tools that not only help assess a person's skills in using Microsoft Office programs but also the ability to quickly complete on-the-job tasks across multiple programs in the Microsoft Office system

Posted on March 13, 2012, in Excel 2010 English, Microsoft Office 2010 English and tagged , , , , , . Bookmark the permalink. Comments Off on Format Multiple Sheets At The Same Time.

Comments are closed.