将标题行设置为工作表的第二行或第三行 [英] Setting header row to second or third rows of the sheet

问题描述

我有一个充满数据的excel工作表.我过去曾根据表头行(即工作表的第一行)中的值对数据进行排序.完成工作后，我想在其中添加文件的一些详细信息工作表的第一和第二列，以便我可以识别 文件的主题.我不希望它们出现在页眉/页脚"中，因为只有在打印时才可见.但是如果我在顶部再插入两行，则所谓的标题行"将变成第三行.能够像以前一样对数据进行排序或过滤 保留基于工作表第三行中的单元格值的排序/过滤器选项.

I have a excel sheet full of data.I used to sort the data based on values in the header row i.e., first row of the sheet.After finishing my work ,I want to  add some details of the file in the first and second column of the sheet,so that i could  identify the subject of the file.I don't want them in Header/Footer,since there are visible only when printed.But If I insert two more rows at the top, the so called header row becomes third row.Now, I am not able to sort or filter the data as before.Is there any way to keep sort/filter option based on cell values in the third row of the sheet.

推荐答案

您好-

谢谢你的帖子.您可以通过以下链接在Microsoft Office Excel/Access论坛中发布查询: http://social.technet.microsoft.com/Forums/en-US/exceles/threads

Thank you for the post. You can post your query in the Microsoft Office Excel / Access forum over the link : http://social.technet.microsoft.com/Forums/en-US/exceles/threads

希望有帮助.

感谢&问候

Ashawani

这篇关于将标题行设置为工作表的第二行或第三行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！