How to copy and paste only visible cells in microsoft Excel

You can hide columns, rows or cells in Excel to facilitate data entry or analysis. But if you copy and paste a range of cells with hidden cells, they suddenly come back, right?

You may not know, but there is a way to copy and paste just the visible cells in Microsoft Excel. It doesn’t take more than a few clicks.

Standard copy and paste with hidden cells in Excel

By default, when copying a range of cells to Excel contains hidden cells, these hidden cells are displayed when you paste.

as example, we have hidden lines 3 to 12 (February to November) in the screenshot below.

If we select the visible range of cells, use the copy and then paste action, these hidden cells will appear.

Hidden lines are displayed by default when inserting

If this isn’t what you’d like, read on for how to avoid it.

Copy only visible cells to Excel

This nifty hidden feature is available in Microsoft Excel on Windows and Mac. And luckily, that’s how it works.

First, select the cells that you want to copy and paste. Then go to the Home tab and click the Find & Select drop-down arrow (magnifying glass). Select “Go to Special”.

On the Home tab, click Find & Select and choose Go to Special

In the window that appears, select Visible Cells Only and click OK.

Select only visible cells

With the cells still selected, use the Copy action. You can press Ctrl + C on Windows, Command + C on Mac, right-click and choose Copy, or click Copy (double-sided icon) on the ribbon on the Home tab.

On the Home tab, click Copy

Now move where you want to paste the cells and use the Paste action. You can press Ctrl + V on Windows, Command + V on Mac, right-click and choose Paste, or click Paste on the Home tab on the ribbon.

On the Home tab, click Paste

You should then only see the visible cells from your cell selection inserted.

Only visible cells are inserted

When you do actions like this in. carry out Word Check out our guides on how to cut, copy, and paste in Microsoft regularly Word.

Related Posts