How to Copy Visible Cells Only in Excel (4 Fast Ways)

Have you faced the troublesome situation of copy-pasting cells with hidden cells? Obviously, it is irritating and time-consuming. This article will demonstrate to you how to copy visible cells only in Excel in 4 Fast Ways. These ways might be helpful for Excel for Microsoft 365, Excel for the web, Excel 2019, Excel 2016, Excel 2013, Excel 2010 & Excel 2007.

4 Ways to Copy Only Visible Cells in Excel

i. Using a Keyboard Shortcut

When you have less time to accomplish any analysis, using shortcuts may be quite helpful for you.  In the following figure, we have a dataset of an institution that contains information about students, though the 4th row is missing. There is a useful keyboard shortcut for copying visible cells only in Excel and it is ALT + ; (semicolon). The following steps are for the keyboard shortcut:

  1. Select the dataset A1:C7
  2. Press ALT + ; (semicolon)
  3. Copy the dataset (by pressing CTRL+C)
  4. Paste basis on your choice (by pressing CTRL+V)

keyboard shortcut for copy only visible cells

ii. Using Go To Special Tool from Home Tab

In the following figure, we see a dataset where the 4th row is missing. In that case, how you can copy only visible cells that are discussed using the Go To Special tool. You may proceed with the following steps:

  1. Chose the Find & Select option
  2. Pick the Go To Special
  3. Click the Visible Cells Only option
  4. Press Ok
  5. Select the cell range A1:C7
  6. Copy the cell range A1:C7 (by pressing CTRL+C)
  7. Paste where you prefer and the result is shown in the following figure (by pressing CTRL+V)

Using Go To Special Tool from Home Tab for copying visible cells only

iii. Another Quick Use of Go To Special Tool

In some cases, you may notice that row is hidden like the following figure where the 4th row is missing. You can overcome the situation by employing another quick use of the Go To Special tool. Necessary steps are shown sequentially:

  1. Select the cell range A1:C7
  2. Enter CTRL+G 
  3. Pick the Special option from Go To tool

Go To Special Tool for Copying Only Visible Cells 11

  1. Chose Visible Cells Only
  2. Press Ok

Go To Special tool for copying only visible cells 2

  1. Select the dataset A1:C7
  2. Copy by pressing simply CTRL+C of the dataset A1:C7
  3. Paste where you want by pressing simply CTRL+V

Go To Special tool for copying only visible cells 3

iv. Customizing Quick Access Toolbar

Located above the left-hand ribbon, the Quick Access Toolbar gives access to widely used commands and capabilities. You can customize the Quick Access Toolbar. In the following figure, we see a dataset of educational institutions where student ID, name, and their program are shown. But if the 4th row is missing, how can you copy only visible cells that are discussed using the Quick Access Toolbar. You may the following steps:

  1. Open Customizing Quick Access Toolbar
  2. Click on More Commands

Customized Quick Access Toolbar for Copying Only Visible Cells1

  1. Select Commands Not in the Ribbon
  2. Pick Select Visible Cells
  3. Click Add
  4. Press Ok

Customizing Quick Access Toolbar for Copying Only Visible Cells 2

  1. Select the cell range A1:C7
  2. Pick the Select Visible Cells
  3. Copy the cell range A1:C7 (by pressing CTRL+C)
  4. Paste where you want and it is the result (by pressing CTRL+V)

Customizing Quick Access Toolbar for Copying Only Visible Cells 3

Conclusion

Now you have the above ways for copying only visible cells in excel, you’ll have no trouble and as far as I assure you. Thank you for reading this article and stay tuned for our next post. If you have any queries or opinions, please share them in the comments section below.


Further Readings

Md. Abdul Kader

Md. Abdul Kader

Hi! I am Abdul Kader and presently working as ‘Excel & VBA Content Developer’ at Exceldemy. I publish my articles related to Microsoft Excel here. In 2019, I completed my graduation in Urban and Regional Planning from Chittagong University of Engineering and Technology. Having extreme eagerness to learn, I want to develop my skills and capabilities higher.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo