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

H

helplinda

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.
 
G

gatwickxx

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
 
D

Debra Dalgleish

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
 
Top