How-To: Select and add cells to a range using the keyboard - OpenOffice.org Calc
- It is possible to select and add cells from multiple locations using the keyboard.
- To do this, first click on the first cell that you need selected and then press the Control (Ctrl) key on the keyboard.
- Then, while holding the control key move your mouse to the next cell you need selected, even though it is not connected with the original one. Just click on it once.
- Great! We have added a separate cell to the selection. You can do this to the rest of the cells you need selected. You can also drag select cells if you want, as long as you are holding the control key.
- Once finished, just release the control key.
- Now, the cells are ready to be formatted. We are just going to add a fill color to them by clicking on this button....
- ...and then clicking on the color we want in the window that opens.
- Great! The cells have been formatted. You have learned how to add cells to selections using the keyboard.
powered by Plan-B screencast technology
Select and add cells to a range using the keyboard
This screencast demonstrates how to select and add cells to a range using the keyboard. You learn:
- How to select and add cells to a range using the Control (Ctrl) key on the keyboard.
- How to format the selected cell range
Advanced topics
For advanced functionality with similar results see:
- Select all the cells in a sheet
- Subtract cells in a selected range
- Select a range of cells by dragging the mouse
- Select a range of cells using the keyboard
OpenOffice.org™ is a trademark of OpenOffice.org.
