How to use Format as Table?

The presentation or the look of the spreadsheet is a very important factor to be considered. Using aesthetic colors and proper borders enrich the spreadsheet. Creating tables is one of the most popular methods of presenting data. In Excel there are a wide variety of options from which you could create good tables. But if You are in a hurry the best option you could use is the "Format as Table" option.


Format as table option is one of the most easiest ways of creating tables. The button can be found in the mid section of the ribbon under the Home tab.

When you click on the button a menu appears displaying a huge variety of colors that you can pick from, for creating a table.

When you select a particular color a dialog box appears. Select the range of cells on which you want the table to be formatted.

Now that you have your table created! Click anywhere on the table. A new tab called the Table tools will get highlighted on the ribbon.

You could change the style of the table by selecting from Table Styles menu.

The header row is used for classifying the columns, They come along with data filter. Un-check the Header Row if you do not need them.
You could include a row for totalling the values entered in the table. Now this Total Row option is truly versatile.You could carry out mathematical functions such as Sum, Average, Standard Deviation, Count ( Number of values entered in a column) Max (Maximum value in a column) Min (Minimum value in a column) so on.

Remove duplicates are used to remove repetitive values from a column.

Suppose you want to remove the Format Table link form the created table you could select "Convert to range". It will remove the data filter and the Format table link. This will turn out to be a simple table on range of cells.


Try other designs! Play with all the colors!