Page 41 - Touchpad_Plus_V3.2_Class 7
P. 41

Standard Filter can also be easily removed. Perform the following steps to remove the Standard     Date:  This option is used when the data consists of multiple dates. For this example,
 Filter:                      we will use the Condition option.

 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   Using Conditional Formatting

 is known as Conditional Formatting in Calc.
                 Step 4  Click on the Condition option.
 Perform the following steps to apply conditional formatting to a series of data:
                 Step 5  Click on the Greater than option. The Apply conditional formatting dialog box will
 Step 1  Select the range  of data to which the
                          open.
 formatting should be applied.
                 Step 6  In the Apply conditional formatting dialog box, type 2 in the value box and choose
 Step 2  Click on the Format menu.  Accent 3 for the formatting style.

 Step 3  Click on the Conditional option to open
                 Step 7  Click the OK button.
 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
                      Apply conditional formatting dialog box             Conditional Formatting applied
 click on this option, a dialog box opens showing different types and colors of bars
 that can be added to the cells.  The  selected  conditional  formatting  is  applied  to  the  selected  cell  range.  You  can  also
   Icon Sets: This option adds icon sets to visually indicate which cells are acceptable,   define your own rule for highlighting cells by selecting Manage option from the Conditional
 moderate, or need attention. The dialog box that opens shows various icon sets that   submenu.
 can be applied to the cells.


                                                                                                  More on Calc       39
   36   37   38   39   40   41   42   43   44   45   46