Hi. I create a new sheet and copy the last one to it. Not all formatting is coppied like freeze top row. Paste special is the other method but these are radio buttons not check boxes and it is defaulting to ALL but all does not include freeze top row.



Is there another way or do I need to clean up the new sheet where nessessary?

Right-click on sheet tab, and select Move or Copy;
Check "Create a copy";
In case you want to insert the copy of sheet into another (opened) workbook, select the target workbook. By default the current workbook is target;
Select the position where you want the new sheet to be inserted (before certain other sheet, or at end (i.e. as last sheet in workbook);
Clikk OK button. A copy of sheet is created with some order number added to end of previous sheet name as by-default new sheet name. Rename the new sheet;
In case you don't want some old data remaining in new sheet, select the whole datarange, uncheck any cells you want to preserve (like column headers, columns with formulas, etc.), and use "Clear Cells" from right mouse-click on selected datarange - all previous data from active selection is removed, but all formatting remains.

In case you had Named Ranges defined in your source sheet, then there may be some problems with them - you have to check them, and probably to delete some of them the Excel added there

Thanks ArviLaanemets, That works fine even to another excel book. Thanks.

Keep Ctrl button pressed down -Click and drag the tab from the sheet to be copied to where you want- Done

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post