See all How-To Articles

How to Copy Cell From Another Sheet in Excel & Google Sheets

This tutorial demonstrates how to copy a cell from one sheet to another in Excel and Google Sheets.

 

copy cell from another sheet 5

 

Copy a Cell From Another Sheet

In Excel, you can easily copy cells across worksheets. Say you have 10 in cell A1 of Sheet1 and want to copy that cell to Sheet2.

 

copy cell from another sheet 1

 

1. Right-click the cell you want to copy (cell A1 on Sheet1), and click Copy (or use the keyboard shortcut CTRL + C).

 

copy cell from another sheet 2

 

2. Go to (1) the second sheet (Sheet2), (2) and Right-click the cell where you want to paste (A1), and (3) choose Paste (or use the keyboard shortcut CTRL + V).

 

copy cell from another sheet 3

 

As a result, the value from cell A1 on Sheet1 (10) is now copied to cell A1 on Sheet2.

 

copy cell from another sheet 4

 

There are several options when pasting values. See the following tutorials for a few of those options.

Copy Cells in Google Sheets

In Google Sheets, you can also copy and paste cells to another sheet, following exactly the same steps as in Excel.