Forum Discussion
Excel Table Auto Formatting Issue
I have a table in my expenses spreadsheet. To add new rows, I type in the row below the last one in the table and it automatically adds it to the table range; my problem however, is that the new rows...
If you select entire table column and apply to it some format (e.g. center aligned), each next added row keeps such applied format.
If cells in the column are differently formatted, e.g. in first row left aligned, second row center aligned, cells in each next added row will keep default format (or format applied initially to entire column), not previous row format.
To my knowledge we can't change such behaviour.