How to copy and paste a table in Excel

Copying and pasting a table in Excel refers to selecting a table of data that has been created in Excel or from another application, and then copying the data to the clipboard to paste it into a new location or worksheet in Excel.

Our dataset comprises of a store bill in the form of a table that includes product names, corresponding quantity, and their respective prices. Our objective is to duplicate this table and paste it into a new worksheet. To accomplish this task, we have four different methods explained in the following steps.

Method 1: Copy and Paste the Table by using the shortcut Keys
Step 1 – Select the table

• Select the table you want to copy

Step 2 – Press the CTRL+C key

• After selecting the table press the CTRL+C keys to copy the table

Step 3 – Select the Cell

• Click on the Cell where you want to paste the table
• Here we have selected a cell in a new sheet, you may select the cell in the same sheet table is present

Step 4 – Press the CTRL+V key

• After selecting the cell, Press the CTRL+V key to get the required result

Method 2: Copy and Paste the Table by copying the Columns of the table

Step 1 – Select the Columns

• Select the Columns of the table
• To select the column separately, select the first column
• After selecting the first column, select the other columns while pressing the CTRL key

Step 2 – Copy the Column

• After selecting the columns, press the CTRL+C key to copy it

Step 3 – Select the Cell

• Click on the Cell where you want to paste the table
• Here we have selected a cell in a new sheet, you may select the cell in the same sheet table is present

Step 4 – Paste the Columns

• After selecting the cell, press the CTRL+V keys to get the required result

Method 3: Copy and Paste the Table by using the Context menu

Step 1 – Select the table

• Select the table you want to copy 

Step 2 – Copy the table

• After selecting the table, right-click anywhere in the selected area and a context menu will appear
• Click on copy option, in the context menu

Step 3 – Select the Cell

• Click on the Cell where you want to paste the table
• Here we have selected a cell in a new sheet, you may select the cell in the same sheet table is present

Step 4 – Paste the Table

• After selecting the cell, right-click on it, and a context menu will appear
• From this menu, click on the Paste option to get the required result

Method 4: Copy and Paste the table by first pasting the values and then pasting the Format

Step 1 – Select the table

• Select the table you want to copy

Step 2 – Press the CTRL+C key

• After selecting the table press the CTRL+C keys to copy the table

Step 3 – Select the Cell

• Click on the Cell where you want to paste the table
• Here we have selected a cell in a new sheet, you may select the cell in the same sheet table is present

Step 4 – Paste the value

• After selecting the cell, right-click on it, and a context menu will appear
• From this menu, click on the Paste Values option and the values will be shown

Step 5 – Paste Format

• After pasting the value, right click anywhere and context menu will appear
• From this menu, click on the Paste formatting option to get the required result