answersLogoWhite

0

The best way is to open both workbooks. Go to the first workbook (source) and copy or cut the data you want to move. Go to the second workbook (target) and paste the data where you want it.

User Avatar

Wiki User

15y ago

What else can I help you with?

Related Questions

How do you move data from one cell to another without using clipboard?

Click on the edge of the cell and drag it to the new location.


What term lets you move or copy data from one cell to another without using the clipboard?

The term is "Drag-and-drop." This method involves selecting the data, clicking and holding the selection, moving it to the desired cell, and releasing the mouse button to move or copy the data.


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 will happen when you drag and drop a worksheet tab into another workbook without holding the Ctrl key down?

It will move the worksheet to the other workbook.


What is the Clipboard in the PC?

On a computer, a clipboard is an application in which allows one to save pieces of data for a later use. For example, if a user selects texts and choose to copy it, the text will be placed in the clipboard to be later pasted.


In Excel when you cut text does it move to the clipboard?

Yes it does.


To move within a document or workbook?

To move within a document or workbook is to navigate. However while navigating you can choose to edit in which case you are then editing.


What is it called when you move data to another computer?

uploading


You're creating a workbook called Contacts which is currently open Which steps will move the Agents worksheet from the Employees workbook to between Sheet1 and Sheet2 in the Contacts workbook?

Select Contacts in the To book drop-down list boxEnsure the worksheet is located before Sheet2In the Employees workbook, open the Move or Copy dialog boxOpen the Employees workbook


Is it true or false the move and copy command accomplish the same task?

No, they do not accomplish exactly the same task. Copy and paste makes a copy of the highlighted text to the clipboard while paste puts that copied data on the clipboard at the new location. Move (which is actually a cut and paste operation) removes the original from its current location and then pastes it to the new location where the paste command is executed.


How do you move a worksheet in Excel 2007?

The question is not clear, but if you have several worksheets in an Excel 2007 workbook, you can move a worksheet to a new location in the workbook by clicking and dragging the worksheet tab to the loction you want.


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.