I have a table (Parts Library) with a couple of hidden columns (so that columns match the BOM sheet), when I have no filters applied to this table I can copy and paste from it, and it copies the hidden cells as well. When I DO filter the table, excel seems to skip over these columns. 

Is there a way to avoid skipping over these columns? 

Is there a work around for filtering which WOULD let me copy those columns? 

Thanks!

​I have a table (Parts Library) with a couple of hidden columns (so that columns match the BOM sheet), when I have no filters applied to this table I can copy and paste from it, and it copies the hidden cells as well. When I DO filter the table, excel seems to skip over these columns.  Is there a way to avoid skipping over these columns? Is there a work around for filtering which WOULD let me copy those columns?  Thanks!  Read More

​