copy and paste named cells

  • Thread starter Thread starter greg
  • Start date Start date
G

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
 
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
 
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.
 
Back
Top