 |
|
|
|
|
||||||||||||||||||||||||||||||
| |||||||||||||||||||||||||||||||||||
Toward a Better Computing Experience |
|
If you are editing a long document and you need to temporarily refer to another place in the document, you can use this tip to make yourself more productive. There are two ways you can jump back and forth in your document.
METHOD 1
First, you can use the scroll bars to view the other parts of the document. The insertion point (the blinking bar that indicates where your typing will appear) is still at your old editing position, even though it is off-screen. When you are through viewing the part of the document you needed to refer to, press one of the arrow keys or any printable character (including the SPACE BAR). You will be taken back to the exact place you were editing. Of course, if you pressed a printable character you will need to delete it.
METHOD 2
The other method is to use SHIFT+F5. This key combination is used to jump to the last three places in the document where you made edits. (Actually, it is four locations if you count the one where you first pressed SHIFT+F5.) You can press it once and you will return to where you were most recently editing.
Copyright © 2009 by Sharon Parq Associates, Inc. Reprinted by permission. Thousands of free Microsoft Word tips can be found online at http://word.tips.net.
Excel includes two functions that allow you to quickly round a number up to the next highest even or odd integer values.
EVEN
For instance, suppose you have the value 26.3 in cell A7, and the following in cell A9: =EVEN(A7). The value returned by this function is 28, which is the next highest even integer value.
ODD
The following function will return a value of 27, which is the next highest odd value: =ODD(A7). If the value in A7 were negative, then both the ODD and EVEN functions will return values that are further away from zero than the value used as an argument (but they are still odd and even).
Copyright © 2009 by Sharon Parq Associates, Inc. Reprinted by permission. Thousands of free Microsoft Word tips can be found online at http://word.tips.net
This article has been obtained from APCUG with the author’s permission for publication by APCUG member groups; all other uses require the permission of the author (see e-mail address above).