 How do you ensure that the End Date is greater than the Start Date in a cell?
|
Summary: Data Validation lets you ensure that the data entered into a worksheet meets certain standards. Here is how to do this to make sure that the End Date is greater than the Start Date in a cell:
- Select the range of cells for which you want to apply Data Validation.
- From the Data tab, in the Data Tools group, select Data Validation.
- From the Allow drop-down box, select Date.
- From the Data drop-down box, select Greater Than.
- From the Start Date Box, enter the cell where the first Start Date appears.
- Select OK.
You can now enter in the dates, and if you try to enter a date that is earlier than the Start Date, you will get an error message.
|
How do you prevent 0 values from showing in a PivotTable?
|
Summary: To prevent 0 values from displaying in a PivotTable you need to apply an AutoFilter. Here is how to do this:
- Select the cell to the right of the last heading on the PivotTable.
- From the Data tab, in the Sort & Filter group, select Filter.
- Select the drop-down arrow from the Value heading.
- Deselect 0.
- Select OK.
The 0s will all be hidden.
|
Back to top
Summary: There are times when you want to sum the positive and negative numbers in a column of numbers separately. The easiest way to do this is with the SUMIF function.
- To add just the positive numbers, select the cell where you want the sum to be placed.
- Enter the formula =SUMIF(A2:A7,">0").
- Press Enter.
- To add just the negative numbers, select the cell where you want the sum to be placed.
- Enter the formula =SUMIF(A2:A7,"<0")
- Press Enter.
The screen shot below shows you an example.
Back to top |
| Indenting a Paragraph
Summary: Indenting a paragraph to move the left or right edge (or both) inward toward the centre is a useful technique in formatting a Word document. Here is how to do this:
To move the left edge of an entire paragraph to the right:
- Click in the paragraph to select it.
- In the Home tab paragraph group, click Increase Indent one or more times to indent the left edge a half-inch each time (the first click will move the left paragraph edge to the nearest half-inch or inch mark).
To move the right edge of an entire paragraph to the left:
- Click in the paragraph to select it.
- In the Home tab paragraph group, click Increase Indent one or more times to indent the right edge a half-inch each time (the first click will move the right paragraph edge to the nearest half-inch or inch mark).
Back to top
Creating horizontal lines as you type
Summary: Adding horizontal lines to a Word document can make it easier to read. Here is how to do this:
- Press Enter to create a new paragraph.
- Type --- (three hyphens) and press Enter.
- A single light horizontal line will be created between the left and right margins.
or - Press Enter to create a new paragraph.
- Type === (three equal signs) and press Enter.
- A double horizontal line will be created between the left and right margins.
- or
- Press Enter to create a new paragraph.
- Type ___ (three underscores) and press Enter.
- A heavy single horizontal line will be created between the left and right margins.
Back to top
|
Automatically Closing an E-Mail
Summary: Outlook 2010 keeps the original message open after you have replied or forward it. If you reply to dozens of e-mails every day this can be a pain. Here is how to have Outlook close the original e-mail after you have replied or forwarded it:
- Click on the File tab and select Options.
- In the Outlook Options dialogue box go to the Mail section.
- Go to Replies and Forwards.
- Check the Close original message window when replying or forwarding option.
- Click OK to complete the configuration.
The original message will now close when you send or forward a reply.
|
