pasting ranges, but not with hidden columns or rows.

  • Thread starter Thread starter Tim
  • Start date Start date
T

Tim

Hi Am wondering if there is a way of copying and pasting a worksheet, but
without pasting the hidden cells or groups.

Thanks Tim
 
Select your range
Edit|goto|special|visible cells only
Edit|copy
to the other worksheet
edit|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
MACRO PASTE CELL to COLUMN, SKIP ROWS 1
Copy and Paste with hidden columns remaining hidden 2
Pasting current view 1
copy and paste range of cells excluding hidden data in excel 3
Not include hidden columns in copy paste 2
Copy and paste - filtered data 2
copying one column with hidden/filtered rows to another colum 2

Back
Top