Question

How can you convert a table to a range in excel?​

Answer 1

Hold the shift key while u select other cells

Answer 2

we can convert the table to a regular range of data on the worksheet .To do, follow these steps-

1. Right click anywhere in the table.

2. Point to table and then click convert to range.

3. A message box appears.

4. click Yes.

hope it will help you.....