Forum Discussion
table format
I have a spreadsheet that I formatted as a table. It is not working as table. It does not enter formulas down into new row. How do I clear table formatting so I can reformat as table?
1 Reply
Hi Patric,
To fill formulas automatically please check in File->Options that setting
To convert the range into the table stay on the cell within your range and press Ctrl+T.
To convert the table back to the range stay on the cell within the table and click in ribbon on Convert to range button; or do that from right click menu Table->Convert to range
