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
   35   36   37   38   39   40   41   42   43   44   45