How do you change a table to a range?
To convert the data range to a table, please do as follows: 1. Select the data range that you want to convert. 2. Click Insert > Table, in the Create Table dialog box, check My table has headers if your data has headers, see screenshots: 3. Then click OK, and your data range has been converted to the table format.
How do you change a table to a range in excel?
To do so, simply select the data range and do the following: Click the Insert tab. In the Tables group, click Table. Excel will display the selected range, which you can change. Click OK and Excel will format the data range as a table.
How do you convert a table to a range?
Click anywhere in the table then go to Table Tools > Design on the Ribbon. On a Mac go to the Table tab. In the Tools group, click Convert to Range. Right-click the table, then in the shortcut menu, click Table > Convert to Range. Note: Table features are no longer available after you convert the table back to a range.
How do you convert excel to normal range?
1. Select your table range, right click and select Table > Convert to Range from the context menu. See screenshot: Tip: You can also select the table range, and then click Design > Convert to Range. 2. Then a prompt box will pop out, please click Yes button, and the selected table will be converted to the normal range.