| PreviousCells | Spreadsheets - Cell Selection | NextData Entry |
Spreadsheets are powerful tools for working with data. However, to work with data, it is necessary to have tools to rapidly choose the required cells.
An entire line can be chosen by clicking directly on the line header:
It is also possible to choose a line using the keyboard by moving to a cell on the line and then pushing <Caps lock>+<Spacebar> simultaneously.
When referring to a line in a formula, simply use the name of the line.
Using a method similar to that used to choose entire lines, an entire column can be chosen by clicking directly on the column header:
It is also possible to choose a column using the keyboard by moving to a cell in the column and then pushing <CTRL>+<Spacebar> simultaneously.
When referring to a column in a formula, simply use the name of the column.
To select a range of cells (also called a block of cells), simply click on a cell (the starting cell) and move the mouse with the left button held down in order to highlight the required cells all the way to the ending cell :
Note that the name zone (on the upper left) shows the number of lines and colomns present in the selection.
 |
The starting cell has a different colour (white). It is, however, part of the selection just like the other highlighted cells! |
It is also possible to choose a range of cells by clicking on the starting cell and then clicking on the ending cell while holding the <SHIFT> key down.
In formulas, a range of cells is written by showing the coordiantes of the starting cell and the ending cell seperated by a ":" :
Reference_Cell_Start:Reference_Cell_EndFor instance, in the example above, the cell range would be written as follows:
D16:F21
It is possible to choose disjointed (non-contiguous) cells within a range, meaning cells that are not beside each other. To do this, choose cells or ranges of cells while holding the Control (<CTRL>) button down.
In formulas, a selection of cells or a range of disjointed cells is written by showing the coordinates of the cells or of the ranges of cells and seperating them with semicolons:
Ref_Cell1;Ref_Cell2;Ref_Cell_Start_Range1:Ref_Cell_End_Range1For instance, in the example above, the cell selection would be written as follows:
D6;D8;D9
Just as it is possible to select numerous colocated cells, it is also possible to select numerous contiguous lines. To do this, simply choose the starting line and then click on the ending line while holding the <SHIFT> button down:
To write this in a formula, the starting line is seperated from the ending line by a : :
Starting_Line;Ending_Line
In L1C1 notation, it would be written as:
LStartingNumber:LEndingNumber
In A1 notation, it would be written as:
StartingNumber:EndingNumberFor instance, in the example above, the line selection would be written as follows:
6:9
To select non-contiguous lines, click successively on the line headers of the desired lines while holding the Control (<CTRL>) button down:
In formulas, a selection of disjointed lines is written by showing the coordiantes of the lines separated with semicolons:
Ref_Line1;Ref_Line2;...For instance, in the example above, the line selection would be written as follows:
6;8;9
It is possible to select all the cells on a worksheet by clicking on the empty box on the upper left of the worksheet:
Can you select a range of cells based on a cell valule excel Excel formula copy entire rows to another spreadsheet based on cell criteria Excel formula select cell from a seperate file Excel macro on cell select Excel macro select first characters of cell Excel select all worksheets based on cell value Excel select column first empty cell Excel spreadsheet add a referenced cell Fill color selected text in in excel cell in interop Get value of last selected cell in sheet How do i get an excel spreadsheet to select a row info from another sheet depending on date How to insert a data table into excel spreadsheet cell How to insert today's date in a spreadsheet cell If cell = 1 select if = 2 stop If cell a is populated copy entire row to another spreadsheet Show message on cell selection Show msg on cell select Spreadsheet formulas