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.
Date: May 27th, 2008
Author: Mary Ann Richardson
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:
-
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.
Date: May 27th, 2008
Author: Mary Ann Richardson
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.
generic propecia fda border=”0″ width=”500″ height=”313″ />
-
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.
generic brand propecia title=”http://ct.zdnet.com/clicks?t=55498512-fcda8243b2af06197976dd4e0ab0dea0-bf&brand=ZDNET&s=5″>Xobni
Quickly find e-mail messages and attachments in your Outlook inbox.
License: Free
OS: Windows XP/Vista
I am currently using this software and am impressed after the first day. I am still processing the power of this plug-in. To get an idea what Xobni (Inbox reversed) does, watch their presentation video: http://www.xobni.com/learnmore/
Here is the user manual: http://www.xobni.com/media/xobni_user_manual.pdf
Are there times when you find MS Excel's gridlines more distracting than helpful?
Wish there was a way to get rid of them and just view a clean worksheet?
If you answered yes, I've got exactly what you're looking for!
Gridlines in older versions of Excel are controlled through the Options window (Tools menu, Options choice).
Once you're in the Options window, you're looking for the View tab.
Under the View tab, you need to uncheck the Gridlines box in the Window Options section.
Then click OK.
If you're working with Excel 2007, buy online propecia you're looking for the View ribbon, Show/Hide section.
Again, you'll need to uncheck the Gridlines option to hide them.
Regardless of the version you're using, at this point, your gridlines have vanished, leaving you with a clean sheet!
