B01 Hide, Filter, and Sort Table Cells 2:17
prev < Numbers ’09 > next
1
00:00:01,434 --> 00:00:06,139
Hide, filter, and sort table cells
2
00:00:06,906 --> 00:00:10,276
You can simplify the way your
data appears on your spreadsheets
3
00:00:10,276 --> 00:00:13,646
by hiding, filtering and sorting table cells.
4
00:00:14,681 --> 00:00:18,118
To temporarily hide a row
without actually deleting it
5
00:00:18,118 --> 00:00:21,187
select the row and then choose "Hide Row"
6
00:00:21,187 --> 00:00:24,124
from the references tab pop up menu.
7
00:00:24,124 --> 00:00:26,760
To hide several rows, command+click them
8
00:00:28,194 --> 00:00:30,663
and then choose "Hide Selected Rows".
9
00:00:32,432 --> 00:00:34,234
You can see that rows are hidden
10
00:00:34,234 --> 00:00:37,904
by viewing the sequence in the row
numbers column on your table.
11
00:00:37,904 --> 00:00:40,740
The number range will jump
over the rows you have hidden.
12
00:00:42,242 --> 00:00:44,177
To view your hidden rows again
13
00:00:44,177 --> 00:00:48,448
open any row menu
and choose "Unhide All Rows".
14
00:00:50,784 --> 00:00:53,720
This same process also works for columns.
15
00:00:56,389 --> 00:00:58,391
Using filtering you can choose to show
16
00:00:58,391 --> 00:01:01,161
only rows that contain particular values.
17
00:01:01,161 --> 00:01:03,196
Lets isolate the items listed here
18
00:01:03,196 --> 00:01:06,766
to only the ones that will
cost over 500 dollars total.
19
00:01:06,766 --> 00:01:09,736
To do this first select the table,
20
00:01:09,736 --> 00:01:12,472
then click the "Reorganise" button in the toolbar.
21
00:01:14,240 --> 00:01:17,410
The "Reorganise" window will appear below.
22
00:01:17,410 --> 00:01:19,479
Click on the filter disclosure triangle
23
00:01:19,479 --> 00:01:22,849
and choose the column in the
pull down menu entitled "Total".
24
00:01:24,184 --> 00:01:27,520
In the next pull down menu
select "is greater than".
25
00:01:29,022 --> 00:01:31,691
And in the box next to it type
26
00:01:31,691 --> 00:01:33,560
the number 500 and then press enter.
27
00:01:34,727 --> 00:01:36,830
The filtered table is now shown with
28
00:01:36,830 --> 00:01:39,766
just the items that cost over 500 dollars.
29
00:01:39,766 --> 00:01:41,634
To return to the full table,
30
00:01:41,634 --> 00:01:43,937
press the "Reset" button.
31
00:01:43,937 --> 00:01:46,806
You can quickly sort the
information in your table as well.
32
00:01:47,607 --> 00:01:49,275
In the "Reorganise" window,
33
00:01:49,275 --> 00:01:51,678
click on the "Sort" disclosure triangle
34
00:01:51,678 --> 00:01:53,413
and then pull down the "Type".
35
00:01:55,115 --> 00:01:56,683
For more sorting options
36
00:01:56,683 --> 00:01:59,352
click the add button to add a sub sort value.
37
00:02:00,787 --> 00:02:04,591
Next choose "Yearly Savings"
and then "Descending".
38
00:02:06,860 --> 00:02:08,528
The table resorts again
39
00:02:08,528 --> 00:02:11,664
and we can quickly see the
highest cost savings items
40
00:02:11,664 --> 00:02:13,800
within each sorted group.
page revision: 4, last edited: 03 Oct 2009 22:03
Done.
MacTutorial Subtitles, Wik-iPad, HTML5 App, FreeSMUG