How-To: Enter the sum function in cells using the keyboard - OpenOffice.org Calc
- To enter the sum function using the keyboard, first move the cell selection box on the cell where you want the formula to be placed.
- Do this by either double clicking on the cell with the mouse, or using arrow keys to move the selection box to it and then pressing F2.
- Now, to enter the sum function, type in =sum into the cell. A tooltip should appear to guide you.
- After the word "sum" type in an open parenthesis character. Now we are ready to select the cells we want to add.
- To select the cells to the left of our formula, press the "left arrow" key. Once the first cell is selected, hold down the "shift" key.
- Now whilst holding the shift key use the arrow keys to select the other cells you want for the sum function. A red outline should guide you on the cells that are being selected.
- Once you have selected all the cells you want, release the shift key. Then, type in a close parenthesis character at the end to finish writing the formula.
- Great! Now, to perform the sum function, just press enter.
- Great! The solution should appear where the formula was. You still can check if the formula is right by clicking once on the cell again.
- Once selected, you should see the formula here at the formula bar.
- Congratulations! You have learned how to enter a sum function using the keyboard.
powered by Plan-B screencast technology
Enter the sum function in cells using the keyboard
This screencast demonstrates how to enter the sum function
in cells using the keyboard.
You learn:
- How to start a formula within a cell.
- How to enter cell references using the keyboard.
- How to enter the sum function using the keyboard.
Advanced topics
For advanced functionality with similar results see:
- Enter an arithmetic formula
- Reference a different cell.
- Enter the sum of a range of cells.
- Enter the sum function using the function wizard.
OpenOffice.org™ is a trademark of OpenOffice.org.
