How To Keep First Column Visible In Excel
Topics Map > Office 365 > Excel
Excel - Freeze panes to lock rows and columns
To proceed an expanse of a worksheet visible while you scroll to another area of the worksheet, go to the View tab, where you tin Freeze Panes to lock specific rows and columns in place, or you can Divide panes to create dissever windows of the same worksheet.
Freezing panes versus splitting panes
When you freeze panes, Microsoft Excel keeps specific rows or columns visible when y'all scroll in the worksheet. For example, if the first row in your spreadsheet contains headers, y'all might freeze that row to make sure that the cavalcade headers remain visible as y'all scroll down in your spreadsheet.
A solid line nether row 1 indicates that the row is frozen to go on column headers in identify when you scroll.
Splitting panes is a variation on freezing panes, in that when you separate panes, Excel creates either 2 or 4 separate worksheet areas that you can scroll within, while rows or columns in the non-scrolled area remain visible.
Note: You cannot freeze panes and split panes at the aforementioned time. You can enable just 1 of the two.
Freeze rows or columns
Earlier you choose to freeze rows or columns in a worksheet, information technology's important to consider the following:
-
You lot can freeze only rows at the top and columns on the left side of the worksheet. You cannot freeze rows and columns in the center of the worksheet.
-
TheFreeze Panes command is not available when you're in cell editing fashion (that is, y'all're entering a formula or data in a cell) or when a worksheet is protected. To abolish cell editing fashion, printing Enter or Esc.
Yous can choose to freeze just the top row of your worksheet, just the left column of your worksheet, or multiple rows and columns simultaneously. For example, if y'all freeze row one and so determine to freeze column A, row 1 volition no longer exist frozen. If you want to freeze both rows and columns, y'all demand to freeze them at the same time.
-
Practice one of the following:
-
To lock one row but, cull theView tab, and so clickFreeze Elevation Row.
-
To lock one cavalcade only, choose theView tab, and and so clickFreeze Kickoff Column.
-
To lock more than one row or column, or to lock both rows and columns at the same time, choose theView tab, and so clickFreeze Panes. You will want your cursor to be below the row(southward) yous want to freeze and to the right of whatever cavalcade(s) y'all desire to freeze.
-
To lock multiple rows (starting with row 1), select the row below the last row you want frozen, choose theView tab, and then clickFreeze Panes.
-
To lock multiple columns, select the cavalcade to the right of the last cavalcade you desire frozen, choose theView tab, and and so clickFreeze Panes.
-
Note: If you lot don't see theView tab, it'southward likely that you are using Excel Starter.
Freeze the top row and the commencement column at the same time
To freeze the top row and the first cavalcade at the same time, click theView tab >Freeze Panes >Freeze Panes.
Freeze the top row
Notice that the border under row 1 is a picayune darker than other borders, pregnant that the row higher up information technology is frozen.
Freeze the get-go cavalcade
If you'd rather freeze the leftmost column instead, click theView tab >Freeze Panes >Freeze First Cavalcade.
Now, the line to the right of column A is a little darker than the other lines, meaning that the column to its left is frozen.
Unfreeze rows or columns
-
On theView tab >Window >Unfreeze Panes.
| Keywords: | Freeze panes to lock rows and columns excel microsoft split | Doc ID: | 81433 |
|---|---|---|---|
| Possessor: | John B. | Group: | New Mexico State University |
| Created: | 2018-04-05 09:25 MST | Updated: | 2019-01-24 10:57 MST |
| Sites: | New Mexico State University | ||
| Feedback: | 216 162 Annotate Suggest a new certificate | ||
Source: https://kb.nmsu.edu/page.php?id=81433
Posted by: faucettconwhod.blogspot.com
0 Response to "How To Keep First Column Visible In Excel"
Post a Comment