Copying Tab within a Workbook

M

Madelene

I have a big workbook with multiple tabs. When I need to copy a tab within a
workbook, a message appears saying "a formula sheet you want to move or copy
contains the name "xxx" which already exist on the destination w/s. Do you
want to use the version of the name?" I keep clicking until the name
finishes from the alphabetical sequence. It is so timing consuming. Could
someone pls help me?
 
P

Pete_UK

If you want to create a copy of a sheet, the quickest way is to hold
down the CTRL key and drag the sheet tab horizontally - a small arrow
will indicate where the tab will be inserted when you take your finger
off the mouse button. As this is a straight copy, you will not get the
warning message.

Hope this helps.

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Defined Names in Formulas when copying Worksheets in a Workbook 1
Copying Tab references 4
copying data validation to another workbook 3
Summary worksheet within a workbook 5
Copying data from cells A1,B1,C1 on tab1 to tab2 1
ERROR 2
Quickly locate a specific page/tab in workbook 4
Excel 2007 crashes on copying worksheet to new workbook 0

Top