copy and paste named cells

[greg]

Is there a way to copy a whole sheet.
Then paste it into a new sheet. Including the named cells and values?
in paste special? or somewhere else?
thanks

 

[Bernard Liengme]

Copy to the same workbook:
Click on the tag of the source worksheet; hold CTRL; drag the tab to the new
position

Copy to another workbook
Use Windows | View | Arrange so bat workbooks can be seen
Use the technique above

best wishes

 

[Mike Kennedy]

Try to click on cell a1 then hit ctrl A then ctrl c then click on the new
tab and hit ctrl v

that should copy everything over to the new tab including the named cells.
but that would give you two places with cells that have the same name and
might throw excel into a fit. hit ctrl x to cut from one worksheet then ctrl
v to paste into the new one.