0
If you have two workbooks and want to move a worksheet from one to the other, you would use the move option. If you want to copy the worksheet so that it is in both workbooks, you would use the copy option.
Wiki User
∙ 13y ago
Add your answer:
Earn +20 pts
In Excel how do you copy an entire worksheet and all its data?
To copy it to another workbook, you can right click on the Sheet Tab and pick the Move or Copy option. To copy it into the same workbook. Click on the sheet tab and then press Ctrl and drag the sheet tab to copy it.
What happens when clicking and dragging a worksheet in Excel?
If you click and drag the worksheet tab, you can reorder the sheets in the workbook. If you are clicking and dragging in the sheet itself, you can move or copy things on the worksheet.If you click and drag the worksheet tab, you can reorder the sheets in the workbook. If you are clicking and dragging in the sheet itself, you can move or copy things on the worksheet.If you click and drag the worksheet tab, you can reorder the sheets in the workbook. If you are clicking and dragging in the sheet itself, you can move or copy things on the worksheet.If you click and drag the worksheet tab, you can reorder the sheets in the workbook. If you are clicking and dragging in the sheet itself, you can move or copy things on the worksheet.If you click and drag the worksheet tab, you can reorder the sheets in the workbook. If you are clicking and dragging in the sheet itself, you can move or copy things on the worksheet.If you click and drag the worksheet tab, you can reorder the sheets in the workbook. If you are clicking and dragging in the sheet itself, you can move or copy things on the worksheet.If you click and drag the worksheet tab, you can reorder the sheets in the workbook. If you are clicking and dragging in the sheet itself, you can move or copy things on the worksheet.If you click and drag the worksheet tab, you can reorder the sheets in the workbook. If you are clicking and dragging in the sheet itself, you can move or copy things on the worksheet.If you click and drag the worksheet tab, you can reorder the sheets in the workbook. If you are clicking and dragging in the sheet itself, you can move or copy things on the worksheet.If you click and drag the worksheet tab, you can reorder the sheets in the workbook. If you are clicking and dragging in the sheet itself, you can move or copy things on the worksheet.If you click and drag the worksheet tab, you can reorder the sheets in the workbook. If you are clicking and dragging in the sheet itself, you can move or copy things on the worksheet.
What does pointing mean in Excel?
Move the mouse cursor to what you want to select.
What key do you use on the keyboard to navigate a worksheet?
The F5 key is used on the keyboard to navigate a worksheet in Microsoft Excel. This allows you to use the "Go To" feature and move around the various cells on the sheet.
How do you move 1 degrees to 90 degrees on a alignment sheet on excel?
Rotating Text
How do you make a duplication of a worksheet in Microsoft Excel?
Open both documents. Go to the sheet you want to copy. Right click on the tab of the sheet you want to copy. Pick the Move or Copy option on the shortcut menu that appears. You can then choose where you want to put it in the other document.
In Microsoft Excel what key combination do you press to move the last cell containing data?
Ctrl - End.
How do you copy Excel charts into word 2003?
Open Excel and right-click on the chart and select copy. Go to Word and paste the chart where you would like to see it on the page, then move the object, as desired.
What bars do you use to move through a work sheet without changing the active cell in Excel?
scroll bars
Why won't excel copy a worksheet?
You can copy a worksheet. Go to the sheet you want to copy. Right click on the tab of the sheet you want to copy. Pick the Move or Copy option on the shortcut menu that appears. You can then choose where you want to put it in the current or even another workbook and if you want to keep an original copy in the current workbook. You could also just insert a new worksheet into the current workbook and then copy and paste what you want from the old worksheet into the new sheet.You can copy a worksheet. Go to the sheet you want to copy. Right click on the tab of the sheet you want to copy. Pick the Move or Copy option on the shortcut menu that appears. You can then choose where you want to put it in the current or even another workbook and if you want to keep an original copy in the current workbook. You could also just insert a new worksheet into the current workbook and then copy and paste what you want from the old worksheet into the new sheet.You can copy a worksheet. Go to the sheet you want to copy. Right click on the tab of the sheet you want to copy. Pick the Move or Copy option on the shortcut menu that appears. You can then choose where you want to put it in the current or even another workbook and if you want to keep an original copy in the current workbook. You could also just insert a new worksheet into the current workbook and then copy and paste what you want from the old worksheet into the new sheet.You can copy a worksheet. Go to the sheet you want to copy. Right click on the tab of the sheet you want to copy. Pick the Move or Copy option on the shortcut menu that appears. You can then choose where you want to put it in the current or even another workbook and if you want to keep an original copy in the current workbook. You could also just insert a new worksheet into the current workbook and then copy and paste what you want from the old worksheet into the new sheet.You can copy a worksheet. Go to the sheet you want to copy. Right click on the tab of the sheet you want to copy. Pick the Move or Copy option on the shortcut menu that appears. You can then choose where you want to put it in the current or even another workbook and if you want to keep an original copy in the current workbook. You could also just insert a new worksheet into the current workbook and then copy and paste what you want from the old worksheet into the new sheet.You can copy a worksheet. Go to the sheet you want to copy. Right click on the tab of the sheet you want to copy. Pick the Move or Copy option on the shortcut menu that appears. You can then choose where you want to put it in the current or even another workbook and if you want to keep an original copy in the current workbook. You could also just insert a new worksheet into the current workbook and then copy and paste what you want from the old worksheet into the new sheet.You can copy a worksheet. Go to the sheet you want to copy. Right click on the tab of the sheet you want to copy. Pick the Move or Copy option on the shortcut menu that appears. You can then choose where you want to put it in the current or even another workbook and if you want to keep an original copy in the current workbook. You could also just insert a new worksheet into the current workbook and then copy and paste what you want from the old worksheet into the new sheet.You can copy a worksheet. Go to the sheet you want to copy. Right click on the tab of the sheet you want to copy. Pick the Move or Copy option on the shortcut menu that appears. You can then choose where you want to put it in the current or even another workbook and if you want to keep an original copy in the current workbook. You could also just insert a new worksheet into the current workbook and then copy and paste what you want from the old worksheet into the new sheet.You can copy a worksheet. Go to the sheet you want to copy. Right click on the tab of the sheet you want to copy. Pick the Move or Copy option on the shortcut menu that appears. You can then choose where you want to put it in the current or even another workbook and if you want to keep an original copy in the current workbook. You could also just insert a new worksheet into the current workbook and then copy and paste what you want from the old worksheet into the new sheet.You can copy a worksheet. Go to the sheet you want to copy. Right click on the tab of the sheet you want to copy. Pick the Move or Copy option on the shortcut menu that appears. You can then choose where you want to put it in the current or even another workbook and if you want to keep an original copy in the current workbook. You could also just insert a new worksheet into the current workbook and then copy and paste what you want from the old worksheet into the new sheet.You can copy a worksheet. Go to the sheet you want to copy. Right click on the tab of the sheet you want to copy. Pick the Move or Copy option on the shortcut menu that appears. You can then choose where you want to put it in the current or even another workbook and if you want to keep an original copy in the current workbook. You could also just insert a new worksheet into the current workbook and then copy and paste what you want from the old worksheet into the new sheet.
When copying or moving cells if data already exists in the destination cells Excel?
will not complete the copy or move procedure
What is a group of excel spreedsheet?
This is called a book - each individual spreadsheet within the book is a sheet. You can move between the sheets within the book by clicking on the tabs at the bottom of the current sheet.
