answersLogoWhite

0

There is no such thing as a non-contiguous range. A range is a group of cells that are together in a rectangular block. Non-contiguous refers to cells that are not touching. So you can have more than one range which do not touch, so what you have are non-contiguous ranges. It is possible to select non-contiguous ranges by first selecting one range and then while holding the Ctrl key, select other ranges.

User Avatar

Wiki User

13y ago

What else can I help you with?

Related Questions

What are the two ranges of Excel?

You may be referring to a contiguous range and a non-contiguous range.


What is a non adjacent range?

a collection of multiple ranges that are not positioned in a contiguous cluster in an Excel worksheet


Which key do you hold if you want to select a large range of contiguous cells in excel?

shift key


What is non adjacent range?

a collection of multiple ranges that are not positioned in a contiguous cluster in an Excel worksheet


Describe the two types of cell ranges in Excel 2007?

In Excel 2007, a cell range can be contiguous, meaning it consists of adjacent or neighboring cells (e.g., A1:B5). A cell range can also be non-contiguous, where it consists of multiple disjoint cell areas separated by commas (e.g., A1:A5, C1:C5).


A range of cells is a contiguous block of cells?

Yes, a range is a contiguous block of cells.


In exel what is A selection of multiple cells called?

They can be called a Range or a Block. This is only if it is a single selection of a rectangular block of cells. It is possible to select cells that are not together, known as being non-contiguous, but this is not a range or block.


What is an example of a disjointed range designation in Excel?

A disjointed range in Excel consists of two or more separate ranges that are not contiguous. For example, if you want to select cells A1 to A5 and C1 to C5, you can specify this disjointed range as A1:A5, C1:C5 in a formula or function. This allows you to perform operations on non-adjacent cells simultaneously.


What is a nearby cell in Excel?

A cell that touches another cell is a contiguous cell. A nearby cell that does not touch the cell in question, is a non-contiguous cell.


A range of cell is a contagious block of cell?

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


What is a ranch in Excel terms?

I think you probably mean "range" instead of "ranch". In Excel, a range is a group of cells. A range can be as small as a single cell (for example, cell A1), block of cells (example, A1:B2), or even non-contiguous cell (example: A1,B2,C3). It could also be an entire column (A:A) or row (1:1). In the A1:B2 example above, this range would include four cells A1, A2, B1, and B2


What is the longitude range for the contiguous part of the US?

Every longitude in the range of 66.95° west to 124.74° west crosses the "lower 48".