Excel General Notes¶
Some Keyboard Shortcuts¶
| Shorcut | Info |
|---|---|
| Alt + ; | Select visible cells only |
| Alt + PgUp/PgDown | Scroll to right/left |
| Alt + H O I | AUTO-FIT COLUMN WIDTHS |
| Ctrl + [ or ] | will actually select all precedent / dependent cells - if there is only one, this will jump to it |
| Ctrl + R | (in VBE) to switch to Project Explorer pane |
| Alt + J T L | Show/Hide Field List (Pivot Table) |
Formula Auditing (trace dependents/trace precedents) grayed out/disabled¶
If there is no workbook or worksheet protection enabled, try checking this setting:
Office button > Excel Options > Advanced > Display options for this workbook > For objects, show:
If it's set to "Nothing", change it to "All".