Unit 24: Dynamic Table (New Feature)

Why use an Excel table?

An Excel Table offers a range of features which can make it easier to work with your data. These include

− Filtering (via Auto filter and Slicers)
− Quick Formatting options
− Structured formulas
− Dynamic charts


Convert a standard data range to a table

  1. 1. Click a cell in your data range (if there are no gaps in your data) or select the data range you want to convert (if your data contains gaps).

  2.  Press [Ctrl] + T or click Insert > Table.

  3.  Confirm the range of cells in the Create Table dialog box and click OK.

Note: check that the My table had headers checkbox is ticked.


Format a table

  1. Click Table Tools > Design on the Ribbon.

  2.  Choose a style from the Table Styles gallery.

  3. Select any options for table style, Banded Rows or Columns from the Table Style Options section.


Add rows to the table

  1. Move to the last cell of the table and press the [Tab] key OR

  2.  Click and drag the marker in the bottom right corner of the last cell downwards. Add columns to the table. After the last column of the table:

− Type a new heading to the right of the last column of your table. Within the table:

− Right-click a cell in the column to the right of where you want the new column to appear.

− Choose Insert > Table Columns to the Left.

Delete rows or columns

  1. Right-click a cell in the row or column.

  2.  Choose Delete > Table Columns or Table Rows.

UNIT 24 – Dynamic Table (New Feature)


There aren't any posts currently published in this category.