Copy and Paste

G

Guest

I would like to copy from one spreadsheet that has hidden rows, and paste to
another without showing me the rows I had hidden.
 
R

Ron de Bruin

Hi Duncan

Select the range
F5>Special.. visible cells only
Ctrl-c
go to the other sheet
ctrl-v
 
F

Frank Kabel

Hi
- select your data
- hit F5, click 'Special' and choose 'Visible cells only'
- now copy and paste
 

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

Copy/Paste with Hidden Rows/Columns Excel 2007 3
paste special 3
copy a page with hidden rows and only paste what is showing 2
copy/paste with hidden rows don't want hidden parts to paste 1
Copy and Paste with hidden columns remaining hidden 2
copying one column with hidden/filtered rows to another colum 2
how do i copy/paste in excel without pasting hidden lines 1
Copy and paste - filtered data 2

Top