 How to Display a Negative Percentage in Red
|
Summary: It is not obvious how to display a negative percentage in red. Here is how to do this:
- Select the cell or cells that may contain negative percentages.
- Click on the Home tab.
- Click on the Number Group.
- Click on the small icon in the lower left hand corner of the Number Group.
- Select Custom.
- In the Type Box enter the following:
_(* 0.00%_);[RED]_(* (0.00%);_(* 0.00%_)
- Click OK.
The format you specified above will display positive percentages with two decimal places and will display negative percentages in red with brackets and two decimal places. Note that this uses the accounting format.
|
Counting the Number of Blank Cells
|
Summary: There are times when you want to count the number of blank cells in a range. Here is how to do this:
- Select the range of cells where you want to count the blank cells.
- Enter the following formula:
=COUNTBLANK(Range)
This function returns an integer value showing the number of blank cells in the range. Note that if you have display of zero values turned off for the workbook a cell can appear blank, when it is really not blank and it will not be included in the count of blank cells.
|
Back to top
Doing a Case Sensitive Sort
Summary: Normally Excel doesn't pay attention to case when you are sorting text. If case is important you need to change a setting in the sort window. Here is how to do this.
- Click inside the data set that you want to sort.
- Define your sort levels.
- Click on the Options Tab in the top right hand corner of the sort window.
- Click on the Case Sensitive check box.
- Click on OK.
- Click on OK.
Back to top |
|
Typing Over Text
Summary: Normally when you press a letter or a number key with Word in its default mode, the insertion point and any text to the right of it is pushed to the right. If you want Word to replace the text you need to change a setting. Here is how to do this:
- Click on File.
- Click on Options.
- Click on Advanced.
- Click on Using the Insert Key to Control Overtype Mode.
- Click on Use Overtype mode.
- Click on OK.
|
|
Summary: You can create a rule to control when messages leave your system after you click send. Here is how to do this::
- Open Outlook.
- Click on the File Tab.
- Click on Rules and Alerts.
- Click New Rule.
- In the Rules Wizard, under Start From A Blank Rule, click Check Messages After Sending.
- Click Next.
- Click to select any desired conditions that limit which messages the rule applies to, and then click the link in the description panel, which may display a dialogue box to specify the exact criteria.
- Click OK.
- Click Next.
- Click on any exceptions, specify them in the description panel to specify the exact criteria.
- Click OK.
- Click Next.
- Under Select Actions, click Defer Delivery for a Number of Minutes.
- Type the total minutes up to 120 that you want messages delayed.
- Click OK.
- Click Next.
- Type a name for the rule.
- Click Finish.
You will now be returned to the Rules and Alerts dialogue box, which will now show your next rule.
|
Finding and Replacing Text in a PowerPoint Presentation
Summary: There are times when you may need to replace text in a PowerPoint presentation. Here is how to do this without editing each individual slide:
- On the Home Tab of the Ribbon click Find from the Editing Group.
- Enter the text in the Find box that you want PowerPoint to find.
- Click on the Find Next to find the first matching entry.
- If you want to also replace the entry click Replace.
- Enter the text in the Replace with Box and click Replace.
- Click on Next to move through all of the instances of the text you are looking for in the presentation.
Be careful if you use the Replace All button that you are certain that only the text you have selected will change. You do not want to change part of a word because it closely matches your criteria.
|
