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.
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”.
In the window that appears, select Visible Cells Only and click OK.
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.
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.
You should then only see the visible cells from your cell selection 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.