下载
加入VIP
  • 专属下载特权
  • 现金文档折扣购买
  • VIP免费专区
  • 千万文档免费下载

上传资料

关闭

关闭

关闭

封号提示

内容

首页 excle表格快捷键大全(Excle form shortcut key Daquan)

excle表格快捷键大全(Excle form shortcut key Daquan).doc

excle表格快捷键大全(Excle form shortcu…

只为等一个不确定未来
2018-02-05 0人阅读 举报 0 0 暂无简介

简介:本文档为《excle表格快捷键大全(Excle form shortcut key Daquan)doc》,可适用于社会民生领域

excle表格快捷键大全(ExcleformshortcutkeyDaquan)excle表格快捷键大全(ExcleformshortcutkeyDaquan)excleshortcutsShortcutkeysformanipulationoftoolbarsActivatethemenubar,F,AltSelecttheprevioustoolbarorthenexttoolbar,CtrlTaborCtrlShiftTabSelectthenextorpreviousbuttonormenuinthetoolbar,TaborShiftTab(whenatoolbarisactivated)Opentheselectedmenu,EnterRuntheselectbuttonoperation,EnterIntheselectedtextbox,enterthetext,EnterShortcutkeysusedindialogboxesCancelthecurrenttask,EscClickthecorrespondingcommand,AltunderlinelettersClicktheselectedbutton,EnterMoveforwardintheoptions,TabMovebehindtheoptions,ShiftTabMoveforwardinthetab,CtrlTabMovebackinthetab,CtrlShiftTabRefresh"saveas"or"open"dialogbox,FInsert,delete,andcopyshortcutkeysforselectedareasCopytheselectedarea,CtrlCPastetheselectedarea,CtrlVCuttheselectedarea,CtrlXClearthecontentsoftheselectedarea,DeleteInsertablankcell,CtrlShiftplusDeletetheselectedarea,CtrlUndothelastoperation,CtrlZTheshortcutkeyusedbythe"officehelper"Closethemessageprovidedbytheofficehelper,EscGethelpinformationthrough"officehelper",FShowthenextprompt,AltNDisplaythepreviousprompt,AltBShoworhidetheofficehelperinthewizard,thespacebarkeyShortcutkeysforwindowmanipulationSwitchtothenextprogram,AltTabSwitchtothepreviousprogram,AltShiftTabShowthewindwosstartmenu,CtrlEscCloseactiveworksheetwindow,CtrlWRestoreactiveworkthinwindow,CtrlFSwitchtothenextworkingthinwindow,CtrlFSwitchtothepreviousworkingthinwindow,CtrlShiftFExecutethemovecommand(theworkbookiconmenuinthemenubar),CtrlFRunthesizecommand(theworkbookiconmenuinthemenubar),CtrlFMinimizetheworkwindowasanicon,CtrlFMaximizeorrestoretheworkthinwindow,CtrlFUpdatethevisiblefileintheopenorsaveasdialogbox,FShortcutkeystousedialogboxestooperateSwitchtothenexttabinthedialogbox,CtrlTaborCtrlPageDownSwitchtotheprevioustabinthedialogbox,CtrlShiftTaborCtrlPageUpMovetothenextoptionoroptiongroup,TabMovetothepreviousoptionoroptiongroup,ShiftTabMovebetweentheoptionsintheactivedropdownlistboxormovebetweentheoptionsgroupoptionsTheoperationoftheentertainmentbutton,orselectorclearthecurrentcheckbox,theblankkeyCancelthecommandorclosethedialogbox,EscShortcutkeysformanipulationintextboxesMovetothebeginningofcontent,HomeMovetotheendofthecontent,EndMoveleftorrightonecharacter,leftandrightdirectionkeyMoveawordtotheleftorright,CtrlorsoSelectinputfromtheinsertionpointtothebeginning,ShiftHomeSelecttheinputfromtheinsertionpointtothelastinput,ShiftEndSelectorcancelacharacterontheleft,ShiftleftkeySelectorcancelonecharacterontheright,ShiftrightkeySelectorcancelawordontheleft,CtrlShiftleftkeySelectorcancelawordontheright,CtrlShiftrightkeySelectshortcutkeysforcells,columns,rows,orobjectsinworksheetandWorkbookSelecttheareaaroundthecurrentcell,CtrlShift*(asterisk)Extendstheselectedareatoacellwidth,ShiftdirectionkeyExtendtheselectedareatothelastnonblankcellinthesameroworthesamecolumnastheactivecell,andtheCtrlShiftdirectionkeyTheselectedregionisextendedtotheShiftHomeExtendtheselectedregiontothebeginningoftheworksheet,CtrlShiftHomeExtendtheselectedregiontothelastcellcontainingthedataintheworksheet,CtrlShiftEndSelectthewholecolumn,CtrlspacekeySelectthewholerow,ShiftspacekeySelecttheentireworksheet,CtrlAIfmultiplecellshavebeenselected,onlytheactivecellinitisselected,ShiftBackspaceExtendingtheselectedareadownwardtoonescreen,ShiftPageDownExpandtheselectedareauptoonescreen,ShiftPageUpWhenyouselectanobject,selectalltheobjectsontheworksheet,andtheCtrlShiftspacekeyTogglesbetweenhiddenobjects,displayobjects,andobjectplaceholders,CtrlShoworhidethetoolbar,CtrlShortcutkeysfordisplayingdataonahierarchicalbasisCancelroworcolumngrouping,AltShiftleftkeyRightlinekeyforgroupingrowsorcolumns,AltShiftDisplayingorhidingthehierarchicaldisplaysymbols,CtrlHidetheselectedrow,CtrlCanceltheselectedrow,CtrlShiftHideselectedcolumn,CtrlCanceltheselectedcolumn,CtrlShift)EdittheshortcutkeyofthecellCompletecellinput,EnterCancelcellinput,EscRepeatcellsonce,ForCtrlYFoldincell,AltEnterDeletethecharacterontheleftoftheinsertionpointordeletetheselectedarea,BackspaceDeletethecharacterontherightoftheinsertionpointordeletetheselectedarea,DeleteMoveacharacterupanddown,directionkeyHome,HomeMovetotheendoftheline,EndEditcellannotation,ShiftFCreateanamebyroworcolumnflag,CtrlShiftFFilldown,CtrlDFillright,CtrlRFillstheselectedcellregionwiththecurrentinput,CtrlEnterCompletethecellinputandmovedownintheselectedarea,EnterCompletethecellinputandmoveupintheselectedarea,ShiftEnterCompletethecellinputandmoverightintheselectedarea,TabCompletecellentryandinselectedareasofleftshift,ShiftTabShortcutkeysusedincellsoreditcolumnsTypeaformula,=(equalsign)Canceltheinputinthecelloreditcolumn,EscEditthecurrentcell,FEdittheactivecellandclearitscontents,ordeletethepreviouscharacteratedittime,BackspacePastethenameintotheformula,FDefinename,CtrlFCalculatesallworksheetsinallopenjobs,FCalculateactiveworksheet,ShiftFInput"autosum"formula,Alt=(equalsign)Inputdate,CtrlInputtime,CtrlShift:Inserthyperlink,CtrlKCompletecellinput,EnterCopythevaluesinthecellabovethecurrentcelltothecurrentcelloreditcolumn,CtrlShift(doublequotationmarks)Copiestheformulasinthecellabovethecurrentcelltothecurrentcelloreditcolumn,Ctrl'(singlequotationmarks)Inthedisplayvalueofcelltransformationandcellformula,Ctrl`(superscript)Inputarrayformula,CtrlShiftEnterAfterenteringthevalidfunctionname,displaytheformulaoptionsboard,CtrlAAfterenteringthevalidfunctionname,insertthevariablenameandbracketforthefunction,CtrlShiftAShowthe"memorytype"list,andtheCtrlkeyShortcutkeyanddataformatsettingDisplaythe"style"command,Alt'(singlequote)Showthecellcommand,CtrlUsingtheconventionaldigitalformat,CtrlShift~Usethe"currency"formatwithtwodecimalplaces,CtrlShift$Usingthepercentageformatwithoutsmalldigits,CtrlshiftUsingadigitalformatofscientificnotationwithtwodecimalplaces,Ctrlshift^Applicationdate,dateformat,Ctrlshift#Applyhoursandminutes"time"format,andshowmorningorafternoon,CtrlshiftApplyouterborders,CtrlshiftDeselectallthebordersintheselectedcellregion,CtrlshiftApplyorcancelfontboldformat,CtrlBApplyorcancelfontslantformat,CtrlIApplyorcancelfontunderlineformat,CtrlUApplyorcancellinedeletionformat,CtrlHiddenrows,CtrlCancelhiddenrows,CtrlShiftHiddencolumns,CtrlCancelhiddencolumns,CtrlShift)

用户评价(0)

关闭

新课改视野下建构高中语文教学实验成果报告(32KB)

抱歉,积分不足下载失败,请稍后再试!

提示

试读已结束,如需要继续阅读或者下载,敬请购买!

文档小程序码

使用微信“扫一扫”扫码寻找文档

1

打开微信

2

扫描小程序码

3

发布寻找信息

4

等待寻找结果

我知道了
评分:

/8

excle表格快捷键大全(Excle form shortcut key Daquan)

VIP

在线
客服

免费
邮箱

爱问共享资料服务号

扫描关注领取更多福利