Microsoft Excel
Jump to navigation
Jump to search
Internal
Overview
Subjects
- General Functions in Excel
- Time and Date Functions in Excel
- Conditional Sum in Excel
- Counting Cells in Excel
- Financial Functions in Excel
- Get a Column Value Corresponding to a Value Match in Another Column
- Python Support in Excel
- Last Non-Empty Cell in a Column in Excel
- nth Root of a Number in Excel
Operations
Freeze Rows
Select a cell below the rows and to the right of the columns you want to freeze. Then go to View → Freeze Panes → Freeze Panes.
=Link to a Specific Tab and Cell in Another Excel Document
Ctrl -K → Web Page or File → Navigate to the Excel file and use its name in the Address field → Append #'Tab name even if includes spaces'!Cell.
Example: