Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 52 - 2505_CoreGPT(Podar)_Flipbook_C7
P. 52

    You will notice that only the details of the employees who are from the Sales department and
                      have more than 2 years of experience are displayed and the rest of the rows are hidden.

                      Remove Filters

                      The AutoFilter, once applied, can be easily removed. Perform the following steps to remove
                      AutoFilter:
                      Step 1  Select the range of data where the AutoFilter was applied in the worksheet.
                      Step 2  Click on Data menu.

                      Step 3  Click on the Filter option.
                      Step 4  Click on Hide AutoFilter option.
                      You will notice that the filter arrows in front of the column headers will disappear and any hidden
                      rows will reappear.

                      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.

                            USING VALIDITY

                      Validity is used to restrict users from entering specific values in a cell or range of cells. It helps
                      prevent incorrect data entries and ensures that the data entered in Calc is accurate.
                      For example, if you want to restrict entries in the Quantity column to only numbers between 1
                      and 30, you can apply Data Validation to prevent users from entering values outside this range.
                      To create data validity in Calc, follow the given steps:

                      Step 1  Select the cell or range of cells where you want to apply the data validity.
                      Step 2  Click on the Data menu from the Menu bar.
                      Step 3  Select the  Validity  option from the drop-down  menu. The  Validity  dialog box will

                               appear.

                     50     Premium Edition-VII

| 47 48 49 50 51 52 53 54 55 56 57 |