answersLogoWhite
Computer Terminology
Microsoft Excel

What is a cell range?


Top Answer
User Avatar
Wiki User
Answered 2012-05-29 16:29:15

A rectangular group of contiguous cells; that is cells that are touching each other in one block.

001
๐Ÿ™
0
๐Ÿคจ
0
๐Ÿ˜ฎ
0
๐Ÿ˜‚
0
User Avatar

Your Answer

Still Have Questions?

Related Questions

Why is the name box important in excel?

It shows the cell you are currently in or the name of the selected range. It can also be used to get to a particular cell or range by typing it into it.It shows the cell you are currently in or the name of the selected range. It can also be used to get to a particular cell or range by typing it into it.It shows the cell you are currently in or the name of the selected range. It can also be used to get to a particular cell or range by typing it into it.It shows the cell you are currently in or the name of the selected range. It can also be used to get to a particular cell or range by typing it into it.It shows the cell you are currently in or the name of the selected range. It can also be used to get to a particular cell or range by typing it into it.It shows the cell you are currently in or the name of the selected range. It can also be used to get to a particular cell or range by typing it into it.It shows the cell you are currently in or the name of the selected range. It can also be used to get to a particular cell or range by typing it into it.It shows the cell you are currently in or the name of the selected range. It can also be used to get to a particular cell or range by typing it into it.It shows the cell you are currently in or the name of the selected range. It can also be used to get to a particular cell or range by typing it into it.It shows the cell you are currently in or the name of the selected range. It can also be used to get to a particular cell or range by typing it into it.It shows the cell you are currently in or the name of the selected range. It can also be used to get to a particular cell or range by typing it into it.


What is the difference between adjacent and non adjacent cell range in Excel?

In Excel, an adjacent cell range is the selection of nearby cell range that is touching another range, but is still a separate range. A non-adjacent cell range is the selection of cell range that is not touching any other cell range. In either case, it can only be when more than one range is selected. After selecting one range, pressing and holding the Ctrl key while selecting a range can select another range.


What is namebox and cell reference?

A cell reference is how an individual cell is identified. It is the column of the cell and the row of the cell. So cell N45 is in column N and row 45. The name box shows what cell or named range is currently selected, making it easier to know where you are on the spreadsheet. It is also used to go to a cell or range by typing the cell reference or the name of the range into it.A cell reference is how an individual cell is identified. It is the column of the cell and the row of the cell. So cell N45 is in column N and row 45. The name box shows what cell or named range is currently selected, making it easier to know where you are on the spreadsheet. It is also used to go to a cell or range by typing the cell reference or the name of the range into it.A cell reference is how an individual cell is identified. It is the column of the cell and the row of the cell. So cell N45 is in column N and row 45. The name box shows what cell or named range is currently selected, making it easier to know where you are on the spreadsheet. It is also used to go to a cell or range by typing the cell reference or the name of the range into it.A cell reference is how an individual cell is identified. It is the column of the cell and the row of the cell. So cell N45 is in column N and row 45. The name box shows what cell or named range is currently selected, making it easier to know where you are on the spreadsheet. It is also used to go to a cell or range by typing the cell reference or the name of the range into it.A cell reference is how an individual cell is identified. It is the column of the cell and the row of the cell. So cell N45 is in column N and row 45. The name box shows what cell or named range is currently selected, making it easier to know where you are on the spreadsheet. It is also used to go to a cell or range by typing the cell reference or the name of the range into it.A cell reference is how an individual cell is identified. It is the column of the cell and the row of the cell. So cell N45 is in column N and row 45. The name box shows what cell or named range is currently selected, making it easier to know where you are on the spreadsheet. It is also used to go to a cell or range by typing the cell reference or the name of the range into it.A cell reference is how an individual cell is identified. It is the column of the cell and the row of the cell. So cell N45 is in column N and row 45. The name box shows what cell or named range is currently selected, making it easier to know where you are on the spreadsheet. It is also used to go to a cell or range by typing the cell reference or the name of the range into it.A cell reference is how an individual cell is identified. It is the column of the cell and the row of the cell. So cell N45 is in column N and row 45. The name box shows what cell or named range is currently selected, making it easier to know where you are on the spreadsheet. It is also used to go to a cell or range by typing the cell reference or the name of the range into it.A cell reference is how an individual cell is identified. It is the column of the cell and the row of the cell. So cell N45 is in column N and row 45. The name box shows what cell or named range is currently selected, making it easier to know where you are on the spreadsheet. It is also used to go to a cell or range by typing the cell reference or the name of the range into it.A cell reference is how an individual cell is identified. It is the column of the cell and the row of the cell. So cell N45 is in column N and row 45. The name box shows what cell or named range is currently selected, making it easier to know where you are on the spreadsheet. It is also used to go to a cell or range by typing the cell reference or the name of the range into it.A cell reference is how an individual cell is identified. It is the column of the cell and the row of the cell. So cell N45 is in column N and row 45. The name box shows what cell or named range is currently selected, making it easier to know where you are on the spreadsheet. It is also used to go to a cell or range by typing the cell reference or the name of the range into it.


