Lock rows and columns in Excel
来源:互联网 发布:咸郎平 知乎 编辑:程序博客网 时间:2024/05/01 04:57
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.
Lock rows and columns by splitting panes
- 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.
- On the Window menu, click Split.
- To remove the split, click Remove Split on the Window menu.
Tip
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.When the pointer changes to a split pointer or , drag the split box down or to the left to the position you want.Lock rows and columns by freezing panes
- 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.
- On the Window menu, click Freeze Panes.
- To unlock rows, click Unfreeze Panes on the Window menu.
- Lock rows and columns in Excel
- Autosize the columns and rows in MSFlexGrid
- Hide/display columns or rows in an Excel document
- Add cells, rows, or columns to an Excel document
- WPF: Changing sizes of grid rows and columns during runtime
- Dragging and dropping table rows in Javascript
- Converting Oracle rows to columns
- #467 – 使用UniformGrid 均分行和列(Use a UniformGrid for Evenly Spaced Rows and Columns)
- Dynamically Creating Bound and Template Columns in GridView
- Defining Custom Columns in SharePoint – Field Types and Options
- SQL_SP:CrossTable(Rows change to Columns)
- SQL_SP:CrossTable(Rows change to Columns)
- Conversion of Oracle Columns into Rows
- Finding Rows In DataSet
- CListCtrl and sorting rows
- Given a matrix of m x n elements (m rows, n columns), return all elements of the matrix in spiral or
- 64.View the Exhibit and examine the data in the PROMO_CATEGORY and PROMO_COST columns of
- [ETL] applied rows and affected rows
- 使用 dom4j 解析 XML
- 将java库转换为.net库
- Extjs的Tree的部分用法
- 关于UrlRewrite重写url
- 主机/目标板调试设置的类型
- Lock rows and columns in Excel
- 用DOM4J对XML文档的读写增删改等操作
- 在.NET平台运行Java程序-IKVM.NET入门
- php和apache和mysql配置 Windows XP + Apache 2.2.4 + PHP 5.2.3 + MySQL 5.0.27 + Zend Optimizer 3.3.0环境配置说明(推荐)
- VS2005透过SourceOffSite访问VSS2005的设置方法
- oracle的正则表达式简单介绍
- Delphi7中连接数据库
- “数独”程序
- 第一章 第五节 处理流程概述