Wednesday, 18 April 2018

Microsoft Excel Shortcut keys



  • Ctrl+A


Select All


  • Ctrl+B


Bold

Format, Cells, Font, Font Style, Bold


  • Ctrl+C


Copy

Edit, Copy


  • Ctrl+D


Fill Down

Edit, Fill, Down


  • Ctrl+F


Find

Edit, Find


  • Ctrl+G


Goto

Edit, Goto


  • Ctrl+H


Replace

Edit, Replace


  • Ctrl+I


Italic

Format, Cells, Font, Font Style, Italic


  • Ctrl+K


Insert Hyperlink

Insert, Hyperlink


  • Ctrl+N


New Workbook

File, New


  • Ctrl+O


Open

File, Open


  • Ctrl+P


Print

File, Print


  • Ctrl+R


Fill Right

Edit, Fill Right


  • Ctrl+S


Save

File, Save


  • Ctrl+U


Underline

Format, Cells, Font, Underline, Single


  • Ctrl+V


Paste

Edit, Paste


  • Ctrl+X


Cut

Edit, Cut


  • Ctrl+Y


Repeat

Edit, Repeat


  • Ctrl+Z


Undo

Edit, Undo


  • F1


Help

Help, Contents and Index


  • F2


Edit

None


  • F3


Paste Name

Insert, Name, Paste


  • F4


Repeat last action

Edit, Repeat. Works while not in Edit mode.


  • F4


While typing a formula, switch between absolute/relative refs

None


  • F5


Goto

Edit, Goto


  • F6


Next Pane

None


  • F7


Spell check

Tools, Spelling


  • F8


Extend mode

None


  • F9


Recalculate all workbooks

Tools, Options, Calculation, Calc,Now


  • F10


Activate Menubar

N/A


  • F11


New Chart

Insert, Chart


  • F12


Save As

File, Save As

No comments:

Post a Comment

Nokia X poster surfaced, to arrive with 6GB RAM and dual camera!

It seems like HMD Global is getting ready for another smartphone launch! Today, a new Nokia X poster has confirmed the arrival of this devic...