> For the complete documentation index, see [llms.txt](https://books-gyansetu.gitbook.io/advanced-excel/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://books-gyansetu.gitbook.io/advanced-excel/format-as-table.md).

# Format as Table

**Format as Table**\
\
You can quickly format your worksheet data by applying a predefined table style. However, when you apply a predefined table style, an Excel table is automatically created for the selected data. If you don't want to work with your data in a table, but keep the table style formatting, you can convert the table back to a regular range.<br>

**Short Key --> Alt + H + T (Using Alt Key Concept explained in Short Keys Section)**

![](https://2721809844-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LR_tHSREe3Wm40fY9NG%2F-LRauBpQuxSOqfhNmdJH%2F-LRauNUIMFIIKJdw3Wp1%2Fimage.png?alt=media\&token=74e650d9-0b73-4a56-a6ac-41918c995991)

{% file src="/files/-LRauTdgEQo4DRAACNzW" %}
Example for Format as Table
{% endfile %}