vba快捷键（vba shortcut key）.doc

vba快捷键(VBAshortcutkey)Alot,monlyusedisusuallysuitableforallWindowsoperations:Ctrl+C,Ctrl+V,Ctrl+Z,Ctrl+Y,Ctrl+B,andsoon-------------------------------------------------------------------binationshortcutkeyButtondescriptionCtrl+(+)+&++~appliesthe"regular"+$appliesacurrencyformatwithtwodecimalplaces(negativenumbersinparentheses).Ctrl+%+^+#applicationshaveday,month,+***@applicationshavehoursandminutes,andAMorPMinthe"time"+!Withtwodecimalplaces,thousandsseparatorandminus(-)(negativefor)+-+*selectsthecurrentareasurroundingtheactivecell(thedataregionenclosedbytheblankrowsandblankcolumns).InthePivotTable,+:+;+`+'+"copyvaluesfromcellsaboveactivecellstocellsoreditcolumns.".Ctrl++++++++6switchesbetweenhiddenobjects,displayobjects,+++++,pressCtrl++,,pressCtrl+S