Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Programming
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Databases
Mail Systems
openSolaris
Eclipse Documentation
Techotopia.com
Virtuatopia.com
Answertopia.com

How To Guides
Virtualization
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Windows
Problem Solutions
Privacy Policy

  




 

 

OpenOffice Calc User Guide
Previous Page Home Next Page

Range of contiguous cells

A range of cells can be selected using the keyboard or the mouse.

To select a range of cells by dragging the mouse:

  1. Click in a cell.

  2. Press and hold down the left mouse button.

  3. Move the mouse around the screen.

  4. Once the desired block of cells is highlighted, release the left mouse button.

To select a range of cells without dragging the mouse:

  1. Click in the cell which is to be one corner of the range of cells.

  2. Move the mouse to the opposite corner of the range of cells.

  3. Hold down the Shift key and click.

To select a range of cells without using the mouse:

  1. Select the cell that will be one of the corners in the range of cells.

  2. While holding down the Shift key, use the cursor arrows to select the rest of the range.

The result of any of these methods will look like the right side of Figure 4.

TIP

You can also directly select a range of cells using the Name box. Click into the Name box as described in “Using a cell reference†on page 10. To select a range of cells, enter the cell reference for the upper left hand cell, followed by a colon (:), and then the lower right hand cell reference. For example, to select the range that would go from A3 to C6, you would enter A3:C6.

OpenOffice Calc User Guide
Previous Page Home Next Page

 
 
  Published under the terms of the Open Publication License Design by Interspire