How do you convert to a table without changing formatting in Excel? - Excel Tips and Tricks

Learn how to convert to a table without changing formatting in Excel. We will cover on how do I remove table formatting in Excel but keep data, or sometime asked as how do I remove table formatting from keep data.

These are the steps outlined in the video.

1) Ctrl + A
2) Ctrl + T
3) Check "My table has header".
4) OK
5) Table Design
6) Table Styles ~ Quick Styles ~ Clear
7) Ctrl + Shift + L


Increase table size
1) Scroll down
2) Table resizer handle, click and drag.


How do you convert to a table without changing formatting in Excel?,How do I turn off table style in Excel?,How do I remove table formatting in Excel but keep data?,How do I remove table formatting from keep data?,