How to copy only visible cells in Google Sheets

Copying only visible cells in Google Sheets refers to the process of copying only the cells that are currently visible in your spreadsheet, rather than copying all of the cells in the selected range. This is particularly useful when you have filtered your data, or hidden rows or columns, and you only want to copy the visible data.

Our dataset contains store data, which includes sales of various products across different months of the year. Now, we want to create a report on a new sheet that focuses only on selected products. To achieve this, we will hide the unwanted product, and then copy the visible cells of the selected products and paste them onto the new sheet. To copy them we have 2 methods.

Method 1: Copy Visible cells using Keys

Step 1 – Select the First Column

• Select the first column that you want to copy

Step 2 – Select the Other columns

• After selecting the first column, press the CTRL key
• While pressing the Ctrl key, select the other columns

Step 3 – Press the CTRL+C key

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

Step 4 – Select the cell

• After copying the columns, click on the cell to  select the cell where you want to paste the cells

Step 5 – Press the CTRL+V key

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

Method 2: Copy Visible cells using the Copy and Paste options

Step 1 – Select the First Column

• Select the first column that you want to copy

Step 2 – Select the Other columns

• After selecting the first column, press the CTRL key
• While pressing the Ctrl key, select the other columns

Step 3 – Click on the Edit tab

• After selecting the range of cells, click on the Edit tab and a drop-down menu will appear

Step 4 – Click on the Copy option

• From the drop-down menu, click on the Copy option an the selected cells will get copied

Step 5 – Select the cell

• After copying the columns, click on the cell to  select the cell where you want to paste the cells

Step 6 – Click on the Edit tab

• After selecting the range of cells, click on the Edit tab and a drop-down menu will appear

Step 7 – Click on the Paste option

• From the drop-down menu, click on the Paste option to get the required result