How To Freeze Top And First Column In Excel
Freeze panes to lock rows and columns
Excel for Microsoft 365 Excel for the web Excel 2021 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel 2007 More than...Less
To continue an area of a worksheet visible while you ringlet to some other area of the worksheet, become to the View tab, where you can Freeze Panes to lock specific rows and columns in place, or y'all can Split panes to create dissever windows of the same worksheet.
Freeze rows or columns
Freeze the first column
-
SelectView>Freeze Panes >Freeze Outset Column.
The faint line that appears betwixt Column A and B shows that the first cavalcade is frozen.
Freeze the beginning ii columns
-
Select the third cavalcade.
-
SelectView> Freeze Panes >Freeze Panes.
Freeze columns and rows
-
Select the cell below the rows and to the correct of the columns you want to go along visible when you scroll.
-
SelectView>Freeze Panes >Freeze Panes.
Unfreeze rows or columns
-
On the View tab > Window > Unfreeze Panes.
Note:If y'all don't see the View tab, it's likely that you are using Excel Starter. Not all features are supported in Excel Starter.
Need more than assistance?
Y'all can always inquire an expert in the Excel Tech Customs or become support in the Answers customs.
See Likewise
Freeze panes to lock the first row or column in Excel 2016 for Mac
Split panes to lock rows or columns in separate worksheet areas
Overview of formulas in Excel
How to avoid broken formulas
Detect and right errors in formulas
Keyboard shortcuts in Excel
Excel functions (alphabetical)
Excel functions (by category)
Source: https://support.microsoft.com/en-us/office/freeze-panes-to-lock-rows-and-columns-dab2ffc9-020d-4026-8121-67dd25f2508f
Posted by: paulifeackle.blogspot.com
0 Response to "How To Freeze Top And First Column In Excel"
Post a Comment