Operation ShortcutMultiselect Cells Alt+Left ClickDel Row/Col Ctrl+KSelect Range Ctrl+*Go to Corner Ctrl+.Edit Selected Ctrl+EnterFill Down Ctrl+DFill Right Ctrl+RCopy Prev Formula Ctrl+’Copy Above Val Ctrl+”Sum Alt+=Go to First Cell Ctrl+Home Go to Last CellCtrl+End Start of Row HomeNext Sheet Ctrl+Page DownNext Workbook Ctrl+F6Prev Workbook Ctrl+Shift+F6Prev Sheet Ctrl+Page UpGo to F5Set Currency Shift+Ctrl+$Set Percent Shift+Ctrl+%Set Number Ctrl+Shift+~Set Date Ctrl+Shift+#Insert Line Br Alt+EnterRepeat Action F4Format Cell Ctrl+1Insert Date Ctrl+; Insert Time Ctrl+:Remove Border Ctrl+Shift+_ Border Cells Ctrl+Shift+&Select Cell Group Shift+Cursors
No comments:
Post a Comment