Forum Discussion

Philip-S's avatar
Philip-S
Copper Contributor
Jan 08, 2020
Solved

Column(s) in table not formatting with table

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...
excel
  • SergeiBaklan's avatar
    SergeiBaklan
    Jan 08, 2020

    Philip-S 

    If that like this

    select the table (stay inside it and Ctrl+A), after that Home->Clear->Clear Formats

    Result is

Abiola1's avatar
Abiola1
MVP
Jan 08, 2020

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 

 

Philip-S's avatar
Philip-S
Copper Contributor
Jan 08, 2020

Abiola1 Just tried that and the affected columns have still not formatted correctly. Thank you for the reply - any other ideas?

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Jan 08, 2020

    Philip-S 

    If that like this

    select the table (stay inside it and Ctrl+A), after that Home->Clear->Clear Formats

    Result is

Resources