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:
- Select the range B1:M1 in Sheet 1.
- Click Sheet1. Press and hold Shift and then click Sheet3. (All three sheets should be selected.)
- Click the arrow of the Fill button in the Editing group of the Home tab. (in Word 2002/2003, go to Edit | Fill.)
- Click Across Worksheets.
Click Formats and then click OK.
Right-click any worksheet tab, and select Ungroup Sheets.