Home » Hide

Tag: Hide

Excel – Copy and paste excluding hidden columns or rows

Learn how to copy and paste excluding hidden columns or rows.

Ever tried to copy and paste data thinking you will be pasting, excluding the hidden columns or rows?

Copying a data range that contains hidden data can be challenging. You may have tried this and found that the hidden data travels with the copied range.

In this post I’ll explain how to copy and paste only the visible data – hidden cells are excluded.

 

Continue Reading