How to change the filters and formatting

Open the QXL Sample spreadsheet.

In this example, We will change the filter of the Balance column by clicking on the filter icon on the Balance column.

We will use a number filter to show records whose balance is greater than or equal to 5000. To do this, we need to click on Number Filter & Greater Than Or Equal To.

Write the filter amount to 5000 & click OK.

A customer with a Balance of 5000 & more is showing in the spreadsheet. In the same way, you can apply another filter as per your requirement.

Also, refer to the Guidelines and examples for sorting and filtering data by color for more details.