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

Written by

Editorial Team

Reviewed by

Laura Tsitlidze

Last updated on May 25, 2023

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

copy from another sheet intro

Copy a Cell From Another Sheet

In Excel, you can easily copy cells across worksheets. Say you have the value 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

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

copy cell from another sheet 3

This copies the value from cell A1 on Sheet1 (10) 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.

copy from another sheet gs

AI Formula Generator

Try for Free

See all How-To Articles