Microsoft Office Tutorials and References
In Depth Information
Limitations of using a table
➤ Activating any cell in the table gives you access to a new Table Tools context tab on the
Ribbon.
➤ You can quickly apply background color and text color formatting by choosing from a
gallery. This type of formatting is optional.
➤ Each column header contains a filter button that, when clicked, lets you easily sort the rows
or filter the data by hiding rows that don’t meet your criteria.
➤ A table can have “slicers,” which makes it easy for novices to quickly apply filters to a table.
➤ If you scroll down the sheet so that the header row disappears, the table headers replace the
column letters in the worksheet header. In other words, you don’t need to freeze the top row
to keep the column labels visible.
➤ If you create a chart from data in a table, the chart automatically expands if you add new
rows to the end of the table.
➤ If you create a name for a column in a table, the “refers to” range for the name adjusts as you
add new rows to the table.
➤ Tables support calculated columns. A single formula entered in a cell is automatically
propagated to all cells in the column (see Tip 75).
➤ Tables support structured references in formulas outside of the table. Rather than use cell
references, formulas can use table names and column headers.
➤ When you move your mouse pointer to the lower-right corner of the lower-right cell, you can
click and drag to extend the table’s size, either horizontally (add more columns) or vertically
(add more rows).
➤ Selecting rows and columns within the table is simplified.
Limitations of using a table
If a workbook contains at least one table, a few Excel features are not available:
➤ For some reason, when a workbook contains at least one table, Excel doesn’t allow you to
use the Custom Views feature (choose View Workbook Views Custom Views).
➤ You cannot share a workbook (using Review Changes Share) if the workbook contains a
table.
➤ You can’t insert automatic subtotals within a table (by choosing Data Outline Subtotal).
➤ You cannot use array formulas within a table.
Search JabSto ::




Custom Search