Jan 08 2020 06:47 AM
I am currently working on an excel spreadsheet with tables and there are several columns that will not change with the formatting of the table. It acknowledges these columns as part of the table, but any overall changed made to the table do not affect these columns. Does anyone know the fix for this?
Jan 08 2020 07:22 AM
Hello @Philip-S
You can use Resize Table located in the Table Design. This will incorporate data that did not automatically updates when added to an existing table
Jan 08 2020 07:26 AM
@Abiola1 Just tried that and the affected columns have still not formatted correctly. Thank you for the reply - any other ideas?
Jan 08 2020 07:32 AM
SolutionIf that like this
select the table (stay inside it and Ctrl+A), after that Home->Clear->Clear Formats
Result is
Jan 08 2020 07:32 AM
SolutionIf that like this
select the table (stay inside it and Ctrl+A), after that Home->Clear->Clear Formats
Result is