Short Keys for PC

Ctrl+A=SelectAll

Ctrl+B=Bold

Ctrl+C=Copy

Ctrl+D=FillDown

Ctrl+F=Find

Ctrl+G=Goto

Ctrl+H=Replace

Ctrl+I=Italic

Ctrl+K=InsertHyperlink

Ctrl+N=NewWorkbook

Ctrl+O=Open

Ctrl+P=Print

Ctrl+R=FillRight

Ctrl+S=Save

Ctrl+U=Underline

Ctrl+V=Paste

CtrlW=Close

Ctrl+X=Cut

Ctrl+Y=Repeat

Ctrl+Z=Undo

F1=Help

F2=Edit

F3=PasteName

F4=Repeatlastaction

F5=Goto

F6=NextPane

F7=Spellcheck

F8=Extendmode

F9=Recalculateallworkbooks

F10=ActivateMenubar

F11=NewChart

F12=SaveAs

Ctrl+:=InsertCurrentTime

Ctrl+;=InsertCurrentDate

Ctrl+”=CopyValuefromCellAbove

Ctrl+’=CopyFormulafromCellAbove

Shift+F1=What’sThis?

Shift+F2=Editcellcomment

Shift+F3=Pastefunctionintoformula

Shift+F4=FindNext

Shift+F5=Find

Shift+F6=PreviousPane

Shift+F8=Addtoselection

Shift+F9=Calculateactiveworksheet

Shift+F10=Displayshortcutmenu

Shift+F11=Newworksheet

Shift+F12=Save

Ctrl+F3=Definename

Ctrl+F=-Close

Ctrl+F5=XL,Restorewindowsize

Ctrl+F6=Nextworkbookwindow

Ctrl+F7=Movewindow

Ctrl+F8=Resizewindow

Ctrl+F9=Minimizeworkbook

Ctrl+F11=Inset4.0Macrosheet

Ctrl+F1=FileOpen

Alt+F1=InsertChart

Alt+F2=SaveAs

Alt+F4=Exit

Alt+F8=Macro 7dialogbox

Alt+F11=VisualBasicEditor

Ctrl+Shift+F6=PreviousWindow

Ctrl+Shift+F12=Print

Alt+Shift+F1=Newworksheet

Alt+Shift+F2=Save

Alt+= =AutoSum

Alt+’=FormatStyledialogbox

Ctrl+Shift+~=Generalformat

Ctrl+Shift+!=Commaformat

Ctrl+Shift+@=Timeformat

Ctrl+Shift+#=Dateformat

Ctrl+Shift+$=Currencyformat

Ctrl+Shift+%=Percentformat

Ctrl+Shift+^=Exponentialformat

Ctrl+Shift+_=Removeoutlineborder

Ctrl+Shift+*=Selectcurrentregion

Ctrl++=Insert

Ctrl+-=Delete

Ctrl+1=Formatcellsdialogbox

Ctrl+2=Bold

Ctrl+3=Italic

Ctrl+4=Underline

Ctrl+5=Strikethrough

Ctrl+6=Show/Hideobjects

Ctrl+7=Show/HideStandardtoolbar

Ctrl+8=ToggleOutlinesymbols

Ctrl+9=Hiderows

Ctrl+0=Hidecolumns

Ctrl+Shift+(=Unhiderows

Ctrl+Shift+)=Unhidecolumns

AltorF10=Activatethe menu Ctrl+Tab=Intoolbar:nexttoolbar

Tab=Nexttool

Shift+Tab=Previoustool

Enter=Dothecommand

Shift+Ctrl+F=FontDropDownList

 

Shift+Ctrl+F+F = FonttabofFormatCellDialogbox

Shift+Ctrl+P = PointsizeDropDownList

F4=Whiletypingaformula,switchbetweenabsolute/relativerefs

Shift+Ctrl+F6 = Previousworkbookwindow

Ctrl+F10=Maximizeorrestorewindow

Shift=Hold down shift for additional functions in Excel’s menu

Ctrl+`=ToggleValue/Formuladisplay

Ctrl+Shift+A = Insertargumentnamesintoformula

Alt+Downarrow = DisplayAutoCompletelist

Ctrl+Shift+& = Placeoutlineborderaroundselectedcells

Shift+Ctrl+Tab = Intoolbar:previoustoolbar

Ctrl+Tab = Inaworkbook:activatenextworkbook

Shift+Ctrl+Tab = Inaworkbook:activatepreviousworkbook

Ctrl+Shift+F3 = Createnamebyusingname of row and columnlabels

 

 

About Author

Leave a Reply

Leave a Reply

Your email address will not be published. Required fields are marked *