How to Copy a Cell to Another Workbook

Save

Microsoft Excel, a part of the Microsoft Office suite, is a spreadsheet program popular both in home and business environments. An Excel file, or workbook, consists of worksheets, which are the spreadsheets. Each spreadsheet is made up of cells. Each individual cell can be copied and then pasted either within the same or a different worksheet. However, you can also copy the data to another workbook. This is useful because you don't have to manually input the same data over and over again in each of your workbooks.

  • Click the cell that you want to copy to select it.

  • Right click the cell and select "Copy," or press the "Ctrl" and "C" keys at the same time.

  • Open another workbook and select the worksheet you want to paste the cell to. Right click the cell you want to copy contents to from the original worksheet and click "Paste," or press the "Ctrl" and "V" keys at the same time.

  • Click the "Paste Options" button next to the pasted cell to choose specific paste options, such as cell formatting.

References

Promoted By Zergnet

Comments

You May Also Like

Related Searches

Check It Out

Geek Vs Geek: Robot battles, hoverboard drag race, and more

M
Is DIY in your DNA? Become part of our maker community.
Submit Your Work!