What is the function of the Name Box in MS Excel?

It shows the name or cell address of the active cell or cell range. It can be used to go to any cell or range, by either typing a cell reference or range name in it.


What is the difference between single cell referencing and range cell referencing?

The question answers itself. Single cell referencing is when you reference a single cell. Range referencing is when you reference a range of cells.


How do you know a range is active?

The range will be selected and there will be one active cell. Only one cell can be active, not the whole range.


A range of cell is a contagious block of cell?

False. A range is a contiguous block of cells, not contagious.


When pasting a group of copied cells to a target range you only select the cell of the target range?

only select the FIRST cell of the range.


Can fill handles copy a range of cells?

Yes. You can use it to copy one cell, but also to copy a range of cells.Yes. You can use it to copy one cell, but also to copy a range of cells.Yes. You can use it to copy one cell, but also to copy a range of cells.Yes. You can use it to copy one cell, but also to copy a range of cells.Yes. You can use it to copy one cell, but also to copy a range of cells.Yes. You can use it to copy one cell, but also to copy a range of cells.Yes. You can use it to copy one cell, but also to copy a range of cells.Yes. You can use it to copy one cell, but also to copy a range of cells.Yes. You can use it to copy one cell, but also to copy a range of cells.Yes. You can use it to copy one cell, but also to copy a range of cells.Yes. You can use it to copy one cell, but also to copy a range of cells.


What name does the name box display?

It will display either the current cell or a name of a named range if that range is selected. If the range selected is not named, then the name box show the cell reference of the active cell.


What punctuation mark does a range of cells start with?

In most spreadsheet programs a range of cells is represented within a pair of parenthesis - so the first punctuation mark is the opening paragraph mark, i.e. "("In more detail, the syntax is:(column-row:column-row)or descriptively:( column of the first cell in the range rowof first cell in the range : column of the last cell in the range row of the last cell in the range )For example:(A4:D18)Where the address of the first cell in the range is column A, row 4 and the address of the last cell in the range is column D, row 18


When pasting a group of copied cells to a target range you need selected only the what cell of the target range?

Usually you select the top left cell of the range.


What is the difference between cell and cell range?

A cell is a single unit on a worksheet. A cell range is two or more cells. A range is always rectangular and is identified by its top right cell and bottom left cell addresses, separated by a colon like any of these: A3:B15 C1:C10 D4:N1243


How are cell ranges identified?

