answersLogoWhite

0


Best Answer

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.

User Avatar

Wiki User

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

Wiki User

12y ago

Use a comma. [=SUM(A1:A23,B6:B12,C2:C21)]

This answer is:
User Avatar

User Avatar

Wiki User

8y ago

A nonadjacent range in Excel is a block or group of cells that cannot be adjacent. This range is the section that has been selected or highlighted by the user.

This answer is:
User Avatar

User Avatar

Wiki User

10y ago

When you have multiple ranges selected, a non-adjacent range is a range that does not touch any other ranges. So, for example, range A3:B20 and range D19:K40 are non-adjacent ranges.

This answer is:
User Avatar

User Avatar

Wiki User

8y ago

As an example, . A6:A9; C6: C9 would be non-adjacent columns/cells in Excel.

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What could be a nonadjacent range in Excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

Describe the two types of cell ranges in Excel 2007?

Adjacent and nonadjacent


What is a group of cells that can be adjacent or nonadjacent called?

A range.


In excel which would you perform to group ajacent worksheets?

In order to group nonadjacent worksheets, you click first tab, then hold Ctrl and click last tab. Excel was developed by Microsoft.


How do you select nonadjacent columns or rows in excel?

After selecting the first row or column, press and hold the ctrl key and click on the header of the next row or column you want to select.


What is a range of cells containing values for variables used in formulas in Excel?

It can simply be a range. It could also be an array. It will depend on the formula itself.


What are some sentences using the word nonadjacent?

I'm not very interested in nonadjacent properties.


What are two or more selected cells that Excel also treats as a single cell?

Depending on what you mean, it could be a range, which is a group of cells in Excel, that can be referenced in a formula as a block, but they are not a single cell then. You could be referring to cells that have been merged, in which case Excel treats them as a single cell.


What is a group of cells in excel?

range


Can you select nonadjacent ranges using the shift key in excel?

No. You need to use the Ctrl key to select non adjacent ranges.


What action is used when Excel suggests the wrong range after clicking the SUM button?

Correct the range by dragging the appropriate cells in the worksheet. You could also type in the correct range.


Do hotels use Excel?

Any business can use Excel for a whole range of things.


Where can you get multiple range test in excel?

50,70,80,50,60,44,70,50,70,60,50,50