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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I can't copy and paste equations 0
Paste Special Values 2
Excel copy only visible rows from autofilter 2
Paste Special is extremely slow 1
Copy/Paste with Hidden Rows/Columns Excel 2007 3
Filter, Copy and Paste 2
Paste Special 3
COPY PASTE VALUES ONLY FROM/ON VISIBLE CELLS 6

Top