AutoFilter

AutoFilter

The column headings in bold italics and centered. Furthermore, it should find a suitable column width. But all this does not affect the logic, but only improves the appearance of the table. You can choose what format, what you like. To automate the processing of journal use AutoFilter. Click on any cell in the list, then select the menu command Data – Filter – AutoFilter. On the right side of each cell header button appears with an arrow. Clicking this button opens a list with the values on which you can filter the log.

For example, click the arrow in the column, Debit, and will open a list of accounts. Select the desired account, and the list remain the only operations with the use of this account is debited. To re-show all the transactions should again click the arrow in the column Debit and choose the All pop-up list. You can choose simultaneously filter on multiple values, such as the debit one account and credit of another. Similarly, you can choose to select the operation with the correct dates or amounts. You can specify more complex conditions for filtering, by selecting the opening list condition. This will display a dialog where you can set any condition, such as transaction amount must be greater than 100 and less than 1000 or the date of more than 1 January of the year. After selected only the desired entries, you can find out the amount of numbers in a column sum.

Comments are closed.