Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy Tab function not working
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? Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy Tab function not working
"Curt" wrote in message
... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy Tab function not working
David,
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 "David Biddulph" wrote: "Curt" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy Tab function not working
Nothing happens?
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 On Wed, 27 Sep 2006 08:33:01 -0700, Curt wrote: 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? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lookup Function not working | Excel Worksheet Functions | |||
How do I copy a function with a called cell constant? | Excel Worksheet Functions | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
Date & Time | New Users to Excel | |||
Copy GetPivotData Function | Excel Worksheet Functions |