How to Covert Table to Range in Excel | Undo Table Formatting in Excel

Lets know how to convert Excel Table to Range in Excel:
Recently I confronted an issue where I had to format my Range in Excel as Table for easy data entry. But when I was done with the data entry, I no more needed my data formatted as Table.
I simply wanted to undo table formatting and convert my data to Range. It turned out to be quite a task undoing table formatting.
I tried myself but to no avail, then I started searching online for the solution. Tried different search terms i.e.
How to undo format as table,
format as table undoing,
I formatted my data in excel as table, now I want to undo formatting as table. How do I do that?
In short I tried whatever I could but it turned out that the mentioned search terms returned very few results that actually addressed mu issue.
Ultimately, I found an easy and simple way to resolve my issue. And I decided to share it with you too;
So here are the steps:
1) Select the table;
2) Go to Design Menu;
3) Click Format as Range
This will convert your table to Range:
If you want to undo the Table-Like formatting too;
1) Select the Range;
2) Go to Home Menu
3) Click on Fill Option
4) Select White or No Color
and you are good to go.
The suggested search term that I ultimately came about is;
Convert Table to Range in Excel
Jan Composing Centre Tangi (JCC)

Видео How to Covert Table to Range in Excel | Undo Table Formatting in Excel канала Jan Composing Centre