Skip to content

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".

http://www.excelforum.com/showthread.php?t=823449