Without freezing rows or columns in yourExcelspreadsheet, everything moves when you scroll through the page, as shown in the gif below.
如果您不能总是看到解释什么是什么数据的关键数据标记,例如列标题或行标题,这可能会令人沮丧。
As with many things on Excel, there are tricks that help you make your spreadsheets easier to read, like the freeze function. In this post, learn how to freeze rows and columns in Excel to ensure that, when you scroll around, you’ll always be able to view the key data points that matter most.
如何冻结Top Row in Excel
The image below is the sample data set I’ll use to run through the explanations in this piece.
1. To freeze the top row in an Excel spreadsheet, navigate to the header toolbar and select看法, as shown in the image below.2.当看法menu options appear, ClickFreeze Top Row, outlined in red in the image below.
Once selected, everything in the top row of your Excel spreadsheet (row 1) will be frozen, and you can scroll up and down in your spreadsheet, but the top rows won’t move, as shown in the gif below.
如何冻结Specific Row in Excel
While excel has native functions for freezing the top row of a data set and the first column of a data set, there are additional steps to take to freeze other elements of your data set that aren’t those two things.
1. To freeze a specific row in Excel, select the row number immediately underneath the one you want frozen. For this example, I’m selecting row number three to freeze row number two.
2.选择行后,导航到看法in the header toolbar and select Freeze Panes.
Once selected, you’ll be able to scroll up and down through your spreadsheet and always see row two.
请注意,使用Freeze Panes函数冻结行还会冻结您最初选择的行上方的每一行。例如,在下面的GIF中,我选择了第五行,该行还冻结了第四行,三,两个和一行。
How to Freeze the First Column in Excel
1. To freeze the first column of your Excel spreadsheet (column A), navigate to the Excel header toolbar, select看法, and clickFreeze First Column.
Once selected, you’ll be able to scroll side to side within your sheet, and the first column of your data set will always be visible, as shown in the image below.
如何冻结Specific Column in Excel
1. If you want to freeze a specific column in excel, select the column letter that is immediately next to the column you want frozen and click冷冻窗格in the看法header menu.
Once selected, you can scroll side to side through your entire data set and continue to see those columns. In the gif below, I’ve frozen columns A and B.
在Excel中使用Freeze功能使您的电子表格更易于理解,因为您可以在滚动数据滚动时确保始终可见关键的行和列。
Originally published Jan 21, 2022 7:00:00 AM, updated January 21 2022
Topics:
Excel别忘了分享这篇文章!
相关文章
Expand Offer
社交媒体内容日历模板
Get it now