Copy and Paste

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
Hi Duncan

Select the range
F5>Special.. visible cells only
Ctrl-c
go to the other sheet
ctrl-v
 
Hi
- select your data
- hit F5, click 'Special' and choose 'Visible cells only'
- now copy and paste
 
You must log in or register to reply here.

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
Copy and Paste with hidden columns remaining hidden 2
paste special 3
how do i copy/paste in excel without pasting hidden lines 1
copy a page with hidden rows and only paste what is showing 2
Paste Special 3
copy and paste range of cells excluding hidden data in excel 3
copying one column with hidden/filtered rows to another colum 2

Back
Top