Exclude Hidden Rows When Copying

[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

 

[Debra Dalgleish]

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

 

[J. P. Sheehan]

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 .