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).

a sample Excel data


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.
    visible cells pasted with Ctrl+V
  4. Select any cell.
  5. Press Ctrl+V to paste the data.
    visible cells pasted with Ctrl+V

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.
    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.
    Go To Special dialog boxOnly 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.
    Quick Access Toolbar icon > More CommandsThe “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 "Customize the Quick Access Toolbar" pane

The command will be added to the Quick Access Toolbar.

QAT commands

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.
    Using "Select Visible Cells" command from QAT
  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 Visible Cells Only  | Excel Cells | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Md. Abdul Kader
Md. Abdul Kader

MD. ABDUL KADER is an engineer with a talent for Excel and a passion for VBA programming. To him, programming is like a time-saving wizard, making data manipulation, file handling, and internet interactions a breeze. His skill set extends to SWM, GIS, RS, and SPSS. He holds a B.Sc in Urban & Regional Planning from Chittagong University of Engineering and Technology and has shifted to become a content developer. In this role, he crafts technical content centred around... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo