Excel文件的数据过滤 [英] Data Filtering for excel file

问题描述

嗨 我在MicroSoft Office 2007中有一个Excel工作簿，其中有许多数据行，并且我尝试过滤此列，但是我的标题行从第3行开始，但是当我尝试默认情况下在excel中主动过滤时
过滤从第1行的单元格开始
当我过滤默认情况下从第3行开始过滤时，我如何拥有工作簿
tnx

Hi I have an excel workbook in MicroSoft Office 2007 with many data rows and i trying to filter this columns but my header row start in rows 3 but when i try to active filtering in excel by default
filtering start from cells on row 1
how can i have workbook when i filter that filtering start from rows 3 by default
tnx

推荐答案

如果您谈论的是Excel application的AutoFilter ，那么我认为有两种选择.

If you are talking about the AutoFilter of Excel application then I think there are two options.

1. 在第3行上方插入blank row .然后单击第3行上方或下方的单元格，然后从数据"菜单应用AutoFilter .
2. 选择Range from Row3 包括所有要过滤的Rows and Columns ，然后从数据"菜单应用AutoFilter .

1. Insert a blank row above Row 3. Then click in a cell on or below Row No. 3 and apply AutoFilter from the Data menu.
2. Select the Range from Row3 to include all the Rows and Columns to be filtered and then apply AutoFilter from the Data menu.

如果标题行是单行(不是合并的行) )，请选择该行中的所有列，然后添加一个过滤器.

If header row is a single row (not merged rows), select all columns in this row and than add a filter.

这篇关于Excel文件的数据过滤的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！