Excel? How to copy sheet in workbook w/o having reconfirm cell nam

[Robert M]

How do I copy / duplicate a worksheet within a workbook without having to
reconfirm all the cell names each time I copy the sheet over?

My worksheet has some 27 cell names & I may copy the sheet over many times
within the workbook - thus spending a lot of time pressing "Enter" to accept
the default.

Please advise / Thanks

 

[robert morris]

If I read your request correctly, you want an exact copy of a Worksheet to a
new Tab/Worksheet. If so try this;

On the original sheet, in A1 >Ctrl A , >Ctrl C, open a new Tab/Worksheet
& >Ctrl V.

Bob

 

[Robert M]

Thanks - Tried It, However, I still had to reconfirm reusing all the same
names in the new tab/worksheet, it also lost all the column width & row
heigth settings.