How to Copy Only Visible Cells in Excel (Some Quick Methods)

To illustrate how to copy only visible cells in Excel, we’ll use a sample worksheet data with hidden rows (9 to 17).

Method 1 – Using Keyboard Shortcuts

1. Select your data.
2. Press the ALT and ; (semicolon) keys together.
3. Press Ctrl+C to copy the selected data.
   
4. Select any cell.
5. Press Ctrl+V to paste the data.
   

Note: When pasting selected visible cells, choose a destination cell outside the source rows and columns to ensure all pasted cells are visible.

Read More: How to Select Visible Cells in Excel

Method 2 – Using Excel Features and Standard Copy/Paste Methods

Using Go To Special Feature

1. Select your data.
2. Go to Home tab > Editing group > Find & Select > Go To Special.
   
3. Select the “Visible cells only” button in the “Go To Special dialog box.
4. Press OK.
   Only the visible cells will be selected.
5. Copy the visible cells.
6. Select any cell and paste the visible cells.

Read More: How to Paste into Visible Cells Only in Excel

Using the “Select Visible Cells” Command

Step 1: Add the Command to the Quick Access Toolbar

To add the “Select Visible Cells” command to the Quick Access Toolbar:

1. Click on Customize Quick Access Toolbar icon > More Commands.
   The “Customize the Quick Access Toolbar” pane will appear.
2. In the dialog box:
   • Select “All Commands” from the “Choose commands from” menu.
   • Scroll down and select the “Select Visible Cells” command.
   • Click > Add.
   • Click OK.

   

The command will be added to the Quick Access Toolbar.

Step 2: Select, Copy, and Paste Only the Visible Cells

1. Select your data.
2. Click on the “Select Visible Cells” command from the Quick Access Toolbar.
   
3. Press Ctrl+C.
4. Select any cell and press Ctrl+V.

Read More: [Fixed!] Paste Visible Cells Only Not Working

Download Practice Workbook

Frequently Asked Questions

How do I select only visible cells in Excel with data (excluding formulas)?

To select only visible cells in Excel with data:

1. Select your data.
2. Go to Home tab > Editing group > Find & Select > Go To Special.
3. Select the Constants button.
4. Press OK.

How do I copy filtered data in Excel?

To copy filtered data in Excel:

1. Select your data.
2. Press Ctrl+L to apply a filter to your data.
3. Filter your data based on any criteria.
4. Select the filtered cells, and copy them.

How do you drag only visible cells in Excel?

You cannot drag only visible cells in Excel. Excel doesn’t provide any built-in tool to do this.

<< Go Back to Excel Cells | Learn Excel