How do I make a table in Excel without a table?

To remove a table:

  1. Select any cell in your table. The Design tab will appear.
  2. Click the Convert to Range command in the Tools group. Clicking Convert to Range.
  3. A dialog box will appear. Click Yes.
  4. The range will no longer be a table, but the cells will retain their data and formatting.

How do I format a cell in Excel as a table?

Try it!

  1. Select a cell within your data.
  2. Select Home > Format as Table.
  3. Choose a style for your table.
  4. In the Format as Table dialog box, set your cell range.
  5. Mark if your table has headers.
  6. Select OK.

How do I remove a table but keep formatting?

To remove a table but keep data and formatting, go to the Design tab Tools group, and click Convert to Range. Or, right-click anywhere within the table, and select Table > Convert to Range.

How do I remove format as table Style in Excel?

Remove a table style

  1. Select any cell in the table from which you want to remove the current table style.
  2. On the Home tab, click Format as Table, or expand the Table Styles gallery from the Table Tools > Design tab (the Table tab on a Mac).
  3. Click Clear. The table will be displayed in the default table format.

How do you convert a cell range to a table using a table style?

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 use range in Excel?

Calculating Range in One Step Imagine you have data running from cell A2 to cell A20. Type “=MAX(A2:A20)-MIN(A2:A20)” to find the range in a single step. This tells Excel to find the maximum of the data and then subtract the minimum of the data from it.

How do you make a table in Excel without headers?

Go to Table Tools > Design on the Ribbon. In the Table Style Options group, select the Header Row check box to hide or display the table headers.

How do I remove a table from an Excel spreadsheet?

If your Excel worksheet has data in a table format and you no longer want the data and its formatting, here’s how you can remove the entire table. Select all the cells in the table, click Clear and pick Clear All. Tip: You can also select the table and press Delete.

How do you convert a table to a normal range in Excel?

How to convert a table to a range in Excel

  1. Select any cell in the table to activate the Table Design tab.
  2. On the Table Design tab, in the Tools group, click Convert to Range.

How do I Untable data in Excel?