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.
It’s Black Friday week on WonderHowTo! Don’t miss out on all of the big sales in the Gadget Hacks and Null Byte shops. And if you’ve been wanting to take some classes without going into debt, check out our best deals on online courses for a variety of skill sets. Don’t miss out on these huge discounts: