Everytime we copy the data and paste in new sheet , it get unfit . Some data unvisible and Column are not unfit .we require to column auto resize method 1 press CTRL + A then press Alt then button H then button O then button I it easy but if you have many sheet method 2 copy it on module Sub autofit () Rows. Entirerow. Autofit Columns. Entirecolumn. Autofit End sub