Copy & paste a worksheet...

[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...

 

[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...

 

[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...