A cell range is a block of cells. It is identified by the address of the top left cell and bottom right cell separated by a colon. If the range is in a single row or a single column, the address of the first and last cells are used. So any of the following could be a cell range:A3:B16C10:C40D12:K56H13:N13A cell range is a block of cells. It is identified by the address of the top left cell and bottom right cell separated by a colon. If the range is in a single row or a single column, the address of the first and last cells are used. So any of the following could be a cell range:A3:B16C10:C40D12:K56H13:N13A cell range is a block of cells. It is identified by the address of the top left cell and bottom right cell separated by a colon. If the range is in a single row or a single column, the address of the first and last cells are used. So any of the following could be a cell range:A3:B16C10:C40D12:K56H13:N13A cell range is a block of cells. It is identified by the address of the top left cell and bottom right cell separated by a colon. If the range is in a single row or a single column, the address of the first and last cells are used. So any of the following could be a cell range:A3:B16C10:C40D12:K56H13:N13A cell range is a block of cells. It is identified by the address of the top left cell and bottom right cell separated by a colon. If the range is in a single row or a single column, the address of the first and last cells are used. So any of the following could be a cell range:A3:B16C10:C40D12:K56H13:N13A cell range is a block of cells. It is identified by the address of the top left cell and bottom right cell separated by a colon. If the range is in a single row or a single column, the address of the first and last cells are used. So any of the following could be a cell range:A3:B16C10:C40D12:K56H13:N13A cell range is a block of cells. It is identified by the address of the top left cell and bottom right cell separated by a colon. If the range is in a single row or a single column, the address of the first and last cells are used. So any of the following could be a cell range:A3:B16C10:C40D12:K56H13:N13A cell range is a block of cells. It is identified by the address of the top left cell and bottom right cell separated by a colon. If the range is in a single row or a single column, the address of the first and last cells are used. So any of the following could be a cell range:A3:B16C10:C40D12:K56H13:N13A cell range is a block of cells. It is identified by the address of the top left cell and bottom right cell separated by a colon. If the range is in a single row or a single column, the address of the first and last cells are used. So any of the following could be a cell range:A3:B16C10:C40D12:K56H13:N13A cell range is a block of cells. It is identified by the address of the top left cell and bottom right cell separated by a colon. If the range is in a single row or a single column, the address of the first and last cells are used. So any of the following could be a cell range:A3:B16C10:C40D12:K56H13:N13A cell range is a block of cells. It is identified by the address of the top left cell and bottom right cell separated by a colon. If the range is in a single row or a single column, the address of the first and last cells are used. So any of the following could be a cell range:A3:B16C10:C40D12:K56H13:N13


What is the difference between a cell and a range in Microsoft Excel 2007?

A cell is a single location while a range is a collection of related cells.


What formula instructs Excel to adjust the cell reference?

There is no formula that adjusts a cell reference. A cell reference identifies a unique cell. You can use the OFFSET function to a reference a range that is offset a number of rows and columns from another range or cell.


In addition to creating a series of values dragging the fill handle instructs Excel to the formate of a cell to range?

It will copy the format of a cell to a range.


What is d keyboard shortcut for creating a chart from the selected cell range?

F11 is the keyboard shortcut for creating a chart from the selected cell range


What is a Cell Style?

a collection of formatting characteristics you apply to a cell or range margins


Is a cell is not active a name box displays what?

There is always one active cell. Its address will be displayed in the Name box, or the name of a named cell or named range. If a named range is selected, there is still only one active cell, but the name of the range will be shown in preference to the active cell's address.


Is a group of cells called a cell range or range in excel?

It is semantics; take your pick. I would use range.


What is the general range of typical cell size in micrometers?

It all depends on the cell type; Prokaryotic cells range from 1-10 micrometers and eukaryotic cells range from 10 to 100 micrometers


Does Excel's name box identify the worksheets in a workbook?

No it does not. It identifies cell address. It identifies range names. You can also use it to type in an address or range name in order to go to the cell or range.


How the address of range shows in Microsoft Excel?

A range is always indicated by two cell references separated by a colon. If the range is on a single row it is the first and last cell of the range: C4:K4 If the range is on a single column it is the first and last cell of the range: A5:A13 If the range spreads over more than one row or more than one column, then the range is specified by the top left and bottom right cells: D5:J20


What sign is used to specify a cell range?

/


Still have questions?