paste special

B

beana

how do you paste only shown rows on a spreadsheet to a new workbook? I have
hidden rows that I do not want to copy over. thanks!
i am working in office 2007
 
F

FrankWood

If the rows are hidden because of a filter, simply select the cells (not the
whole worksheet) by clicking and dragging.

Ctrl-C to copy the selected cells

Switch to the new Sheet and Paste.

Any “hidden†rows will not be pasted.

Hope that helps,

Frank
 
B

beana

Perfect, thanks!!

FrankWood said:
If the rows are hidden because of a filter, simply select the cells (not the
whole worksheet) by clicking and dragging.

Ctrl-C to copy the selected cells

Switch to the new Sheet and Paste.

Any “hidden†rows will not be pasted.

Hope that helps,

Frank
Click to expand...
 
Top