Software

Save time reformatting by using Excel's Fill function across worksheets

When you need to copy the formatting of one worksheet to other sheets in Excel, this handy trick will streamline the task.

You have three worksheets in your workbook. They are all formatted the same; only the data is different. Each worksheet tracks the sales for all 12 months of the year for one of your three divisions. You've just made some changes to the font color and the background of the cell range B1:M1 in Sheet1, as shown below. You would like to copy that formatting to the other sheets. Follow these steps:

  1. Select the range B1:M1 in Sheet 1.
  2. Click Sheet1. Press and hold Shift and then click Sheet3. (All three sheets should be selected.)
  3. Click the arrow of the Fill button in the Editing group of the Home tab. (in Word 2002/2003, go to Edit | Fill.)
  4. Click Across Worksheets.

Click Formats and then click OK.

Right-click any worksheet tab, and select Ungroup Sheets.


Miss an Excel tip?

Check out the Microsoft Excel archive and catch up on other Excel tips. Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.

Editor's Picks

Free Newsletters, In your Inbox