How-To: Select a range of cells using the keyboard - OpenOffice.org Calc
- The keyboard can be used to select cell ranges. To do this first click on the first cell you need selected.
- Next, hold down the "Shift" key and then click on the last cell that needs to be selected.
- Great! Notice that the cells between the first and last cells have been selected as well. Once you're done, just release the shift key.
- Now, we are ready to format the selected range. For this example we are clicking here on the add fill color button.
- Once the window opens, just click on the fill color you want for the cells.
- Great! As you can see the selected cells have been formatted. Congratulations! You have learned how to use the keyboard to select cell ranges.
powered by Plan-B screencast technology
Select a range of cells using the keyboard
This screencast demonstrates how to select a range of cells using the keyboard. You learn:
- How to select a range of cells using the shift key in 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 and add cells to a range using the keyboard
OpenOffice.org™ is a trademark of OpenOffice.org.
