View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
julcia julcia is offline
external usenet poster
 
Posts: 2
Default How do I paste in sorted area?

I sort the column (from drop-down list) and what omits some cells in that
column. Then I want to paste something into that sorted area (except from
omitted cells) but the program pastes it also in these omitted cells not in
the sorted area that I wanted; I.E. if sorting hid rows 3-to-9, when I'm
pasting certain data, it's being paste also in those rows 3-9.