Week four of the Quick Tip Shortcut Series. This week we have Excel Shortcut Keys. We think that it is worthwhile remembering a few of these shortcuts because they are bound to come in useful! Please Note: Some shortcuts may not work in Excel 2007.
Microsoft Excel Shortcut Keys:
F2 – Edit the selected cell
F5 – Go to a specific cell
F7 – Spell check selected text and/or document
F11 – Create Chart
Ctrl + Shift + ; – Enter current time
Ctrl + ; – Enter current date
Alt + Shift + F1 – Insert new worksheet
Shift + F3 – Open the Excel formula window
Shift + F5 – Bring up search box
Ctrl + A – Select all contents of worksheet
Ctrl + B – Bold highlighted selection
Ctrl + I – Italicize highlighted selection
Ctrl + C – Copy selected text
Ctrl + V – Paste
Ctrl + D – Fill
Ctrl + K – Insert Link
Ctrl + F – Open find and replace options
Ctrl + U – Underline highlighted selection
Ctrl + Y – Underline selected text
Ctrl + O – Open options
Ctrl + N – Open new document
Ctrl + P – Open print dialog box
Ctrl + S – Save
Ctrl + Z – Undo last action
Ctrl + F9 – Minimize current window
Ctrl + F10 – Maximize currently selected window
Ctrl + F6 – Switch between open workbooks/windows
Ctrl + Page Up + Page Down – Move between excel worksheets in the same document
Ctrl + ‘ – Insert value of above cell into current cell
Ctrl + Space – Select entire column
Shift + Space – Select entire row
Ctrl + W – Close Document
Next week our topic is Microsoft Outlook Shortcut Keys!
Disclaimer: pctoolbox.co.uk cannot be held responsible for any problems that are caused from using the shortcuts. All shortcuts work to the best of our knowledge.