Microsoft Excel: Difference between revisions
Jump to navigation
Jump to search
| Line 31: | Line 31: | ||
Investments.xlsx#'FENY (M)'!A1 | Investments.xlsx#'FENY (M)'!A1 | ||
</font> | </font> | ||
==Edit the Same Cell in Multiple Worksheets== | |||
Select the first worksheet you want to edit. | |||
Hold down the Shift key as you click on the additional worksheets you want to edit (alternatively you can [[#How_to_Select_All_Worksheets|select all worksheets]] and just de-select those you don't want to edit). Excel will add the word "Group" to the title bar to indicate you have a group of worksheets. | |||
Make the change in the first worksheet. The change will propagate to all selected worksheets. | |||
==How to Select All Worksheets== | |||
Revision as of 18:40, 18 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:
Investments.xlsx#'FENY (M)'!A1
Edit the Same Cell in Multiple Worksheets
Select the first worksheet you want to edit.
Hold down the Shift key as you click on the additional worksheets you want to edit (alternatively you can select all worksheets and just de-select those you don't want to edit). Excel will add the word "Group" to the title bar to indicate you have a group of worksheets.
Make the change in the first worksheet. The change will propagate to all selected worksheets.