how do i paste rows/columns avoiding hidden rows/columns

B

Billy Liddel

Two stages

Edit, Goto, Special, Current Region

Edit, Goto, Special, Visible

Then copy and paste asw normal.

Regards
Peter
 

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
Merging multiple columns into one column (dynamically) 1
Expand and Shrink Rows and columns to hide information. 1
Why do hidden columns/rows unhide automatically? 1
Copy and Paste with hidden columns remaining hidden 2
Rows into columns 7
Protect hidden rows/columns -macro help 4
counting blank cells within two columns 2

Top