Convert range to table without changing column width / formatting

Originally Posted by mastertonn

This is what I have to do now.

Convert to table
It changes the widths and apply its formatting
I have to undo all the changes

You say table then format. It does not help. It apply its formatting automatically. You still have to undo them first even if you format your table later.

I dont think you follow. Formatting things the way you want is something you do AFTER you have done everything else, not before.

IE: add data -> create table -> format
not
add data -> format -> create table -> format

There is nothing you can do about how the table behaves, you are basically saying you want some of the built in parts of a table but not others...you dont get to make that choice, its hard coded by MS that way. What you can and should change is your workflow. The efficient way to work is to save manual formats for the end and do it a single time instead of many time fighting against other features of Excel.