View Single Post
  #15   Report Post  
Posted to microsoft.public.excel.misc
bukti bukti is offline
external usenet poster
 
Posts: 3
Default how do I copy an entire worksheet to another with text & forma



"cwilson" wrote:

Hi,

ctrl+a = select all
ctrl+c = copy selection
ctrl+v = paste selection

cwilson

"k-cess" wrote:

Thank you... it almost worked... however, the row heighths did not come thru.
I am now k-cess, and kb... (somehow I am a newbie, and acquired 2 names.) I
also sent another reply, but it got an error... so if you get two from me...
that is what happened. PS... where does "Control V" come in? what does it
mean? kb

"IanRoy" wrote:

"kb" wrote:

I have tried "move / copy sheet" but it inserts an entire new sheet. Info is
not put into an existing sheet. thanks

Hi kb,

Control+a, control+c, select the sheet you wish to paste into, control+v.
Headers and Footers will not be transferred with this method.