Create a Calculated Column in Excel

How to Create a Calculated Column in Excel

One of the most beautiful things about Microsoft Excel is the ability to automatically perform calculation on data in tables. You can create a calculated column that uses a single formula that adjusts for each row, i.e. as you enter more data in the succeeding rows, the formula automatically extends to them without you having to enter the formula over and over again. You only need to enter a formula only once and don't need to use the Fill or Copy command. NOTE that this will only work in an Excel table not on range of data. To learn how to create a Table in Excel, read my earlier post on Creating Tables in Excel. Take the following steps to create Calculated Column:

1. Click a cell in a blank table column that you want to turn into a calculated column.
2. Type the formula that you want to use.
3. The formula that you typed is automatically filled into all cells of the column — above as well as below the active cell.

Insert a Table Row or Column

Select the Table and do one of the following:

• To insert one or more table rows, select one or more table rows above which you want to insert one or more blank table rows.
• If you select the last row, you can also insert a row above or below the selected row.
• To insert one or more table columns, select one or more table columns to the left of which you want to insert one or more blank table columns.
• If you select the last column, you can also insert a column to the left or to the right of the selected column.

1. On the Home tab, in the Cells group, click the arrow next to Insert.
2. Do one of the following:
   • To insert table rows, click Insert Table Rows Above.
   • To insert a table row below the last row, click Insert Table Row Below.
   • To insert table columns, click Insert Table Columns to the Left.
   • To insert a table column to the right of the last column, click Insert Table Column to the Right.
3. You can also right-click one or more table rows or table columns, point to Insert on the shortcut menu, and then select what you want to do from the list of options.

Delete Rows or Columns in a Table

1. Select one or more table rows or table columns that you want to delete.
2. On the Home tab, in the Cells group, click the arrow next to Delete, and then click Delete Table Rows or Delete Table Columns.

Delete a Row or Column

1. To delete a row or column, select the row or column you want to delete.
2. On the Home tab, in the Cells group, click Delete or press DELETE key on the keyboard.

Convert a Table to a Range of Data

1. Click anywhere in the table. This displays the Table Tools, adding the Design tab.
2. On the Design tab, in the Tools group, click Convert to Range.

You can also right-click the table, point to Table, and then click Convert to Range.

Delete a Table

1. On a worksheet, select a table.
2. Press DELETE on the keyboard.