Copy Tab function not working
Curt
Tabs, but when I highlight the tab(s) and select "copy", nothing happens.
Suggestions?
Thanks!
David Biddulph
news:68A190DF-56A2-41BD...@microsoft.com...
> For some reason, the copy tab function is not working for me. I can move
> Tabs, but when I highlight the tab(s) and select "copy", nothing happens.
>
> Suggestions?
If you've clicked on a worksheet's tab & selected "copy", then it should
have placed a copy of the currently selected cell or cells from that
worksheet into the clipboard, from which you can paste into another
worksheet (or elsewhere on that worksheet, or into another Windows
application). [You'll get an animated moving border around the cells that
have been copied, & you can clear that with the Escape key.] That's what
"copy" does, so I'm not quite sure what you mean by "nothing happens".
If you want to copy the whole worksheet, then the function you want is "Move
or Copy Sheet" (from the Edit menu, or by right-clicking the worksheet tab).
Did you try putting "copy tab" into Excel's help?
--
David Biddulph
Curt
Sorry for the confusion....let me restate the question. I am attempting to
copy a worksheet (elsewhere in the current workbook or to another). I right
click on the tab name, select "move or copy" then click on the "create a
copy" box and select the destination. When I click "ok", the copy is not
created. If I do not select the "create a copy" box, then the tab is moved
to the destination properly. This is a function I have used countless times
in the past, so I am wondering if anyone has seen a glitch like this and if
so, do they have a solution (other than re-installing Excel).
Thanks for your response.
Curt
Gord Dibben
No error message?
If the workbook is shared you can move sheet tabs by dragging or right-click and
move, but cannot "create a copy".
You will get a message stating "you cannot do that on a shared workbook"
Gord Dibben MS Excel MVP