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

  




 

 

Selecting Cells

You can select a single cell or a rectangular area of cells in the spreadsheet. The selected cell(s) are displayed with a thick black border.

You can select a single cell in one of the following ways

  • left click on it

  • enter the cell reference (for example B5 ) into the cell reference box at the left end of the Formula toolbar and press Enter

  • use the View -> Goto Cell... menu option

You can also steer your way around with the arrow keys. Pressing the Enter key will move the current selection one position up, down, left or right depending on the setting in the Misc page of KSpread's configuration dialog box.

If you hold the Shift key down while using the arrow keys the selection will move to the start or end of the block of occupied cells.

To select an area of contiguous cells drag the mouse cursor across the desired area with the left button held down, or enter the references of the top left and bottom right cells separated by a colon into the Formula toolbar cell reference box (for example B7:C14 ) and press Enter , or enter these cell references in a similar format into the dialog box brought up by View -> Goto Cell... .

You can also select an area of cells by selecting the cell in one corner of the wanted area then holding the Shift key down while using the left mouse button to select the cell in the opposite corner.

To select a complete row or column of cells left click on the row number at the left of the worksheet or on the column letters at the top. To select adjacent rows or columns drag the mouse pointer over the appropriate row numbers or column letters with the left button held down.

To select non-contiguous cells, click on the first cell you want to select then hold the Ctrl key and select the other cells.




 
 
  Published under the terms of the GNU General Public License Design by Interspire