Page 40 - Touchpad_Plus_V3.2_Class 7
P. 40
Standard Filter can also be easily removed. Perform the following steps to remove the Standard
Filter:
Step 1 Click on the range of data, without headers, where the Standard Filter has been applied.
Step 2 Click on the Data menu.
Step 3 Click on the More Filters option.
Step 4 Click on the Reset Filter option.
The hidden rows will reappear.
Clickipedia
The filter can also be applied through AutoFilter tool on Standard toolbar.
If Calc was a magical library, how would you sort books and filter books you
had read?
CONDITIONAL FORMATTING
Suppose you do not want to hide any rows but still want to highlight all the cells that satisfy a
condition, for example, employees having more than 2 years of experience. This type of formatting
is known as Conditional Formatting in Calc.
Perform the following steps to apply conditional formatting to a series of data:
Step 1 Select the range of data to which the
formatting should be applied.
Step 2 Click on the Format menu.
Step 3 Click on the Conditional option to open
a submenu. This submenu shows various
criteria, such as:
Condition: This option works similarly to the Standard Filter. The difference is that
rows that do not satisfy the condition are not hidden; instead, the cells that meet the
condition are formatted (e.g., in bold).
Colour Scale: This option applies a color gradient across all selected cells, with
colors varying from top to bottom. When you click this option, a dialog box opens
displaying various color gradients you can apply.
Data Bars: This option adds data bars to cells containing numeric data. When you
click on this option, a dialog box opens showing different types and colors of bars
that can be added to the cells.
Icon Sets: This option adds icon sets to visually indicate which cells are acceptable,
moderate, or need attention. The dialog box that opens shows various icon sets that
can be applied to the cells.
38 Plus (Ver. 3.2)-VII

