Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I suspect the solution will be related to this question??

I have a spreadsheet that comes to me pre-formatted with hidden columns sprinkled in multiple places (for viewing brevity's sake). I need to turn on filtering, apply a filter to one of the columns, and then paste the resulting rows to a new sheet - including the hidden columns (lather, rinse, repeat). I'd prefer to not undo/re-do the hidden columns unless I have to. Is it possible to paste the hidden columns without adding the extra steps?

share|improve this question
add comment

1 Answer

Can't you use the automated undo feature of Excel (ctrl-z)? I.e. ...

  • select the whole spreadsheet
  • unhide
  • do your filtering
  • select and copy what you want
  • ctrl-z ( to undo things)
  • paste
share|improve this answer
1  
If I only had to do it once or twice, sure. But I need to do many and often. –  hudsonsedge Dec 12 '12 at 20:00
    
I see on the Advanced Filter window, there is an option "Copy to another location." Does that not work for you? –  jcfollower Dec 12 '12 at 20:07
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.