Copy data without hidden rows/cols

[staticbob]

OK, this is a simple one and I must know the answer, just can't find it right now.

I have a massive spreadsheet, I have hidden some rows and columns and want to paste what I now have on screen to a new sheet, without all the hidden data

How ?

 

[Andrew Poulsom]

Select all the cells, choose Edit|Goto|Special, check Visible cells only and click OK. Then Copy|Paste.

 

[staticbob]

Thanks Andrew, should be on paste special really, I'll have a word with Bill when I see him next . .

 

[jpinchot]

What if you want to paste into cells in the same visible fields in the same spreadsheet. You could do this in Excel 2003.