Create table Excel tutorial

This is a Microsoft Excel tutorial on how to create a table in Excel 2007 and 2010. Creating a table gives your data more than just new clear appearance. You get great tools like filters, sorting and autofill. Just follow these simple steps and learn how to use Excel tables.

Create a table - Format data as table

1. Select the cells you wish to transform into a table 

Tip: if you have a big area, just click on any cell that has content and then press ctrl + a simultaneously. This will select the whole data area and only the data area.
2.  Go to Home tab and from Style group click on Format as table.

Create table Excel tutorial




3. Select the color you like for your table and in the opening dialogue make sure the area is correct. Also see that the "my table has headings" is checked if you have column titles. Otherwise Excel will create a new row on top of your table for column titles.

Finally click OK or press enter and you have a table.

Modify table

Click on any cell in the table you want to modify, see the Table tools that appear in the top right of the ribbon and go to the Design tab. You can change colors and adjust the table area in here.

Create table Excel tutorial


Nifty new tools - Excel table tools


1. Sorting  - notice the down arrow next to each column title. Click it and select your sorting methods in the opening dialogue. After you have chosen a sorting method, you will see a new arrow symbol in the drop down box. 

2. Filters - notice the down arrow next to each column title. Click it and select your filters in the opening dialogue. After you have chosen a filter, you will see a new filter symbol in the drop down box. 

Create table Excel tutorial


You can remove the filters from the same dialogue.

Create table Excel tutorial


You can hide the sorting and filters drop down arrow from data tab, by clicking filters.

Create table Excel tutorial

3. Autofill - Create a function on top cell of any column and Excel will autofil the rest of the column. If you wish to prevent this from happening, click on the small icon next to the column and select stop autofill.

3 comments:

  1. Thanks for this great post, i find it very interesting and very well thought out and put together. I look forward to reading your work in the future. Microsoft Excel Training Courses Malaysia

    ReplyDelete
  2. Great thanks a lot, very informative post. keep posting. offline game

    ReplyDelete
  3. Thanks a lot , for this informative guide.
    BestVela

    ReplyDelete