View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
GIORGOS GIORGOS is offline
external usenet poster
 
Posts: 2
Default Do not paste in hidden cells

I have a spreadsheet with 30 rows I hide 20 that are not in order and I want
to copy and paste data from another spreadsheet only in the visible cells.
But when I copy and paste excel paste from the cell I select and continues
pasting also at the hidden cells so I loose the order. Is there a way to
avoid pasting data in the hidden cells?