CHAPTER 3:
HancomMobileSheet
57
are added to the top cells according to each selection. With column auto
filters, a column title table is created as in the left image below, with data on
the bottom.
•
Select in Automatic Filter
You will see the image below after selecting Singapore from the list. The
arrow in the field where a list has been selected is displayed in blue. Products
within the Singapore category include machines and electronics. To extract
only the electronics data, press the product column arrow and select
'electronics' in the list. As such, you can select one list to each in multiple
fields.
•
New Sheet
In order to create an auto filter in a new sheet, the filtered results are linked
to the original data. Therefore the filtered results will change when the original
data values are changed.
•
Cancel
To display the hidden contents without cancelling the filter, press the blue
arrow and select "Show All". If several columns are selected then the same
should be done in each field. Following are steps to cancel the auto filter
completely. Select [Tools-Automatic Filter] on the sheet containing the
filtered results. Select the menu, uncheck the "Check Mark", and then the
"Filter" will be cancelled. When the auto filter is created in the same location
as the original range, the original data will be displayed. In creating a filter on
a new sheet, only the selected contents will remain when cancelled. The
formula will disappear and only the cell values will remain.
To Next Page
Loading...
Need help?
General
