June 11, 2008
Save time reformatting by using Excel’s Fill function across worksheets
Date: May 27th, 2008
Author: Mary Ann Richardson
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 generic propecia review worksheet tab, and select Ungroup Sheets.
Leave a comment
You must be logged in to post a comment.