Monday, July 25, 2011

How to Create a Table in Excel 2003


1. Open Excel on your computer, and start a new spreadsheet.
2. Enter your data into the spreadsheet. If the table is to be row-oriented, enter the desired calculation formulas to the left and just below the data. If the table is column-oriented, enter the calculation formulas above the first value and in the column immediately to the right of the data. Assistance for understanding formulas is available in the Excel 'Help' section.
3. Go to the 'Data' tab, and select 'Table.'
4. Enter the cell number where the calculated data should appear in the 'Column input cell' field or 'Row input cell' field, depending on the orientation of your table. Click 'OK.'

Blogger news