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. br br These are the steps outlined in the video. br br 1) Ctrl + A br 2) Ctrl + T br 3) Check "My table has header". br 4) OK br 5) Table Design br 6) Table Styles ~ Quick Styles ~ Clear br 7) Ctrl + Shift + L br br br Increase table size br 1) Scroll down br 2) Table resizer handle, click and drag.