Keyboard Shortcuts for Google Spreadsheets

I have compiled essential keyboard shortcuts for, much preferred online spreadsheet application, Google Spreadsheets. This will come handy for those who depend heavily on Google spreadsheets for their business activities.

The list below, basically shows the shortcuts available with a PC, if you are a Mac user then you may safely replayce Ctrl with Command key and Alt with Option key.

Editing action
Undo             Ctrl + Z
Insert time         Ctrl + Shift + :
Insert date         Ctrl + Shift + ;
Fill range         Ctrl + Enter
Fill down         Ctrl + D
Fill right         Ctrl + R
Insert/edit comment     Shift + F2
Redo             Ctrl + Y
Edit a cell         F2 (Fn + F2 on a Mac)

Movement action
To start of row     Home
To beginning of sheet     Ctrl + Home
To end of row         End
To end of sheet     Ctrl + End
To next sheet         Ctrl + Shift + PageDown
To previous sheet     Ctrl + Shift + PageUp
Scroll to active cell     Ctrl + Backspace
Find & replace         Ctrl + F

Menus
Show context menu     Ctrl + Shift + \
Show sheet list     Alt + Shift + K
File menu         Alt + F
Display sheet menu     Alt + Shift + S

Formatting action
Bold             Ctrl + B
Underline         Ctrl + U
Italic     Ctrl + I
Strikethrough         Alt + Shift + 5
Apply outer border     Alt + Shift + 7
Remove borders         Alt + Shift + -
Apply top border     Alt + Shift + T
Apply bottom border     Alt + Shift + B
Apply left border     Alt + Shift + L
Apply right border     Alt + Shift + R
Format as currency     Ctrl + Shift + 4
Format as percentage     Ctrl + Shift + 5
Format as exponent     Ctrl + Shift + 6
Format as date         Ctrl + Shift + 3
Format as time         Ctrl + Shift + 2
Format as decimal     Ctrl + Shift + 1

Selection action
Select column         Ctrl + Space
Select row         Shift + Space
Select all         Ctrl + Shift + Space
Select active region     Ctrl + Shift + 8

Insertion action
Insert array formula     Ctrl + Shift + Enter
Add new sheet         Shift + F11

File commands
Save             Ctrl + S
Open             Ctrl + O
Make a copy         Ctrl + Shift + S
Print             Ctrl + P

View
Show all formulas     Ctrl + ~
Compact controls     Ctrl + Shift + F

Navigation
Chat             Shift + Esc

Help
Open documentation (new window) Shift + F1
Show shortcuts help pop-up     Ctrl + /
Enable ARIA/JAWS screenreader     Alt + Shift + ~

Microsoft Word 2010 Keyboard Shortcuts

Microsoft Word 2010 is the latest office suite from Microsoft office stable. I have compiled commonly used shortcut keys for Microsoft office 2010, to help MS Word fans. Please go through the below list of keyboard shortcuts. Also, do update in comments if you know some more.

ALT+CTRL+1    -    Apply Heading 1 to the selected text
ALT+CTRL+2    -    Apply Heading 2 to the selected text
ALT+CTRL+S    -    Splits the Document
ALT+F7        -    Moves to the Next Misspelling
ALT+F8        -    Inserts Macros
ALT+R        -    Displays the Review tab
ALT+SHIFT+BACKSPACE    -    Redo
ALT+SHIFT+F7    -    Dictionary
ALT+SHIFT+K    -    Mail Merge Check
ALT+SHIFT+R    -    Header Footer Link
ALT+SHIFT+T    -    Time Field
ALT+T+A        -    Autocurrect
CTRL +  V    -    Paste copied text
CTRL + B    -    Bold Text
CTRL + C    -    Copy text selection
CTRL + I    -    Italic Text
CTRL + L    -    Align selected text to the left
CTRL + U    -    Underline Text
CTRL + X    -    Cut the selected text
CTRL + Z    -    Undo
CTRL+]        -    Grow Font one point
CTRL+E        -    Align selected text to the centre
CTRL+END    -    Navigate to end of the Document
CTRL+H        -    Find and Replace word or sentence
CTRL+J        -    Justifies Paragraph
CTRL+K        -    Add hyperlink to the selected text
CTRL+M        -    Indentation of  the selected text
CTRL+P        -    Print the document
CTRL+PAGE DOWN    -    Browse Next
CTRL+SHIFT+,    -    Reduce Font size for selected text
CTRL+SHIFT+.    -    Increase Fontsise for selected text
CTRL+SHIFT+A    -    converts the selected text to capital letters or vice versa
CTRL+SHIFT+C    -    Copy Format
CTRL+SHIFT+D    -    Double Underline
CTRL+SHIFT+ENTER-        Column Break
CTRL+SHIFT+F    -    Displays the Font dialog box.
CTRL+SHIFT+F12    -    Also launches Print
CTRL+SHIFT+F5    -    Bookmark
CTRL+SHIFT+G    -    Displays the Word Count dialog box.
CTRL+SHIFT+K    -    Small Caps
CTRL+SHIFT+L    -    Applies Bullets
CTRL+SHIFT+M    -    Unindent the selection
CTRL+SHIFT+P    -    Font size select
CTRL+SHIFT+S    -    Displays the Apply Styles task pane.
CTRL+SHIFT+S    -    Style
END        -    End of line
F1        -    Help window
F10        -    Menu Mode
F12        -    Save As
F5        -    Goto page number
F7         -    Spelling and grammar check
SHIFT+F5    -    Go Back to previous state
ALT+CTRL+Z    -    Go Back to previous state
SHIFT+F7    -    Thesaurus

 

Source: Microsoft.com , AddictiveTips