Microsoft Excel useful Shortcut Keys
Below is a listing of all the major shortcut keys usable in Microsoft Excel.
Shortcut
|
Description
|
F2
|
Edit the selected cell.
|
F3
|
After a name has been created, F3 will paste names.
|
F4
|
Repeat
last action. For example, if you changed the color of text in another
cell, pressing F4 will change the text in cell to the same color.
|
F5
|
Go to a specific cell. For example, C6.
|
F7
|
Spell check selected text or document.
|
F11
|
Create chart from selected data.
|
Ctrl + Shift + ;
|
Enter the current time.
|
Ctrl + ;
|
Enter the current date.
|
Alt + Shift + F1
|
Insert New Worksheet.
|
Alt + Enter
|
While
typing text in a cell, pressing Alt + Enter will move to the next
line, allowing for multiple lines of text in one cell.
|
Shift + F3
|
Open the Excel formula window.
|
Shift + F5
|
Bring up search box.
|
Ctrl + 1
|
Open the Format Cells window.
|
Ctrl + A
|
Select all contents of the worksheet.
|
Ctrl + B
|
Bold highlighted selection.
|
Ctrl + I
|
Italic highlighted selection.
|
Ctrl + K
|
Insert link.
|
Ctrl + S
|
Save the open worksheet.
|
Ctrl + U
|
Underline highlighted selection.
|
Ctrl + 1
|
Change the format of selected cells.
|
Ctrl + 5
|
Strikethrough highlighted selection.
|
Ctrl + P
|
Bring up the print dialog box to begin the printing process.
|
Ctrl + Z
|
Undo last action.
|
Ctrl + F3
|
Open Excel Name Manager.
|
Ctrl + F9
|
Minimize current window.
|
Ctrl + F10
|
Maximize currently selected window.
|
Ctrl + F6
|
Switch between open workbooks or windows.
|
Ctrl + Page up
|
Move between work sheets in the same document.
|
Ctrl + Page down
|
Move between work sheets in the same document.
|
Ctrl + Tab
|
Move between Two or more open Excel files.
|
Alt + =
|
Create a formula to sum all of the above cells.
|
Ctrl + '
|
Insert the value of the above cell into the cell currently selected.
|
Ctrl + Shift + 1
|
Format number in comma format.
|
Ctrl + Shift + 4
|
Format number in currency format.
|
Ctrl + Shift + 3
|
Format number in date format.
|
Ctrl + Shift + 5
|
Format number in percentage format.
|
Ctrl + Shift + 6
|
Format number in scientific format.
|
Ctrl + Shift + 2
|
Format number in time format.
|
Ctrl + Arrow key
|
Move to next section of text.
|
Ctrl + Space
|
Select entire column.
|
Shift + Space
|
Select entire row.
|
Ctrl + -
|
Delete the selected column or row.
|
Ctrl + Shift + =
|
Insert a new column or row.
|
Ctrl + Home
|
Move to cell A1.
|
Ctrl + ~
|
Switch between showing Excel formulas or their values in cells.
|
Microsoft PowerPoint Keyboard Shortcuts 2013
Most of you use Microsoft PowerPoint pretty
frequently in your day-to-day work.So, assuming those assumptions are
correct, I’d like to help you improve your productivity by sharing the most useful Microsoft PowerPoint shortcut keys.
Microsoft PowerPoint Keyboard Shortcuts 2013
| ||
Action
|
Shortcut Key
| |
Switch between outline and thumbnail pane
|
Ctrl + Shift + Tab
| |
Move to next placeholder (if on slide’s last placeholder, this inserts a new slide)
|
Ctrl + Enter
| |
Insert a new slide
|
Ctrl + M
| |
Duplicate the current side
|
Ctrl + D
| |
Increase font size
|
Ctrl + Shift + >
| |
Decrease font size
|
Ctrl + Shift + <
| |
Display the font dialog box
|
Ctrl + T or Ctrl + Shift + F
| |
Change case
|
Shift + F3
| |
Apply superscript formatting
|
Ctrl + Equal sign
| |
Apply subscript formatting
|
Ctrl + Shift + Plus sign
| |
Remove manual character formatting
|
Ctrl + Spacebar
| |
Center a paragraph
|
Ctrl + E
| |
Justify a paragraph
|
Ctrl + J
| |
Left align a paragraph
|
Ctrl + L
| |
Right align a paragraph
|
Ctrl + R
| |
Promote a paragraph in an outline
|
Alt + Shift + Left arrow
| |
Demote a paragraph in an outline
|
Alt + Shift + Right arrow
| |
Move selected outline paragraphs up
|
Alt + Shift + Up arrow
| |
Move selected outline paragraphs down
|
Alt + Shift + Down arrow
| |
Display outline heading level 1
|
Alt + Shift + 1
| |
Expand outline text below a heading
|
Alt + Shift + +
| |
Collapse outline text below a heading
|
Alt + Shift + –
| |
Collapse or show all text or headings
|
Alt + Shift +A
| |
Show or hide the grid
|
Shift + F9
| |
Show or hide the guides
|
Alt + F9
| |
Run a presentation
|
F5
| |
Activate the pen tool during a show
|
Ctrl + P
| |
Erase pen tool drawings during a show
|
E
| |
Turn off the pen tool during a show
|
Esc
| |
Change the pen to a pointer during a show
|
Ctrl + A
| |
Hide the pointer or pen during a show
|
Ctrl + H
| |
Move to the next hyperlink during a show
|
Tab
| |
Make the screen go black during a show
|
B
| |
Make the screen go white during a show
|
W
| |
Stop or restart an automatic show
|
S
| |
Return to the first slide during show
|
1 + Enter
| |
Group Items (with items selected)
|
Ctrl + G
| |
Ungroup
|
Ctrl + Shift + G
| |
During presentation, Go to slide number
|
Slide number + Enter
| |
Move clockwise among panes in Normal view
|
F6
| |
Move counterclockwise among panes in Normal view
|
Shift + F6
| |
Copy formatting of selected shape
|
Ctrl + Shift + C
| |
Paste formatting only to another shape
|
Ctrl + Shift + V
| |
Insert hyperlink
|
Ctrl + K
| |
Help
|
F1
| |
View the complete slide show
|
F5
| |
View the slide show from the current slide forward
|
Shift + F5
| |
Spellcheck
|
F7
| |
Opens Save As dialog box
|
F12
| |
Stop the show. Press S again to restart the show
|
S
| |
End the slide show
|
Esc
| |
Select to the end of a word
|
Ctrl + Shift + Right arrow
| |
Select to the beginning of a word
|
Ctrl + Shift + Left arrow
| |
Select all objects
|
Ctrl + A (on Slides tab)
| |
Select all slides
|
Ctrl + A (in Slide Sorter view)
| |
Select all text
|
Ctrl + A (on the Outline tab)
| |
Delete one word to the left
|
Ctrl + Backspace
| |
Delete one word to the right
|
Ctrl + Delete
| |
Cut selected object or text
|
Ctrl + X
| |
Copy selected object or text
|
Ctrl + C
| |
Paste cut or copied object or text
|
Ctrl + V
| |
Undo
|
Ctrl + Z
| |
Redo
|
Ctrl + Y
| |
Open Find dialog box
|
Ctrl + F
| |