Copy and Pasting Hidden Cells

%3CLINGO-SUB%20id%3D%22lingo-sub-2893362%22%20slang%3D%22en-US%22%3ECopy%20and%20Pasting%20Hidden%20Cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2893362%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20templates%20set%20up%20for%20my%20managers%20to%20use%20in%20excel.%26nbsp%3B%20While%20using%20these%20templates%20the%20managers%20need%20to%20copy%20information%20from%20one%20tab%20to%20another.%26nbsp%3B%20Each%20tab%20had%20hidden%20columns%2C%20it%20used%20to%20be%20that%20excel%20would%20copy%20and%20paste%20the%20hidden%20cells%2C%20making%20it%20match%20up%20to%20the%20template.%20Recently%20about%20half%20of%20my%20managers'%20excel%20is%20only%20copying%20visible%20cells%2C%20so%20they%20don't%20paste%20correctly%20into%20the%20templates.%26nbsp%3B%20If%20it%20was%20the%20same%20across%20the%20board%20I%20could%20just%20recreate%20the%20template%2C%20but%20it%20is%20not.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2893362%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I have templates set up for my managers to use in excel.  While using these templates the managers need to copy information from one tab to another.  Each tab had hidden columns, it used to be that excel would copy and paste the hidden cells, making it match up to the template. Recently about half of my managers' excel is only copying visible cells, so they don't paste correctly into the templates.  If it was the same across the board I could just recreate the template, but it is not. 

1 Reply
Excel has been omitting hidden rows and columns from a paste for quite some time now. If you want to have consistency in how the copying and pasting works, all I can think of is that you provide them with a button to click on tied to a macro that does this exactly as needed.