+5 votes
114 views
How to copy and paste visible cells in Microsoft Excel

in Guides by (551k points)
reopened | 114 views

1 Answer

+3 votes
Best answer

By default with hidden cells in Excel
Copy and paste visible cells only in Excel

It is possible to hide columns, rows or cells in Excel, the problem comes when copying and pasting, not only the visible cells appear, but also the hidden ones. What can we do? In this simple guide we are going to see step by step how we can copy and paste only the visible cells in Microsoft Excel . Best of all, with just a few clicks, you can fix this annoying problem and get on with your work. Let's see how to fix it!

By default with hidden cells in Excel

By default, when we copy cells in Excel which contain hidden cells, these hidden cells are visible when pasting..

image

In this example, we hide rows 3 to 12 (February to November) where the screenshot can be seen clearly.

image

When we select the range of visible cells, we use the Copy and then Paste action, these hidden cells appear..

Obviously if this is not what we want, then we will see how we can do it.

Copy and paste visible cells only in Excel

The function in question is available in both Microsoft Excel for Windows and Mac; it works the same way in both cases..

image

We are going to start by selecting the cells that we want to copy and paste . After this, we will have to go to the "home" tab and click on the drop-down arrow of the search icon that is represented by a magnifying glass icon. In the drop-down menu we are going to choose "Go to special".

image

In the window that opens, we will have to choose "Only visible cells" and then we click on accept.

image

With the cells selected, we are going to use the copy action from the toolbar or press Ctrl + C on Windows or Command + C on Mac. Additionally, we can right-click with the mouse button and choose “Copy”.

image

Now we are going to have to go to where we want to paste the cells and we will have to use the paste action. The easiest thing is to use Windows + V or Command + V on Mac. We can also right click and select "Paste".

image

Now we would have to see pasted only the visible cells in your selection.



by (3.5m points)
edited

Related questions

+4 votes
1 answer
asked Aug 8, 2023 in Office by backtothefuture (551k points) | 46 views
+4 votes
1 answer
asked Oct 1, 2019 in Office by backtothefuture (551k points) | 219 views
+5 votes
1 answer
asked Oct 3, 2019 in Office by backtothefuture (551k points) | 193 views
+3 votes
1 answer
asked Sep 21, 2019 in Office by backtothefuture (551k points) | 205 views
+4 votes
1 answer
asked Oct 8, 2019 in Office by backtothefuture (551k points) | 235 views
Sponsored articles cost $40 per post. You can contact us via Feedback
10,634 questions
10,766 answers
510 comments
3 users