excel冻结窗格参与排序_冻结窗格以在Excel中隐藏行

excel冻结窗格参与排序

冻结窗格以在Excel中隐藏行 (Freeze Panes to Hide Rows in Excel)

For the past 82 years (approximately), I've used Excel almost every day. Along the way, I've learned a few tricks, and produced some sophisticated workbooks. One of the joys of Excel is that there's always something new to learn. And this week I learned how to freeze panes to hide rows in Excel.

在过去的82年中(大约)，我几乎每天都使用Excel。 一路上，我学习了一些技巧，并制作了一些复杂的工作簿。 Excel的乐趣之一就是总有一些新东西要学习。 本周，我学习了如何冻结窗格以在Excel中隐藏行。

标题行过多 (Too Many Heading Rows)

This week, while working on a client's files, I wanted to review some calculations in a price list. The top 15 rows are headings for the printed sheet, then there's a