Wednesday, November 16, 2011

How to Find Copy Results in Excel 2003


1. Open the Excel 2003 spreadsheet in which you want to locate and copy data.
2. Type 'Ctrl' 'F' on your keyboard to open the 'Find' dialog box. Alternatively, click the 'Edit' pull-down menu near the top of the spreadsheet and select 'Find' from the list.
3. Type the data you want to find in the 'Find What' box. You can enter numbers or letters or a combination. Use the 'Options' menu to select special features, such as enabling the 'Match case' option to distinguish uppercase and lowercase letters in your search.
4. Click 'Find Next' to locate the next appearance of your search term in the spreadsheet. Alternatively, click 'Find All' to generate a list of all appearances of your search term and click an item in the list to go to that location in the spreadsheet.
5. Type 'Ctrl' 'C' on your keyboard to copy the contents of the cell you are in. Alternatively, click 'Edit' to open the pull-down menu and click 'Copy.'
6. Move your cursor to another cell, a different spreadsheet or document in another program and type 'Ctrl' 'V' to paste the copied data into the new location.

Blogger news