What are some shortcuts for entering formulas?
When entering cell references in a formula, press the function key {F4} to cycle through the four combinations of absolute and relative references. An example will show this is a simple and useful tool. SuPose you are entering the following formula in cell $E$5: = E$1 * ($B$5+$D5) / C5 If you start typing the equals sign and then use the mouse or keyboard to point to a cell, Excel inserts a relative reference. For instance, the first reference will be inserted as E1. If you press {F4} repeatedly, Excel will change the reference to $E$4, E$4, $E$4 and back to E4. You can highlight any part of an existing formula and use this shortcu to adjust references.
When entering cell references in a formula, press the function key {F4} to cycle through the four combinations of absolute and relative references. An example will show this is a simple and useful tool. Suppose you are entering the following formula in cell $E$5: = E$1 * ($B$5+$D5) / C5 If you start typing the equals sign and then use the mouse or keyboard to point to a cell, Excel inserts a relative reference. For instance, the first reference will be inserted as E1. If you press {F4} repeatedly, Excel will change the reference to $E$4, E$4, $E$4 and back to E4. You can highlight any part of an existing formula and use this shortcu to adjust references. What are some common keyboard shortcuts? Keywords: Common Keyboard Shortcut Posted February 8, 1996 Some of the most useful keyboard shortcuts used are the select, cut, copy and paste functions. In addition to the Edit menu and the Right mouse click, these keyboard short cuts can often make your work much easier. Start by selecting an
