Worksheets

Tuesday, October 26, 2010

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!

13 comments:

  1. iot training in chennai - Best IOT Training Institute in Chennai will provide the course guidance for Internet of things.

    DevOps training in chennai - Best DeVops training Institute in Chennai provide the courses on DeVops. And also help you to get placement in DevOps technology.

    blue prism training in Chennai - Best Blue prism training in Chennai providing the courses and guidance on Blue prism.

    uipath training in Chennai - Best uipath course and training in Chennai.

    microsoft azure training in chennai - Best azure training in Chennai offering the courses with guidance for Microsoft azure training.

    ReplyDelete
  2. This comment has been removed by the author.

    ReplyDelete
  3. This comment has been removed by the author.

    ReplyDelete
  4. This comment has been removed by the author.

    ReplyDelete
  5. This comment has been removed by the author.

    ReplyDelete
  6. blue prism training in Chennai - If you choose to learn the blue prism or automation tool you are supposed to have the programming language. start to learn the blue prism training from the Best Blue prism Training Institute in Chennai.

    uipath training in Chennai - UI path technology is one of the fastest developing fields which has a lot of job opportunities such as software developer, Programmer and lot more. Join the Best Uipath Training Institute in Chennai.

    microsoft azure training in chennai -Microsoft azure technology is growing and soon it will be competitive aws. So students who start to learn Microsoft azure now will be well - paid in the future. Start to learn Microsoft azure training in Chennai.

    Chennai IT Training Center

    ReplyDelete
  7. blue prism training in Chennai - If you choose to learn the blue prism or automation tool you are supposed to have the programming language. start to learn the blue prism training from the Best Blue prism Training Institute in Chennai.

    uipath training in Chennai - UI path technology is one of the fastest developing fields which has a lot of job opportunities such as software developer, Programmer and lot more. Join the Best Uipath Training Institute in Chennai.

    microsoft azure training in chennai -Microsoft azure technology is growing and soon it will be competitive aws. So students who start to learn Microsoft azure now will be well - paid in the future. Start to learn Microsoft azure training in Chennai.

    Chennai IT Training Center

    ReplyDelete