Nikko [Sorting and Filtering a Table, Converting a Table back to a Range]

Nikko [Sorting and Filtering a Table, Converting a Table back to a Range]

Info iconThis preview shows pages 1–9. Sign up to view the full content.

View Full Document Right Arrow Icon
SORTING AND FILTERING A TABLE Sorting a table refers to arranging the rows based on the contents of a particular column. Filtering a table refers to displaying only the rows that meet certain conditions.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
STEPS IN SORTING A TABLE 1) Click the drop-down in the column header.
Background image of page 2
STEPS IN SORTING A TABLE 2) Choose a sort command
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
STEPS IN SORTING A TABLE Home – Editing – Sort & Filter – Custom Sort
Background image of page 4
STEPS IN SORTING A TABLE
Background image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 6
Background image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 8
Background image of page 9
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Home Editing Sort & Filter Custom Sort STEPS IN FILTERING A TABLE 1) Click the drop-down in the column header. STEPS IN FILTERING A TABLE 2) Remove check mark from Select All. STEPS IN FILTERING A TABLE 3) Place a check mark next to your desired filtering option. CONVERTING A TABLE TO A RANGE Table Tools Design Tools Convert to Range...
View Full Document

This note was uploaded on 12/16/2011 for the course ACCOUNTANC 506 taught by Professor Mr.reyes during the Spring '11 term at University of the Philippines Diliman.

Page1 / 9

Nikko [Sorting and Filtering a Table, Converting a Table back to a Range]

This preview shows document pages 1 - 9. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online