I dont want to copy hidden rows

  • Thread starter Thread starter sh0t2bts
  • Start date Start date
S

sh0t2bts

Hi All,


I have a spreadsheet that depending on what is entered in to cell A1 it
hides certain rows from row 20 through to row 300, what I want to now do is
copy what rows are left unhidden and paste them onto another sheet..


How would I do this cos every time I have tried it I paste all 300 rows?


Many Thanks

Mark
 
Once you have selected all 300 rows , including the hidden
ones, go to EDIT > GOTO > SPECIAL > VISIBLE CELLS ONLY > OK

This will unselect hidden rows, then copy and paste...

Regards
JS
 
simple when you know how!!


Many Thanks


Mark
Juan Sanchez said:
Once you have selected all 300 rows , including the hidden
ones, go to EDIT > GOTO > SPECIAL > VISIBLE CELLS ONLY > OK

This will unselect hidden rows, then copy and paste...

Regards
JS
Click to expand...
 
Back
Top