Original test data: You may copy from this table into Excel and delete the first column copied to show a table in Excel as above.
After hiding the red columns (c:e) the columns are hidden, but the hidden columns will still copy with copy (ctrl+c) and paste (ctrl+v).
With rows 3:6 hidden and the columns c:e also hidden, will still copy with copy (ctrl+c) and paste (ctrl+v) all rows and columns whether hidden or not.
By then filtering to show "bb" hidden rows with "bb" become visible and all other rows disappear witht the filter. Copying (ctrl+c) and paste (ctrl+v) copies only what is visible. The unexpected result is that hidden columns do not show where before hidden columns would copy. Rows that have been filtered out (made to disappear) are not copied which was expected.
What is seen with the filter invoked is what is copied. This is like the normal nothing hidden but filtering invoked.
Not shown but if Columns were hidden they will remain hidden, when filter it turned off.
Show ALL in Column A, shows that the hidden rows are no longer hidden, and so both the table and the copy look like the original test data.
Hidden rows and/or hidden columns make no difference to copy and paste, all rows and columns get pasted whether hidden or not.
You filter on a column, which filters out rows. Rows that are filtered out are not seen and are not copied.
Filtered out rows do not get copied and that is a terrific feature for Mail Merge and for Copy and Paste in that you don't see them in the pasted data or in what is presented to Mail Merge.
But there were surprises to me along the lines of hidden rows and columns.
- When a filter has been invoked, hidden columns also do not get copied.
- When a filter has been invoked, hidden rows reappear if the filter is showing the value filtered on.
- When the filter is removed after filtering, there are no more hidden rows.
- Not a surprise but hidden columns remain hidden throughout filtering or not filtering. When nothing is filtered out hidden columns and hidden rows get copied as always. When anything is filtered out, hidden columns do not get copied.
Please send your comments concerning this web page to: David McRitchie send email comments
Copyright © 1997 - 2004, F. David McRitchie, All Rights Reserved