Microsoft Office Tutorials and References
In Depth Information
Sorting, Filtering, and Outlining Data
Figure 12-5 When we added a formula to cell D2, Excel automatically added a column to the
table and copied that formula to every cell in the column.
The new column includes a generic heading that you’ll probably want to replace with a
descriptive heading, and you might also want to insert a formula in the Total row, but Excel
does all the work of creating the calculated column.
If you look carefully at the formula bar in Figure 12-5, you’ll see that the formulas Excel
creates include some unusual cell references. These are called structured references, which
are designed to make it easy to automatically copy formulas as you add new rows. They’re
created automatically when you click to select cell references for use in a formula; you can
choose to use standard references instead by simply typing the cell address. Brackets
indicate a column heading name and an @ sign indicates the current row. The # sign is used
with one of four keywords to refer to specific parts of the table: #All, #Data, #Headers, or
#Totals.
Sorting, Filtering, and Outlining Data
In this section we discuss how to create order out of even the most chaotic worksheet data.
You can enter or import that data in any order or even at random. Once it’s arranged in
rows and columns, you can rearrange it as needed. You can sort by numbers, text, or dates.
You can also reduce clutter by filtering a list to show only data that matches conditions
you define. We also briefly discuss the old-school outlining options that survive in Excel for
compatibility reasons.
Search JabSto ::




Custom Search