how do I copy an entire worksheet to another with text & format?

K

kb

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

Peo Sjoblom

Select the sheet using ctrl + a, then copy and paste, if you have formulas
that you don't want to link to the original sheet replace the = in the
formulas with a unique string like r=, thendo the copying and paste, then
reverse and replace r= with = on both sheets

Regards,

Peo Sjoblom
 
K

k-cess

I am able to copy/paste words in the worksheet. Perhaps I'm using the wrong
terms. I realize formulas are not what I need. "Formats" are what I would
like to copy. Column widths, and row heights. I would like the second
sheet to LOOK LIKE the first one in all respects. Thank you.
 
I

IanRoy

kb said:
I have tried "move / copy sheet" but it inserts an entire new sheet. Info is
not put into an existing sheet. thanks
Click to expand...

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

IanRoy

Hello k-cess,

Control+a, click format painter button (looks like a paintbrush), switch to
second sheet, click in upperleftmost cell.

Regards,
IanRoy
 
K

k-cess

Hi... now I am "k-cess" i believe.... a little mix up, can still call me kb.
I did get all of the words (am making a calendar) I did get the column
widths, but the row heights did not transfer in. By the way.... where does
"Control V" come in? what is it?
thank you, kb/k-cess
 
K

k-cess

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
 
A

Arlie Black

I'm just going by memory, but I think what you need to do
is select the whole worksheet first by clicking in the
control cell at the upper left corner of the worksheet
(does not have any reference, it's perpendicular to the A
Column and the 1 Row) then do your copying!
 
K

k-cess

Guess what!!!!! Now for some reason it works!!!! I believe it is because I
am now using the mouse to select the first cell up top left. A1... maybe I
had not become an active part of the worksheet? (by selecting / inserting
into a cell????)
thank you again!!!!!
 
K

k-cess

thank you again....

IanRoy said:
Hello k-cess,

Control+a, click format painter button (looks like a paintbrush), switch to
second sheet, click in upperleftmost cell.

Regards,
IanRoy
Click to expand...
 
K

k-cess

That was totally it. Thank you.

Arlie Black said:
I'm just going by memory, but I think what you need to do
is select the whole worksheet first by clicking in the
control cell at the upper left corner of the worksheet
(does not have any reference, it's perpendicular to the A
Column and the 1 Row) then do your copying!
Click to expand...
 
J

JAmmer

What if you don't want to copy the entire sheet, but just want the top few
rows, to use like a header, with specific column widths, and specific row
heights that are different? This method will not work. Even
selecting/copying the rows, with the format painter, will only get the row
height, but not the column widths.
 
K

k-cess

Thank you so very much..... where did you learn such things???
School? .... Reading Books? .... Microsoft itself?
Thanks again.
kb, princessofnotenoughinfo
 
C

Cush

Try clicking in the upper left hand corner of the sheet to highlight the
entire sheet.
Then do the copy command
Then open the workshhet in to which you want to copy
Then click paste speacial (default choice is "ALL" which is ok
Say OK

I just went through the same thing and this seems to work. You may have to
do "view", Page Break View", then back to "Normal View" in order to see that
the page breaks are showing to make sure all is ok

Do know about "grouping" worksheets? This allows you to make changes in one
sheet that are reproduced in all the "grouped" sheets. Don't forget to turn
off the "gouped" sheets when you are done.
 
Top