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. <br /><br /><br />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?, <br />
