How to copy information from Excel to another Excel document without copying the hidden cells/rows:
Procedures to copy information from Excel to another document
Copying and pasting information in the spreadsheets without copying the hidden cells/rows:
|
In Office 2003 you need to do this: 1. Highlight the information that you want to copy 2. Click on the Edit menu option and select GoTo. Click on the Special button and 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 |
|
|
If you are using Office 2007/2010/2013:
1. Highlight the information that you want to copy 2. Go to the Home tab and choose Find and Select (it's way over to the right...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. |
|
Office 2007 and above:
1. Highlight the information that you want to Copy
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.
|
|