Thread: How do I paste a vertical list skipping over the hidded rows?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Excel_Learner Excel_Learner is offline
external usenet poster
  
Posts: 53
Default How do I paste a vertical list skipping over the hidded rows?
Select the cells you want to copy. Press F5 key, click on Special Tab and
click on Visible Cells Only. Then copy it and paste.

"Jerry1Gman" wrote:

I am trying to copy a colume of data from a filtered list to a second
filtered list. But Excel keeps pasting into the hidden rows also. This second
list has every other row blank for hand written notes.

Reply With QuoteReply With Quote