|Want to Automatically Sum a Column or a Row From the Keyboard?
Summary: There are many different ways to sum a column or a row. Here's how to quickly do it from the keyboard.
- Select the first empty cell at the bottom or to the right of the numbers you want to add.
- Select ALT + "=".
- Press the Enter key.
The numbers will be summed.
Want to Display all the Formulas in a Worksheet?
Back to top
Summary: There are times when you are auditing a workbook when it is useful to display the formulas in a cell, rather than the results. Here is how to do this:
To display the formulas hold down the CTRL key and the "Tilde" key. This is the key furthest to the left on the row with the number keys. It looks like an "s" on it's side.
This will display all the formulas in the worksheet. Hit CTRL + "Tilde" again and your numbers will reappear..
Quickly Adding or Deleting a Column
Summary: Managing columns and rows in a worksheet is an all day task. Here is how to use keyboard shortcuts to save time when you are doing this task:
To add a column select a cell in the column to the left of where you want the new column.
- CTRL + "=" will add the column.
- CTRL + "-" will delete the column.
Quickly Creating Numbered or Bulleted Lists
Summary: We often use numbered and/or bulleted lists in a Word document. You can add them from the ribbon, but here's a neat shortcut to add them from the keyboard.
To create a numbered list type a number with a period and then a space at the beginning of the sentence. After you enter your text for the first number press Enter and Word will move down a row and enter the next number.
To create a bulleted list type "*" and then a space at the beginning of the sentence. After you enter your text for the first bullet press Enter and Word will move down a row and enter the next number.