What happens if you CTRL + a(twice in 2003) to select the entire sheet contents.

Now insert a new sheet, select A1 and Paste.


Gord

On Sat, 8 Mar 2008 15:43:01 -0800, Beto wrote:

It has "Move or Copy" only and you must select the checkbox for "create a copy"
This is correct and it is exactly what I have been doing. If I copy and
paste into a blank sheet the columns looses their actual widths.







"Gord Dibben" wrote:

Right-click on sheet tab has no "copy sheet"

Move or Copy" only and you must select the checkbox for "create a copy"

Perhaps you are just moving sheet1 from where it is to where it is.


Gord

On Sat, 8 Mar 2008 14:15:01 -0800, Beto wrote:

nothing happen at all.


"Gord Dibben" wrote:

With no workbook protection enabled under ToolsProtectionProtect Workbook my
guess would be the workbook is shared.

You should get a message to that effect when you attempt to copy the sheet.

Do you get no message?

Do you get any message?

Does nothing happen at all?


Gord Dibben MS Excel MVP

On Sat, 8 Mar 2008 13:12:01 -0800, Beto wrote:

excel version 2003
neither the workbook or the sheet are protected
Does any one knows what could be the problem I am having?

Please help,
Beto

ps this problem is only on one of my files.