How to Copy & Paste a Table in Excel & Google Sheets

Written by

Mel Jenkins

Reviewed by

Laura Tsitlidze

Last updated on January 20, 2023

This tutorial demonstrates how to copy and paste a table in Excel and Google Sheets.


copy table intro

Copy and Paste a Table

  1. Select all the cells in the table you wish to copy.


copy table select


  1. Then, in the Ribbon, go to Home > Clipboard > Copy or press CTRL + C on the keyboard.


copy table copy


  1. Select the destination cell for your table, and, in the Ribbon, go to Home > Clipboard > Paste or press CTRL + V on the keyboard.


copy table paste


Note: When you click Paste (or CTRL + V), all formatting and formulas are also copied, and the formulas is automatically updated. If you don’t want the formatting or formulas, use Paste Special instead.

Copy and Paste Table in Google Sheets

Copying and pasting a table of data works the same way in Google Sheets as it does in Excel. You can use CTRL + C to copy and CTRL + V to paste (with all formatting and formulas).


copy table gs

AI Formula Generator

Try for Free

See all How-To Articles