Split panes to lock rows or columns in separate worksheet areas
Splitting a worksheet lets you see two regions at the same time in different panes by scrolling in each pane. It freezes panes while you scroll in one of the panes.
Freeze panes to lock rows and columns - Microsoft Support
How to freeze panes in Excel to keep rows or columns in your worksheet visible while you scroll, or lock them in place to create multiple worksheet areas.
Freeze columns in a Data Model in Power Pivot - Microsoft Support
To keep an area of the Data Model visible while you scroll to another area in the Power Pivot window, you can lock specific columns in one area by freezing them. In the Power Pivot …
Hide or show rows or columns - Microsoft Support
How to hide and unhide columns and rows in an Excel worksheet. Restrict access to only the data you want to be seen or printed.
Video: View files in split and multiple windows - Microsoft Support
Drag one of the windows to the edge of your screen. Select the app you want to see next to it. Open the 2 documents. Select View > View Side by Side. If you scroll up or down, the other …
Apply data validation to cells - Microsoft Support
Use data validation to restrict the type of data or the values that users enter into a cell, like a dropdown list. Select the cell (s) you want to create a rule for. Select Data >Data Validation. …
Change the format of a cell - Microsoft Support
You can apply formatting to an entire cell and to the data inside a cell—or a group of cells. One way to think of this is the cells are the frame of a picture and the picture inside the frame is the …
Add a group box or frame control to a worksheet - Microsoft …
Use an Excel group box or a frame control to group related controls (such as option buttons, check boxes, or closely related contents) into one visual unit.
Turn off Scroll Lock - Microsoft Support
To disable scroll lock, press the Scroll Lock key (often labeled as ScrLk) on your keyboard. If your computer does not have a Scroll Lock key, do one of the following: If your keyboard does not …
Show or hide a chart legend or data table - Microsoft Support
You can show or hide the legend of a chart. Showing a legend can give readers more information about the chart, while hiding a legend can give your chart a cleaner look. Select a chart and …
Restrict changes to files in Excel - Microsoft Support
You can use formatting and editing restrictions to prevent content reviewers from accidentally changing an Excel spreadsheet.