Thread: Copying a Worksheet on to a Blank One

In the past, I have successfully copied the contents (text, formulas and formats) from one worksheet on to a blank one.

However, when I try to do the same when my original worksheet has a couple of graphics, only the text and some of the formatting gets copied. Column widths and the graphics do not get copied on to the blank sheet.

I use Excel 2003. I copy the entire sheet by clicking on the rectangle on the header that is above row-1 and to the left of column-A (the "Select-All' button). This selects the entire worksheet. I presume this will also select the graphics to be copied.

So, in short - how do I copy an entire worksheet (text, graphics and all formatting) on to a blank sheet, so that it will appear exactly like the original?

Thanks.

Edit > Move or copy sheet, ...

Thanks shg,

Sometimes the answer is staring you in the face, but you can't see it. I am one of those guys.

Best Regards.

Sometimes the answer is staring you in the face, but you can't see it

Been there ...

You're welcome.