How to Extract Data Onto a Table Using Excel 2007

Create a Table
1. Open the spreadsheet and highlight the data you want to put into a table.
2. On the 'Insert' tab, click 'Table.' If you want to include the headers in your data, choose the box next to 'My Table Has Headers.' Click 'OK.'
3. Your data will appear as a table. If you've excluded any data, it will still appear. If this isn't what you had in mind, try creating the table again, this time including all your data. Then, when your table is created, choose in the next step to exclude and hide any additional data.
4. Format the table by using the drop-down boxes that appear next to the headers or in the 'Table Tools Design' tab, which appears at the top of the screen when you make a table. Here you can change the color of the table, sort the data and choose to exclude data.
Convert Table Data Back to a Range of Data
5. If you decide to revert back to a range of data, select a cell in your table.
6. Click on the 'Design' tab, then choose 'Convert to Range.' This action removes the table but leaves the data and color formatting intact. The 'Design' tab will disappear.
7. Your data is now in a simple Excel format. You can manipulate it as you would a traditional spreadsheet.