Question

how will you separate a range and non adjacent cells in a worksheet​

Answer 1

Answer:

Just press and hold down the Ctrl key, and you can select multiple non-adjacent cells or ranges with mouse clicking or dragging in active worksheet.

Explanation:

This is the correct answer

Answer 2

Answer:

Just press and hold down the Ctrl key, and you can select multiple non-adjacent cells or ranges with mouse clicking or dragging in active worksheet.