Lock specific rows or columns in place by freezing panes, so you can scroll through an excel spreadsheet and still see the top row or left column You can freeze just the top row and first column or multiple rows and columns. 冻结行或列 冻结窗格冻结上述行和所选单元格左侧的列。 冻结前两列 选择第三列。 选择 “ 视图 ”>“ 冻结窗格 ”>“ 冻结窗格 ”。 冻结列和行 选择在滚动时要保持其可见的行下方和列右侧的单元格。 选择 “ 视图 ”>“ 冻结窗格 ”>“ 冻结窗格 ”。 取消冻结行或列 在“ 视图 ”选项卡上. To keep an area of a datasheet visible in access while you scroll to another area, you can freeze one or more of the fields (columns) The fields that you freeze move to the leftmost position on the datasheet. Freeze columns and rows to keep them in view while you scroll through your data
Select the cell below the rows, and to the right of the columns you want to freeze. 凍結列或欄 [凍結窗格] 會凍結所選單元格上方的列和左邊的欄。 凍結前兩欄 選取第三欄。 選取 [檢視] > [凍結窗格] > [凍結窗格]。 凍結欄和列 選取您希望在捲動工作表時，能保持在畫面上的那些列下方，以及那些欄右側的儲存格。 選取 [檢視] > [凍結窗格] > [凍結窗格]。 取消凍結列或欄 在 [ 檢視. วิธีการตรึงแนวใน Excel เพื่อให้แถวหรือคอลัมน์ในเวิร์กชีตของ. To keep an area of the data model visible while you scroll to another area in the power pivot window, you can lock specific columns in one area by freezing them. 透過凍結窗格鎖定特定的列或欄，以在捲動 Excel 試算表時仍可看見頂端列或左側欄。 您可以選擇凍結第一列與第一欄，也可以選擇凍結多個列與欄。 Then, by selecting a row below row 4 and scrolling up, you no longer see rows 5 through 9
This brings a tight focus onto q4 and the ytd totals in columns g and h.
OPEN
