Copy & paste a worksheet...

O

Onebrick short...

I copy and paste lots of Excel worksheets. I did know a shortcut whereby when I pasted the old worksheet to a new one it was completly like the old one. I have forgotten which keys I used, Now I have to resize all the columns etc.

Can anyone help? I am using Microsoft Office OS v. X on my Mac.

Thanks...
 
K

keepITcool

on my PC I drag the tab while holding the ctrl key...
can drag within book or to another.


keepITcool

< email : keepitcool chello nl (with @ and .) >
< homepage: http://members.chello.nl/keepitcool >


"=?Utf-8?B?T25lYnJpY2sgc2hvcnQuLi4=?=" <Onebrick short...
 
L

Lady Layla

Right Click on tab, select Move or copy, select where you want it to go, click
Copy if you do not want to lose original in original WB.


message : I copy and paste lots of Excel worksheets. I did know a shortcut whereby when
I pasted the old worksheet to a new one it was completly like the old one. I
have forgotten which keys I used, Now I have to resize all the columns etc.
:
: Can anyone help? I am using Microsoft Office OS v. X on my Mac.
:
: Thanks...
 
Top