K2E Canada Office Tips November 2019
Summary: Excel allows you to easily adjust how you want to display information in a cell. 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.
In the Type Box enter the following:
_(* 0.00%_);[RED]_(* (0.00%);_(* 0.00%_)
5. 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.
Adding a Break in Your Document
Summary: Word automatically adds page breaks. There may be times when you want to control a page break. Here is how to do one manually:
Word supports the following types of breaks:
To insert a break in your document, follow these steps:
We hope that you are enjoying our monthly newsletter featuring tips that will help you to be more effective using Microsoft Office products.
Relative vs Absolute Macros
Summary: Understanding the difference between a relative and an absolute macro when you are doing a recorded macro.
When you record a macro in Excel, it includes Absolute references to the cells by default. This means that it records the specific cell addresses of the cells you are using as you record. For example, if your macro begins and you are on cell A1, then you record clicking on cell A10, when you reply the macro it will select cell A10. The macro will go to cell A10 even if you start on cell C10. An Absolute macro is useful when you will be replaying the macro on different worksheets all with the same layout and format.
If you want your cell selections to be recorded relative to the cell you begin with, click the Use Relative References button before you start recording. If you record the same macros as described above with Use Relative References applied, if when your macro begins you are on cell C1, then it will select cell C10. A Relative macro is useful when you want to be able to apply it to varying groups of cells.
The video tip is from the webinar K2's Road to Excellence - Part 6 Excel Macros and Adagio
Click above to view the video tip