56
CHAPTER 3:
HancomMobileSheet
Sort
Allows you to sequence information alphabetical or numerically in either
ascending or descending order.
•
Ascending
This is used when the order of the values are set from lower to higher. This
order is set in different ways according to the numbers, letters, date, etc. and
the standard for the "Ascending Order" is as the following.
①
Numbers are aligned to increasing order, starting from the lowest to highest.
②
Date and time are aligned from earlier to later.
③
Letters are aligned alphabetically from A to Z.
④
Cases whereby numbers and letters appear together are arranged in
numeric-alphabetical order.
⑤
When there is a blank cell within the aligned area, all blank cells will be placed
at the very end. This applies to the Descending Alignment as well.
•
Descending
Descending Alignment follows the opposite standards of Ascending Alignment.
Automatic Filter
This provides the ability to select only desired information among the various
data on the sheet. However, note that HancomMobileSheet only supports the
column auto filters. Data extraction using the condition formulas used in
previous spreadsheets will be implemented in the advanced filter.
•
Filter
When the filter command is run
HancomMobileSheet will ask whether
the filtered results will be created on a
new sheet or if the present data range
is to be created.
The database range will be automatically set to the consecutive range of data
where the cursor is located(in the selected cell). An auto filter created in a
new sheet will be linked to the original data, automatically changing according
to changes in the original data. When the auto filter is created, arrow buttons
To Next Page
Loading...
Need help?
General
