View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
gvm gvm is offline
external usenet poster
 
Posts: 38
Default "ignoring" hidden cells in a copy/paste operation

I seem to remember in past versions that I could specify that I wished only
to select values in visible cells for the purpose of copying/pasting
elsewhere. It doesn't seem to be an option anymore so how is it to be done
now? For example, values may be invisible because the column or row is
hidden, or because outlining is being used. How do I in that case, select
only the values that are visible please? TIA ... Greg