I have a spread sheet with hidden rows and I want to copy & paste only the visible cells. Please help!
Thanks!
See this earlier post
Hope that helps.
RoyUK
--------
If you are pleased with a member's answer then use the Star icon to rate it, if you are pleased enough to part with cash consider a donation to Children in Need
For Excel Tips & Solutions, free examples and tutorials why not check out my downloads
New members please read & follow the Forum Rules
Remember to mark your questions Solved and rate the answer(s)
select all the rows you want to copy by selecting with the row number so all the row is selected.
then edit/goto/special/select visible cells (or alt+ ; )
now copy paste to new sheet
or you can just do the same by selecting an area of cells
Last edited by martindwilson; 06-29-2010 at 11:39 AM.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and a dabbler in Cisco
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Got it! Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks