How to copy rows from another spreadsh without copying of hidden r

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How to copy rows from another spreadsheet without copying of hidden rows?
 
Ruslan,
Hit CRTL + A to select all cells. Or select your range

Edit, Go To, Special, Visible cells only, OK

Copy and paste to new sheet.
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 2003
** remove news from my email address to reply by email **
 
On your toolbar go to "Add or Remove Buttons", then click
on "Customize". From there, click on the "Commands" tab.
Go go Customize Toolbar to display a new icon. Then
select "Edit" from the menu, scroll down and add "Select
Visible Cells" to your toolbar.

Now, highlight the range you want to copy, and click on
the "Select Visible Cells" icon. Now use the copy and
paste function. This will only copy the visible cells.

Jeff
 
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

how do i copy/paste in excel without pasting hidden lines 1
Copy/Paste with Hidden Rows/Columns Excel 2007 3
copying one column with hidden/filtered rows to another colum 2
Merging over hidden rows 1
Excel Help to copy information from one row at a time to another sheet 1
Hidden rows; can't unhide them 1
Copy and Paste with hidden columns remaining hidden 2
How do I avoid copying data from hidden rows/columns? 2

Back
Top