CS 285 Lecture Notes - Lecture 5: Cell Press

• School: University of Alabama
• Department: Computer Science
• Course: CS 285
• Professor: All

Document Summary

Filter a table: click the filter arrow on the column wanted filtered, autofilter menu, click (select all) box to deselect all values, click value(s) wanted a filter on, click ok. Filter a pivotchart: click the desired filtering control, make selections on the autofilter menu, click ok. Filter pivottable fields: with the pivottable selected, go to the fields pane, cli(cid:272)k a(cid:374)d drag field (cid:271)utto(cid:374)s fro(cid:373) the (cid:862)choose fields to add to the report area(cid:863) to the. In the pivottable, click the field arrow to display menu: make selections, click ok. Delete a record from a table: click the row wanted to be deleted, go to the cells group on the home tab, click the delete arrow, cli(cid:272)k (cid:862)delete ta(cid:271)le rows(cid:863) I(cid:374) the editi(cid:374)g group, (cid:272)li(cid:272)k the (cid:862) ort & filter(cid:863) (cid:271)utto(cid:374: click the sort options you want to apply based on the column.