You may want to rearrange the order of worksheets in a workbook. If you have a separate worksheet for each sales region, for example, arranging the worksheets in alphabetical order or by total sales may be helpful.

You may want to move a worksheet from one workbook to another. (To move a worksheet to a different workbook, both workbooks must be open.) You can also create copies of worksheets.

You can move or copy a worksheet in the following ways:

• Right-click the sheet tab and choose Move or Copy to display the Move or Copy dialog box (see Figure 14-4). Use this dialog box to specify the operation and the location for the sheet.
• To move a worksheet, drag the worksheet tab to the desired location (either in the same workbook or in a different workbook). When you drag, the mouse pointer changes to a small sheet, and a small arrow guides you.
• To copy a worksheet, press and hold Ctrl while dragging the tab to its desired location (either in the same workbook or in a different workbook). When you drag, the mouse pointer changes to a small sheet with a plus sign on it.

FIGURE 14-4
Use the Move or Copy dialog box to move or copy worksheets in the same or another workbook.

If you move or copy a worksheet to a workbook that already has a sheet with the same name, Excel changes the name to make it unique. For example, Sheet1 becomes Sheet1 (2).

• How to Stay Focused With Multiple Streams of Income One of the main problems facing those that have multiple streams of income is managing them. You can start to...
• Minolta Digital Camera Minolta Digital Camera - A Perfect Quality You can Find. Summarize from article written by: Albert Smith [/caption] With so...
• How to Break Up When you decide to end a relationship, what follows can be a difficult, sometimes torturous series of events, especially if...
• Should you write your own tax software? Lazy Man and Money posted a reader's question over in the MBN Forums asking for help: Do you have an...
• Learn to Play Bass Guitar For someone starting out with a first instrument, a bass guitar is an excellent choice. The bass guitar is probably...