Tuesday, August 27, 2013

How to Make Tables in Excel 2007


1. Launch Excel 2007 from your desktop. Type the information you would like to use as each column's 'header' in side-by-side cells within the same row.
2. Enter the data that you would like to be displayed in the rows directly under each of the 'headers' that you have typed out. Verify that you have entered the information correctly into the cells and that data is sorted as you would like it to be displayed in the table.
3. Click and drag your mouse over the cells that make up the table you are creating to highlight them. Click the 'Insert' tab towards the top of the Excel 2007 window. Click the icon labeled 'Table' that appears directly underneath the 'Insert' tab.
4. Click the empty box next to the text that reads 'My table has headers' in the window that opens and click 'OK' to continue. Excel 2007 will take the information that you have entered and create a table in the spreadsheet.

Blogger news