How to copy information from Excel to another Excel document without copying the hidden cells/rows:
Office 2007 and above:
1. Highlight the information that you want to
2. Go to the Home tab and choose Find and Select (look for the binoculars). From the menu that comes up, choose "Go To Special".
A box will pop up on which you can select "Visible Cells Only".
3. Select Edit Copy (or Ctrl-C) to copy the highlighted information
4. Paste the information into the destination document or spreadsheet. Only the visible cells will be copied.