How do I keep hidden columns and rows hidden when copying and pri.

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

Guest

I am trying to copy data from a spreadsheet to another and then merging it to
lables, but the hidden columns and rows become unhidden. I have this problem
when trying to print the spreadsheet, also.
 
Have you tried grouping the columns?

Mark each set of columns and do:
Data; Group and Outline; Group; Columns

This way the columns will remain grouped when you copy or prin
 
Select the cells that you want to copy
Choose Edit>Go to
Click the Special button
Select 'visible cells only'
Click OK

Choose Edit>Copy
Select the other worksheet
Choose 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

How do I avoid copying data from hidden rows/columns? 2
Copy/Paste with Hidden Rows/Columns Excel 2007 3
Copy and Paste with hidden columns remaining hidden 2
Merging over hidden rows 1
Cannot unhide the hidden rows in my spreadsheet 3
how do i copy/paste in excel without pasting hidden lines 1
How do I copy only the unhidden rows/colums? 2
Column Headings that are hidden 1

Back
Top