HomeApplicationOffice information

MS Excel 2007 - Lesson 8: Sort and Filter

TipsMake.com - Sort and Filter are features that allow you to manipulate data in a spreadsheet based on standards. To sort data and filter data in Excel 2007 you will use the Sort & Filter feature. Below TipsMake.com will guide you how to filter data, arrange data with this feature in Excel 2007.

Sort data in Excel 2007

To make a sort in ascending or descending order on a column:

• Highlight to select the cells in the column to be sorted

• Click the Sort & Filter button on the Home tab

• Click the Sort Ascending (AZ) or Sort Descending button (ZA)

MS Excel 2007 - Lesson 8: Sort and Filter Picture 1

Customize data arrangement

To sort more than one column:

• Click the Sort & Filter button on the Home tab

• Select the column you want to sort first

• Click Add Level

• Select the next column you want to sort

• Click OK

MS Excel 2007 - Lesson 8: Sort and Filter Picture 2

Create data filters on Excel 2007

Filters allow you to display only data that meets certain standards. To use filters:

• Click on the column or select the columns containing the data you want to filter

• On the Home tab, click Sort & Filter

• Click the Filter button

• Click the arrow below the first cell

• Click Text Filter

• When the first cell on the selected column has an arrow pointing down, simply click on it and select the fields you want to display on the worksheet and click OK .

MS Excel 2007 - Lesson 8: Sort and Filter Picture 3

• To not apply a filter, click the Sort & Filter button

• Click Clear

MS Excel 2007 - Lesson 8: Sort and Filter Picture 4

Next lesson: MS Excel 2007 - Lesson 9: Graphics

Previous article: MS Excel 2007 - Lesson 7: Creating Macros in Excel 2007

3.5 ★ | 2 Vote
excel data filteringexcel 2007 data filteringmicrosoft excellearn excellearn excel 2007 excel guide 2007

You should read it

May be interested

  • Data filtering (Data Filter) in ExcelData filtering (Data Filter) in Excel
    instructions on how to filter data in excel. 1. simple data filtering 1 condition. step 1: select the data you want to filter - data - filter - the data column appears arrow containing the options: step 2: if you want to filter by a certain value, do the following: uncheck select a
  • How to Sort Excel Columns AlphabeticallyHow to Sort Excel Columns Alphabetically
    microsoft excel is a great tool for organizing data. this article will introduce to you a simple but extremely useful feature, which is sorting data in alphabetical order.
  • How to reverse data in columns on ExcelHow to reverse data in columns on Excel
    in order to reverse the order of data in excel, in a column or row can use the available data sorting tool.
  • MS Excel 2007 - Lesson 7: Create Macros in Excel 2007MS Excel 2007 - Lesson 7: Create Macros in Excel 2007
    macros are advanced features, which can speed up editing or formatting that you can do regularly in an excel spreadsheet. in this excel lesson, tipsmake.com will show you how to use macros in excel 2007.
  • Advanced data filtering in ExcelAdvanced data filtering in Excel
    instructions on how to filter advanced data in excel. data filter (automatic data filtering) allows you to filter data only on a single column or data field -> so it is limited when using data. excel supports the advanced filter feature that allows you to filter
  • Filter data in Excel with Advanced FilterFilter data in Excel with Advanced Filter
    in the process of working with data tables in excel, the filtering of data in the data tables is very necessary and often done. there are many ways to filter and functions to help you filter data in data tables.
  • How to filter data in ExcelHow to filter data in Excel
    your excel spreadsheet has a lot of data, so it's easy to process and search the data in your table. filter data by conditions, criteria you give, you will shorten the search time and data processing
  • How to Sort Microsoft Excel Columns AlphabeticallyHow to Sort Microsoft Excel Columns Alphabetically
    microsoft excel is a great tool for organizing your information. here's a guide to a basic but extremely useful function, sorting your data alphabetically. format the header row. the header row is the top row of your spreadsheet, with the...
  • Filter PivotTable report data in ExcelFilter PivotTable report data in Excel
    teach you how to filter pivottable reports data in excel 2013 accurately and quickly. the original pivottable report created on demand helps you see the entire information of the data. in case you want to statistically follow a field
  • How to filter duplicate data from 2 Sheets in ExcelHow to filter duplicate data from 2 Sheets in Excel
    how to filter duplicate data from 2 sheets in excel. in excel file, you have data in 2 different sheets but you want to filter duplicate data with a large number of records. here's how to use the vlookup function to filter duplicate data from 2 sheets in exc

Office information