Part I: Getting Started with Excel
Deleting comments
To delete a cell comment, activate the cell that contains the comment and then choose
Review ➪ Comments ➪ Delete. Or right-click and then choose Delete Comment from the
shortcut menu.
Working with Tables
A table is a specially designated area of a worksheet. When you designate a range as a table,
Excel gives it special properties that make certain operations easier and that help prevent
errors.
The purpose of a table is to enforce some structure around your data. If you’re familiar with
a table in a database (like Microsoft Access), then you already understand the concept of
structured data. If not, don’t worry. It’s not difficult.
In a table, each row contains information about a single entity. In a table that holds
employee information, each row will contain information about one employee (such as
name, department, and hire date). Each column contains the same piece of information for
each employee. The same column that holds the hire date for the first employee holds the
hire date for all the other employees.
Understanding a table’s structure
Figure 4.19 shows a simple table. The various components of a table are described in the
following sections.
FIGURE 4.19
The areas that make up a table
Header row
Banded rows
Sort and filter control
Total row
This workbook, named EmployeeTable.xlsx, is available on this book’s website at http://www.wiley
.com/go/excel2019bible.
