#NiftyKeyboardShortcuts: Undo (Ctrl + Z)
Help! I didn't mean to do that! Never fear...unlike most other keyboard shortcuts, Ctrl + Z is there to rescue something that has gone...
#NiftyKeyboardShortcuts: Jump between tabs (Ctrl + PgUp / PgDn)
One reason I’ve come across people wanting to learn and use keyboard shortcuts is where their dexterity has been limited by injuries...
#NiftyKeyboardShortcuts: Insert Default Chart (Alt + F1)
If a picture is worth a thousand words, then a chart may be worth a thousand stats. They tell the same story but in visualising data...
#NiftyKeyboardShortcuts: Duplicate (Ctrl + D)
I overheard a colleague at work today who was singing the virtues of the duplicate function, so Ctrl + D is well worth covering in this...
#NiftyKeyboardShortcuts: Go To / Go To Special (F5)
There might not be many occasions when you want to move straight to a specific cell, but in large spreadsheets or workbooks you don’t...
#NiftyKeyboardShortcuts: Formatting Fundamentals 1: Bold (CTRL + B), Italic (CTRL + I) and Underline
The keyboard shortcuts for commonest formatting options of bold, italic and underline.
#NiftyKeyboardShortcuts: Select a region (CTRL + SHIFT + arrow keys)
Selecting a region is a preparatory step in entering or transforming all the data within it. For instance, you may want to enter a figure...
#NiftyKeyboardShortcuts: Move between regions (CTRL + arrow keys)
There's nothing to better illustrates Excel's innate structure than its regions, between which you can jump with the super shortcut
#NiftyKeyboardShortcuts: Find and Replace (CTRL + H)
Access the power of making hundreds of updates simultaneously with Find and Replace.
#NiftyKeyboardShortcuts: Zoom (CTRL + mouse wheel)
Zooming in and out is one of those all-purpose techniques, the shortcut for which prevents you searching for the magnifier in a dull...
