Cell and cells range

What is cell?

In any spreadsheet program such as Excel, each rectangular box in a worksheet is referred to as a cell. A cell is the intersection point of a vertical column and a horizontal row. Data entered into Excel is always stored in a cell. Each cell can hold only one piece of data at a time. In the newest versions of Excel there are over 17 billion cells in each worksheet. To keep track of where data is stored, each cell has a cell reference consisting of the column letter and row number of where the cell is located.

 

What is cells range?

A group of cells is called a cells range or range. An adjacent range is a single rectangular block of cells
A nonadjacent range consists of two or more distinct adjacent ranges. A range reference indicates the location and size of a cell range.

 

Selecting Cell Ranges

To select an adjacent range:

Click the cell in the upper-left corner of the adjacent range, drag the pointer to the cell in the lower-right corner of the adjacent range, and then release the mouse button Or click the cell in the upper-left corner of the adjacent range, press the Shift key as you click the cell in the lower-right corner of the adjacent range, and then release the Shift key

 

To select a nonadjacent range of cells:

Select a cell or an adjacent range, press the Ctrl key as you select each additional cell or adjacent range, and then release the Ctrl key

 

To select all the cells in a worksheet:

Click the Select All button located at the intersection of the row and column headings (or press the Ctrl+A keys)

 

Moving or Coping Cell Ranges

Select the cell or range you want to move or copy. Move the mouse pointer over the border of the selection until the pointer changes shape. To move the range, click the border and drag the selection to a new location (or, to copy the range, hold down the Ctrl key and drag the selection to a new location) Or Select the cell or range you want to move or copy. In the Clipboard group on the Home tab, click the Cut button or the Copy button (or right-click the selection, and then click Cut or Copy on the shortcut menu). Select the cell or upper-left cell of the range where you want to move or copy the content. In the Clipboard group, click the Paste button (or right-click the selection, and then click Paste on the shortcut menu)

 

Inserting and Deleting a Cell Range

Select a range that matches the range you want to insert or delete. In the Cells group on the Home tab, click the Insert button or the Delete button Or select the range that matches the range you want to insert or delete
In the Cells group, click the Insert button arrow and then click the Insert Cells button or click the Delete button arrow and then click the Delete Cells command (or right-click the selected range, and then click Insert or Delete on the shortcut menu) Or click the option button for the direction in which you want to shift the cells, columns, or rows
Click the OK button

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

*

code

clearPost Comment