Saturday, February 19, 2011

How to Insert Information in an Excel Spreadsheet


Direct Data Entry
1. Launch Microsoft Excel 2010.
2. Click in one of the cells of the spreadsheet and type a number or word, and then press 'Enter.'
3. Type another number or word and press 'Enter' again to continue to fill in the current column. Alternately move to a different cell by clicking the mouse on that cell or by using the 'Tab' key or one of the arrows on the keyboard to navigate to a different cell.
Link to Existing Data
4. Launch Microsoft Excel 2010. Open the spreadsheet that contains the cells where data from other spreadsheets will be displayed.
5. Open the Excel spreadsheet that contains data that will be used in a new spreadsheet.
6. Switch back to the spreadsheet that will display the data and click on the cell that will display the data. Press the 'Equal' sign ('=') on the keyboard. Switch to the spreadsheet that contains the data and click once on the cell that contains the data and press 'Enter.' Notice that the display spreadsheet now displays the data from the other spreadsheet.
Import Data
7. Launch Microsoft Excel and open the spreadsheet that will contain the imported data.
8. Click on the cell where the imported data will be displayed.
9. Click the 'Data' tab on the toolbar and click the appropriate button in the 'Get External Data' group to launch the 'Open File' or 'Data Connection' dialog.
10. Locate the source data file or location and click 'OK' to connect to the new data source. Specify additional options depending upon the type of connection made and the amount of data being used.

Blogger news