how do I copy an entire worksheet to another with text & format?
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.
--
CD
"kb" wrote:
I have tried "move / copy sheet" but it inserts an entire new sheet. Info is
not put into an existing sheet. thanks
|