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

Hello Julcia,
Try to past them by right-click "Insert Copied Cells"

--
MFS22


"julcia" كتب:

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.