Forum Discussion
Solved
Tables not working as expected
I have a table not acting right. My worksheet is formatted to (Align Left, Increase Indent x 1) When I enter new date in the next row the table, for some reason, the table is adding an indent ...
- Select the entire column of the table that exhibits the "wrong" behavior. Then pull up the format cells dialog and set it as you want it to be. Now try inserting a new row in the table.
Select the entire column of the table that exhibits the "wrong" behavior. Then pull up the format cells dialog and set it as you want it to be. Now try inserting a new row in the table.
This worked! Thank you very much. I have no idea why formatting a cell from the ribbon has a different result.
DRCRAWL Behind the scenes, Excel stores information about the table, which includes a "default" format and formula for each individual column. You change these defaults by changing the entire column (except the header) at once.