Save time reformatting by using Excel's Fill function across worksheets
Thursday, July 03, 2008 11:03 AM
Use the Fill function to carry out actions such as implementing font color changes in all or some of the worksheets in your workbook.
Microsoft Excel
Save time reformatting by using Excel's Fill function across worksheets
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.
Microsoft Access
Let Access keep track of the date and time of the last record update
Do you need to query your data by the last date modified? For example, say you would like to include donors whose records show no activity during the last six months in a special fund-raising appeal. How do you know which donors are to be included?
Follow these steps:
- Add a field to your Donors table called Date Modified and assign it a Date/Time data type. Then, open the form used to update the table in Design view.
- Open the form’s property sheet.
- Click in the Before Update property box in the Event tab.
- Click the Build button and select Code.
- At the prompt, enter the following code:
Me![Date Modified].Value=NOW()
- Press Alt + Q.
Now each time a user changes a record, Access will enter the date and time from the system before the changes are updated. When the record is accessed again, the Date Modified field will contain the date and time of the last modification.
You can query that field to determine which records have not been updated within the last six months.
Microsoft Word
Create a watermark using a Clip Art Gallery image
While you can use Word's Printed Watermark dialog box to add a custom watermark to your document, Word also lets you create a watermark from any graphic object (SmartArt, charts, shapes, clip art, etc.) by simply copying the graphic into the Header window.
Follow these steps to create a watermark from a copy of a picture taken from the Clip Art Gallery:
- Open a blank document.
- Go to Insert |Clip Art. (In Word 2007, click the Insert tab and select Clip Art in the Illustrations group.)
- Search for the desired clip art in the Clip Art task pane.
- Go to View | Header or footer. (In 2007, double-click the top of the page to access the Header area.)
- Click inside the Header window.
- In the Clip Art task pane, double-click the clip art picture you want as your watermark.
- Right click the portion of the picture in the header window and select Text Wrapping.
- Click the Behind Text option.
- Right-click the portion of the picture in the Header window and then select Send To Back.
- Click Send Behind Text.
- Click and drag the bottom-right picture handle to extend the picture into the middle of the document beyond the header.
You can also format the picture to make it more transparent. For example, in Word 2007, follow these steps:
- Double-click the Header to display the Header window.
- Right-click the picture in the Header window and then select Format Picture.
- Click the drop-down arrow of the Recolor button and click the first selection under Light variations. (Alternatively, you can choose Washout under Color Modes.)
- Click Close.
» Blades for superior performance
There are currently no comments for this post.