How to remove table formatting
Solved
etiennette57
Posted messages
471
Status
Membre
-
Nedjma -
Nedjma -
Hello,
I applied a formatting to a table by:
- selecting my table
- clicking on format as table and choosing one with the color I wanted.
Oops, I forgot one column, the table is created, I can only extend the table to the right but the column to be added is at the back... what should I do?
Thank you.
Configuration: Macintosh / Firefox 52.0
I applied a formatting to a table by:
- selecting my table
- clicking on format as table and choosing one with the color I wanted.
Oops, I forgot one column, the table is created, I can only extend the table to the right but the column to be added is at the back... what should I do?
Thank you.
Configuration: Macintosh / Firefox 52.0
4 réponses
I found the answer:
Remove a table without losing its formatting or data format
After creating a table, you may choose to stop using its specific table functionality or to only use a table style without this functionality. To stop working with your data in a table without losing the formatting of the applied table style, simply convert the table to a regular data range on the spreadsheet.
Click anywhere in the table.
This will cause the Table Tools tab in the ribbon to be displayed.
Under the Design tab, in the Tools group, click on Convert to Range.
Remove a table without losing its formatting or data format
After creating a table, you may choose to stop using its specific table functionality or to only use a table style without this functionality. To stop working with your data in a table without losing the formatting of the applied table style, simply convert the table to a regular data range on the spreadsheet.
Click anywhere in the table.
This will cause the Table Tools tab in the ribbon to be displayed.
Under the Design tab, in the Tools group, click on Convert to Range.
etiennette57
Posted messages
471
Status
Membre
571
and then recreate the table as it should be.
Nedjma
Thank you very much!
