How To Make Excel Column Stay When Scrolling
Freeze Pinnacle Row | Unfreeze Panes | Freeze First Column | Freeze Rows | Freeze Columns | Freeze Cells | Magic Freeze Button
If y'all accept a large tabular array of data in Excel, it tin can be useful to freeze rows or columns. This way you tin proceed rows or columns visible while scrolling through the rest of the worksheet.
Freeze Top Row
To freeze the elevation row, execute the following steps.
one. On the View tab, in the Window group, click Freeze Panes.
Advertizing
ii. Click Freeze Elevation Row.
3. Whorl down to the rest of the worksheet.
Event. Excel automatically adds a dark grayness horizontal line to bespeak that the meridian row is frozen.
Unfreeze Panes
To unlock all rows and columns, execute the post-obit steps.
1. On the View tab, in the Window grouping, click Freeze Panes.
2. Click Unfreeze Panes.
Freeze First Column
To freeze the first column, execute the following steps.
1. On the View tab, in the Window group, click Freeze Panes.
two. Click Freeze First Column.
3. Scroll to the correct of the worksheet.
Effect. Excel automatically adds a dark grey vertical line to betoken that the first column is frozen.
Freeze Rows
To freeze rows, execute the following steps.
1. For case, select row 4.
2. On the View tab, in the Window group, click Freeze Panes.
3. Click Freeze Panes.
4. Coil down to the rest of the worksheet.
Upshot. All rows in a higher place row 4 are frozen. Excel automatically adds a dark grey horizontal line to indicate that the first 3 rows are frozen.
Freeze Columns
To freeze columns, execute the following steps.
ane. For case, select cavalcade E.
2. On the View tab, in the Window group, click Freeze Panes.
3. Click Freeze Panes.
4. Scroll to the right of the worksheet.
Result. All columns to the left of column E are frozen. Excel automatically adds a dark grey vertical line to indicate that the first four columns are frozen.
Freeze Cells
To freeze cells, execute the following steps.
one. For example, select jail cell C3.
two. On the View tab, in the Window group, click Freeze Panes.
three. Click Freeze Panes.
4. Coil downwardly and to the right.
Result. The orange region above row 3 and to the left of column C is frozen.
Magic Freeze Button
Add the magic Freeze button to the Quick Access Toolbar to freeze the top row, the get-go column, rows, columns or cells with a single click.
i. Click the downwards arrow.
ii. Click More Commands.
3. Under Cull commands from, select Commands Not in the Ribbon.
4. Select Freeze Panes and click Add together.
5. Click OK.
6. To freeze the elevation row, select row 2 and click the magic Freeze push button.
vii. Scroll down to the remainder of the worksheet.
Effect. Excel automatically adds a dark greyness horizontal line to indicate that the tiptop row is frozen.
Note: to unlock all rows and columns, click the Freeze button once more. To freeze the first 4 columns, select column E (the 5th cavalcade) and click the magic Freeze push, etc.
Advertising
Source: https://www.excel-easy.com/examples/freeze-panes.html
Posted by: johnsonnoned1998.blogspot.com
0 Response to "How To Make Excel Column Stay When Scrolling"
Post a Comment