Power users rely on these lesser-known Excel shortcuts to work faster across large datasets, formulas, and worksheets.
CTRL+PgUp Switches between worksheet tabs, from left-to-right. CTRL+PgDn Switches between worksheet tabs, from right-to-left. CTRL+SHIFT+(Unhides any hidden rows within the selection. CTRL+SHIFT+& ...
Yesterday, we published a list of 15 Excel functions everyone should know to help you on your way to spreadsheet mastery. If you want to be efficient as possible while using your newfound knowledge, ...