SOLVED
Home

Column(s) in table not formatting with table

%3CLINGO-SUB%20id%3D%22lingo-sub-1096664%22%20slang%3D%22en-US%22%3EColumn(s)%20in%20table%20not%20formatting%20with%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1096664%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20currently%20working%20on%20an%20excel%20spreadsheet%20with%20tables%20and%20there%20are%20several%20columns%20that%20will%20not%20change%20with%20the%20formatting%20of%20the%20table.%20It%20acknowledges%20these%20columns%20as%20part%20of%20the%20table%2C%20but%20any%20overall%20changed%20made%20to%20the%20table%20do%20not%20affect%20these%20columns.%20Does%20anyone%20know%20the%20fix%20for%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1096664%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1096747%22%20slang%3D%22en-US%22%3ERe%3A%20Column(s)%20in%20table%20not%20formatting%20with%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1096747%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F510511%22%20target%3D%22_blank%22%3E%40Philip-S%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20use%20Resize%20Table%20located%20in%20the%20Table%20Design.%20This%20will%20incorporate%20data%20that%20did%20not%20automatically%20updates%20when%20added%20to%20an%20existing%20table%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F164255iA348FF8F8E96E429%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20alt%3D%22clipboard_image_0.png%22%20title%3D%22clipboard_image_0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1096752%22%20slang%3D%22en-US%22%3ERe%3A%20Column(s)%20in%20table%20not%20formatting%20with%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1096752%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F421698%22%20target%3D%22_blank%22%3E%40Abiola1%3C%2FA%3E%26nbsp%3BJust%20tried%20that%20and%20the%20affected%20columns%20have%20still%20not%20formatted%20correctly.%20Thank%20you%20for%20the%20reply%20-%20any%20other%20ideas%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1096772%22%20slang%3D%22en-US%22%3ERe%3A%20Column(s)%20in%20table%20not%20formatting%20with%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1096772%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F510511%22%20target%3D%22_blank%22%3E%40Philip-S%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20that%20like%20this%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20297px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F164257i04F69B2327FA6CB8%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3Eselect%20the%20table%20(stay%20inside%20it%20and%20Ctrl%2BA)%2C%20after%20that%20Home-%26gt%3BClear-%26gt%3BClear%20Formats%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20340px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F164258i06679ADCFB470918%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EResult%20is%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20226px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F164259i1201B6CEC79566F3%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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?

3 Replies
Highlighted

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 

 

clipboard_image_0.png

Highlighted

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

Highlighted
Solution

@Philip-S 

If that like this

image.png

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

image.png

Result is

image.png

Related Conversations
Documentation Migration
SunLeo in Office 365 on
0 Replies
Counting Days
Tim Hunter in SQL Server on
2 Replies
Cell Validation - Drop Down Lists and Text Formatting
JenSmith in Excel on
1 Replies
PivotTable : Unexpected behavior with 2 tables
CastyChichi in Excel on
2 Replies