Exclude Hidden Rows When Copying

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

I am trying to copy a long line of rows, some of which
are hidden. I want to exclude the hidden rows from the
function. How do I do this?

Thanks,
Mike
 
1. Select the cells that you want to copy
2. Choose Edit>Go To, click Special
3. Select 'Visible cells only', click OK
4. Choose Edit>Copy
5. Select a destination cell, and choose Edit>Paste
 
From the Excel Help, Copy visible cells:

1. Select the cells you want to copy.
2. On the Edit menu, click Go To.
3. Click Special.
4. Click Visible cells only, and then click OK.
5. Click Copy .
6. Select the upper-left cell of the paste area.
7. Click Paste .
 
Back
Top