Page 133 - Ms Excel Note and Workbook
P. 133

MICROSOFT EXCEL NOTE AND WORKBOOK


               6.  Uncheck the box next to Select All to quickly deselect all data.


























               7.  Check the boxes next to the data you want to filter, then click OK. In this example, we
                   will check Laptop and Projector to view only these types of equipment.





















                                                                                     TIP
                                                                             Filtering options can also
                                                                             be accessed from the Sort
                                                                             & Filter command on the
                                                                             Home tab.

               8.  The data will be filtered, temporarily hiding any content that doesn't match the criteria.
                   In our example, only laptops and projectors are visible.






















                                                                                              124 | P a g e
   128   129   130   131   132   133   134   135   136   137   138