Knowledgebase
[QXL-ALL] How to change the filters and formatting
Posted by Rajendra Dewani (QODBC Support) on 08 July 2016 10:02 AM
|
|
How to change the filters and formattingOpen 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. | |
|
Comments (0)