HOW TO CREATE TABLE IN EXCEL

HOW TO INSERT TABLE IN EXCEL

What is Excel Table?


All Later Version After Excel 2003, you can use the Table command to convert a list of data into a formatted Excel Table. Tables have many Advance Features.

Principle of a Good Table 

  • The list should have no blank Cell and no complete blank rows.
  • The list should have no two and more than two cell merging.
  • In the first rows of the table, each column should contain a short and unique Heading,
  • Each column  in the table should contain one type of data, Example "Date", "Rate", "Amount", "Text". 

How To Create Table In Excel 


1. Select your data that you prepared.
2. Click Insert Tab, On the Ribbon
3. Click Table Button, In the Tables Group ("Ctrl + T")

 
Insert Tab on the Ribbon

4. In the Create Table Dialog Box, Select your range Automatically, If not you can select it manually and Auto Check on " My table is Headers " to Create first row as a Header.

Create Table In Excel

5. Click Ok to Setting.

How to change Table name in Excel

When we create Table, an Excel Table is given default name, such as Table1, Table2 . . . !. You should change the meaning ful name such as SaleTable, Invertory, etc

  1. Select any cell in the table
  2. Click the Design Tab on The Ribbon
  3. Change Table name in the Properties Group
Change Table Name In Excel

Change Excel Tabel Style

When you create Excel Tabel on Table Command on the Ribbon's Insert Tab. The Tabel retains the default Table style is applied and any formatting that it currently has,

  1. Select any cell in the table
  2. Click the Design Tab on The Ribbon
  3. Click Quick styles on Table Styles Group
  4. Select Style on the list
Change Excel Table Style

Show Total Rows In Excel Tabel

After you create Excel Table. Its Very easy to show total Row To Sum, Count, Average, Max, Min... Builtin Table Tool

  1. Select any cell in the table
  2. Click the Design Tab on The Ribbon
  3. Check Total row in Table Style Options Group
Insert total Row In Excel

Watch Video For Easy Learning



EmoticonEmoticon