not copy hidden cells

T

Tester

Hi there,
Is there an option not to copy the hidden cells and their contents in
Excel 2003? For ex. when I select multiple contiguous cells, some are
hidden and get automatically copied when I do a copy and paste between
2 Excel documents.
Thank you, T
 
J

JoAnn Paules

Copy only the visible cells. Use Alt + ; to select all of the visible cells.
Copy and paste as usual. If you don't want all of the visible, just some,
hold the Alt key down while you select what you do want.
 
Top