How To: Create an Excel table in Excel 2007

Create an Excel table in Excel 2007

First, open the Excel worksheet you have previously created that you would like to create a table for. Click on any of the cell that contains data for your table. On the menu found on the upper portion of the application, go to the Insert Tab. Find and click Table. Your entire worksheet will now be selected. When a prompt window appears, click OK. Your table should now be created automatically.

Go to the Design tab to be able to change the design and color schemes of your table. Simply highlight the table and select your desired design or color scheme. You can also click on the arrow down button on the headers of your table to have more options such as sorting a certain column.

Type in a new name for your table under the Table Name and then you can now save your worksheet.

Want to master Microsoft Excel and take your work-from-home job prospects to the next level? Jump-start your career with our Premium A-to-Z Microsoft Excel Training Bundle from the new Gadget Hacks Shop and get lifetime access to more than 40 hours of Basic to Advanced instruction on functions, formula, tools, and more.

Buy Now (97% off) >

Our Best Phone Hacks

Gadget Hacks' tips — delivered daily.

Be the First to Comment

Share Your Thoughts

  • Hot
  • Latest