Microsoft Office Tutorials and References
In Depth Information
Converting a table back to a range
FIGURE 19.10
Specifying a more complex numeric fi filter
In addition, you can right-click a cell and use the Filter command on the shortcut menu.
This menu item leads to several additional fi ltering options.
As you may expect, when you use i ltering, the Total Row is updated to show the total only for the visible rows.
When you copy data from a fi filtered table, only the visible data is copied. In other words,
rows that are hidden by fi ltering don’t get copied. This fi ltering makes it very easy to copy
a subset of a larger table and paste it to another area of your worksheet. Keep in mind,
though, that the pasted data is not a table — it’s just a normal range. You can, however,
convert the copied range to a table.
To remove fi ltering for a column, click the drop-down in the Row Header and select Clear
Filter. If you’ve fi filtered using multiple columns, it may be faster to remove all fi filters by
choosing Home Editing Sort & Filter Clear.
Converting a table back to a range
If you need to convert a table back to a normal range, just select a cell in the table and
choose Table Tools Design Tools Convert to Range. The table style formatting remains
intact, but the range no longer functions as a table.
About Conditional Formatting
Conditional formatting enables you to apply cell formatting selectively and automatically,
based on the contents of the cells. For example, you can apply conditional formatting
in such a way that all negative values in a range have a light-yellow background color.
When you enter or change a value in the range, Excel examines the value and checks the
conditional formatting rules for the cell. If the value is negative, the background is shaded;
otherwise, no formatting is applied.
Search JabSto ::

Custom Search