Lock rows and columns in Excel

本文介绍如何通过拆分或冻结窗格来锁定电子表格中的行和列。拆分窗格允许用户在滚动其他部分的同时保持选定区域可见;冻结窗格则固定特定行或列,确保即使在滚动工作表时它们仍保持可见。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

You can view two areas of a worksheet and lock rows or columns in one area by splitting or freezing panes (pane: A portion of the document window bounded by and separated from other portions by vertical or horizontal bars.). When you split panes, you'll be able to scroll in both areas of the worksheet, while rows or columns in the non-scrolled area remain visible.

When you freeze panes, you select specific rows or columns that remain visible when scrolling in the worksheet. For example, you would freeze panes to keep row and column labels visible as you scroll, as shown in the following picture.

Worksheet window with row 1 frozen

HideLock rows and columns by splitting panes

  1. To lock rows, select the row below where you want the split to appear.

    To lock columns, select the column to the right of where you want the split to appear.

    To lock both rows and columns, click the cell below and to the right of where you want the split to appear.

  2. On the Window menu, click Split.
  3. To remove the split, click Remove Split on the Window menu.

ShowTip

For a quick way to split panes, point to the split box at the top of the vertical scroll bar or at the right end of the horizontal scroll bar.

Split box

When the pointer changes to a split pointer Split pointer or Resize pointer (double-headed arrow), drag the split box down or to the left to the position you want.

HideLock rows and columns by freezing panes

  1. To lock rows, select the row below where you want the split to appear.

    To lock columns, select the column to the right of where you want the split to appear.

    To lock both rows and columns, click the cell below and to the right of where you want the split to appear.

  2. On the Window menu, click Freeze Panes.
  3. To unlock rows, click Unfreeze Panes on the Window menu.
  4.  
评论 1
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值