shortcut key

One of the fastest ways to run a macro is to create a shortcut key for it. You don't need to put a button on your toolbar or even click anywhere. As a matter of fact, your hands don't even have to leave your keyboard! You can create a shortcut key ... to run a macro before you even record it. Follow the steps below to learn how. Choose Tools | Macro | Record New Macro or double-click REC on the Status bar. Enter the name for the macro. Click Keyboard to see the Customize Keyboard dialog box. Choose the macro name. Click the Press New Shortcut Key box. Press the key combination you want to use. If ... (view more)

When entering numbers in Excel you can type the numbers into a cell by using the keys on the top row of the keyboard or, if Num Lock is turned on, by using the keypad on the right side of the keyboard. To do so, follow the steps below: Type the ... numbers in the cell and press Enter. If you type decimals, such as 1.5000, Excel often eliminates the trailing zeros and displays 1.5. Note that another future article will tell you how to control this. You can also type dollar signs, commas, or percent signs, and Excel displays them with the numbers. Even when you type these symbols, Excel interprets ... (view more)