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 window, select the table that contains the columns that you want …
Turn off Scroll Lock - Microsoft Support
If a check is not visible, Scroll Lock does not appear in the Excel status bar. Simply check the box to have the status appear on the status bar. If Scroll Lock is on, your cursor moves between columns and rows, not cells. Here's how to turn off Scroll Lock.
Lock or unlock specific areas of a protected worksheet
Follow these steps: If the worksheet is protected, do the following: On the Review tab, select Unprotect Sheet (in the Protect group). Select Protect Sheet to change to Unprotect Sheet when a worksheet is protected. If prompted, enter the password to unprotect the worksheet.
Tips for Excel for Windows - Microsoft Support
Freeze the top row of column headings so that only the data scrolls. Press Enter or Esc to make sure you're done editing a cell. Select View > Freeze Top Row. For more information, see Freeze panes.
What to do if a data set is too large for the Excel grid
If you’ve opened a file with a large data set in Excel, such as a delimited text (.txt) or comma separated (.csv) file, you might see the warning message, "This data set is too large for the Excel grid. If you save this workbook, you'll lose data that wasn't loaded."
Enter and format data - Microsoft Support
Freeze panes to lock rows and columns. Create, apply, or delete a custom view. Lock or unlock specific areas of a protected worksheet. Turn off Scroll Lock Split panes to lock rows or columns in separate worksheet areas. Automatically number rows. Group or ungroup shapes, pictures, or other objects Insert or delete a worksheet
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.
Replace a formula with its result - Microsoft Support
If you want to freeze only part of a formula, you can replace only the part you don't want to recalculate. Replacing a formula with its result can be helpful if there are many or complex formulas in the workbook and you want to improve performance by creating static data.
Get started with Power Pivot in Microsoft Excel
Create a Data Model in Excel. Create a memory-efficient Data Model using Excel and the Power Pivot Add-in. When to use Calculated Columns and Calculated Fields. Data Model specification and limits. Data types in Data Models. Freeze columns.
Scale a worksheet - Microsoft Support
In Excel, you can scale a worksheet for printing by shrinking or enlarging its size to better fit the printed pages. You can also scale a worksheet to fit the paper width of printed pages, or specify the number of pages that you want to use for the printed worksheet.