View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JLR-Mart JLR-Mart is offline
external usenet poster
 
Posts: 24
Default Copy and paste - filtered data

I have filtered a worksheet which results in many rows being 'hidden'. When I
select a range of cells to copy (all in one row) that I want to shift one row
left, I cannot paste correctly. Excel seems to include 'hidden' rows as part
of the paste process.

Any ideas why?