answersLogoWhite

0


Best Answer

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.

User Avatar

Wiki User

11y ago
This answer is:
User Avatar
More answers
User Avatar

Wiki User

12y ago

No. A range is a rectangular single group of cells. If cells are non-adjacent, they cannot be a single range. You can have several different ranges that are non-adjacent, but each will consist of a set of adjacent cells.

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What is the difference between adjacent and non adjacent cell range in Excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

What is range in a Excel document?

collection of adjacent cells, rows, or columns


What is a group of adjacent and non-adjacent cells in Excel called?

An adjacent group of cells are known as a range or a block. There is no particular name for a group of non-adjacent cells.


What could be a nonadjacent range in Excel?

A range can only be cells that are adjacent and in a rectangular shape. It is possible to select non-adjacent cells but this would not be regarded as a range. Each would be a separate range. So usually non-adjacent ranges will have gaps between them, although it is possible to have cells from to separate ranges right beside each other. You will know them by their boundaries around them.


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 is a non adjacent range?

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


What is non adjacent range?

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


What is a series of two or more adjacent cells in a column or row or a rectangular group of cells in Excel?

A Range


What is a group of adjacent cells called in Excel?

They are called a range or sometimes a block.


What is the difference between an excel table and a range?

A table is an organized group of cells for a specifc purpose. A range is a group of cells, but may or may not be organized. A table always has a range, but a range might not contain cells from a table.


In excel is a series of two or more adjacent cells in a column or row or a rectangular group of cells?

A group of cells is called a range.


What is the defition of adjacent range?

the word adjacent means next to. that means that an adjacent park would be one next to you. an adjacent range could be a firing range near you.


What time difference generally exists between two adjacent time zones?

A time zone is a range of 24 longitudes where a common standard time is used. The time difference between two adjacent time zones is one hour.The average difference between two adjacent time zones, counting each zone with a different name as a different zone, is 0.86 hour. If you remove cases in which two adjacent zones have different names but no time difference, the average difference is 1.18 hours. The mode (the most common difference) is 1 hour. The least difference between adjacent time zones (besides 0) is 15 minutes, between India Time and Nepal Time. The greatest difference is 3.5 hours, between Afghanistan Time and China Time.