Go to the FGCU Homepage navigation bar
    
Technology Skills Orientation
Excel
A-Z FGCU Index FGCU Calendar of Events Campus Tour Library Search FGCU Web FGCU Webmail Contact FGCU
« Macros Sort and Filter Graphics »

Sorting and Filtering allow you to manipulate data in a worksheet based on given set of criteria.

Basic Sorts
To execute a basic descending or ascending sort based on one column:

  • Highlight the cells that will be sorted
  • Click the Sort & Filter button on the Home tab
  • Click the Sort Ascending (A-Z) button or Sort Descending (Z-A) button

Sort and Filter Drop Down Menu

Custom Sorts
To sort on the basis of more than one column:

  • Click the Sort & Filter button on the Home tab
  • Choose which column you want to sort by first
  • Click Add Level
  • Choose the next column you want to sort
  • Click OK

Custom Sort Dialog Box

Filtering
Filtering allows you to display only data that meets certain criteria. To filter:

  • Click the column or columns that contain the data you wish to filter
  • On the Home tab, click on Sort & Filter
  • Click  Filter button
  • Click the Arrow at the bottom of the first cell
  • Click the Text Filter
  • Click the Words you wish to Filter

Filter Dialog Box

  • To clear the filter click the Sort & Filter button
  • Click Clear

Clear Filter Drop Down

« Macros Sort and Filter Graphics »


Office 2007 Tutorials · Word · Excel · PowerPoint · Access

FGCU does not provide personal support for Office 2007 programs to outside parties.


© FGCU 2007. This is an official FGCU web page.
Florida Gulf Coast University is an equal opportunity/affirmative action institution.

Contact the Webmaster | FGCU Directory