Excel - copy and paste named cells

Asked By greg on 12-Jun-08 02:12 PM
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?

Bernard Liengme replied on 12-Jun-08 04:03 PM
Copy to the same workbook:
Click on the tag of the source worksheet; hold CTRL; drag the tab to the new

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

best wishes
Bernard V Liengme
Microsoft Excel MVP
remove caps from email
Mike Kennedy replied on 17-Jun-08 12:10 AM
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.