Microsoft Excel: Difference between revisions
Jump to navigation
Jump to search
| Line 22: | Line 22: | ||
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. | 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= | ==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. | 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. | ||
Revision as of 01:12, 5 February 2024
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: