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.

"IanRoy" wrote:

Hello k-cess,

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

Regards,
IanRoy

"k-cess" wrote:

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.
"Peo Sjoblom" wrote:

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

"kb" wrote:

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