How to format columns in an empty excel sheet?

Question

I have a report of 20 columns in an excel sheet where all columns have a common format.

If I copy the report and paste it onto a new sheet, some of the columns should be in text format.

However, when selecting columns and converting to the required format is easy, but how to make columns in a sheet of the required type after copying from a report?

Please help, thanks in Advance.

Answer 1

If the new report consists of the same formatting, you can simply right-click on the sheet tab at the bottom, select "Move" or "Copy", and then "create a copy" on the new sheet or book. This will save all your formatting.

Then you can do "insert special values" and everything should be as you like.

I shortened the steps ... I can make them more concise if it sounds like it will solve your problem.