Thread: How do I omit content within a hidden row and copy only viewable r
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson Dave Peterson is offline
external usenet poster
  
Posts: 35,218
Default How do I omit content within a hidden row and copy only viewable r
Select your range to copy
edit|goto special|Visible cells only
edit|copy

and then paste.

Keith wrote:

I have hidden rows in a spreadsheet. I want to remove them and only have
viewable rows. I have tried copying and pasting but I still get the hidden
row content.

--

Dave Peterson
Reply With QuoteReply With Quote