How to Extract Information From Cells in Excel 2003

1. Open your Excel 2003 workbook file.
2. Highlight the cells from which you want to extract data. You can do this by either placing the cell in one corner of the block you want to work with, holding the 'Shift' key down and using the arrow keys to expand the block; or you can click and drag across the block.
3. Click 'Edit' and 'Copy' using the top menu. You have now extracted a copy of all the data in the cells including formulas, formatting and values (the actual numerical values that show on your spreadsheet).
4. Navigate to where you want to place and review the extracted information. Click 'Edit' and 'Paste Special' from the top menu.
5. Choose 'Values' from the pop up box to paste the numerical values of the extracted cells. This choice will ignore the formulas that produce the values.
6. Choose 'Formulas' to copy the formulas for each cell. This will ignore the values of each cell, and produce new values when you insert new data into the cells that apply to the formulas.
7. Choose 'Formats' to copy shading, borders and other formatting features from cells and ignore the contents of the cells.