2019年11月19日

How to Freeze Rows and Columns in Excel 2016

When you are working with a lot of data in your laptop, it can be hard to compare a number of rows with other people which are towards the bottom of the workbook. Excel's freeze panes feature solves this problem allowing you lock specific rows so they're always visible whenever you scroll. Here's how you can freeze rows and columns in Excel 2016.


There are two quick steps to freezing or locking rows.


How you can Freeze Rows in Excel


1. Select the row right underneath the row or rows you need to freeze. If you want to freeze columns, choose the cell immediately right of the column you need to freeze. Within this example, we want to freeze rows 1 to six, so we've selected row 7.


2. Go to the View tab


3. Choose the Freeze Panes command and select "Freeze Panes."


That's all there is into it. As you can see in our example, the frozen rows will stay visible when you scroll down. You are able to tell in which the rows were frozen through the green line dividing the frozen rows and also the rows below them.


If you wish to unfreeze the rows, return to the Freeze Panes command and select "Unfreeze Panes".


Observe that underneath the Freeze Panes command, you may also choose "Freeze Top Row," which will freeze the very best row that's visible (and then any others above it) or "Freeze First Column," which will keep the leftmost column visible when you scroll horizontally.


Besides allowing you to compare different rows inside a long spreadsheet, the freeze panes feature enables you to keep important information, such as table headings, forever in view.

posted by vorry at 15:43| Comment(0) | 日記 | 更新情報をチェックする
この記事へのコメント
コメントを書く
コチラをクリックしてください