{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

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 Document Right 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 Document Right 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 Document Right 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 Document Right 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

{[ snackBarMessage ]}