Share via

Copy and Paste Data INCLUDING Hidden Columns

Anonymous
2016-04-07T18:15:46+00:00

**1.**When I copy and paste data in a sheet with hidden columns, it will not paste the hidden columns, it is only pasting the visible columns. I have SEVERAL pre-made templates and it is extremely inefficient to unhide the number of necessary columns each time I need to copy and paste.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2016-04-07T19:46:20+00:00

If you are copying entire columns, then the hidden column is copied - but the copy of the column remains hidden.

If you copy just a portion of the columns, then when the paste is performed, the cells from hidden columns are not hidden because 'hidden' is not a property of the cells but of entire columns.

Of course, filtered values are treated differently - though they look hidden, they are not: they are not visible, which is different.

Was this answer helpful?

9 people found this answer helpful.
0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest