How to convert excel to range

How to convert excel to area?

After converting tables into areas in Excel, these tables are no longer treated as inserted tables, but become ordinary areas like other cells.

Method to convert table to area:

1. Open the Excel document on the computer.

#2. After opening the Excel document, select the data and then insert it into the page, select Insert table.

#3. The Create Table window pops up, click OK.

#4. After inserting the table, click Convert to Area on the insert page again.

#5. After converting the table into a range, it will be no different from the original document, and it will return to the original ordinary cells.

The above is the detailed content of How to convert excel to range. For more information, please follow other related articles on the PHP Chinese website!