DATAShortcut keyActionMenu equivalent commentsVersionCtrl+ASelect AllNoneAllCtrl+BBoldFormat, Cells, Font, Font Style, BoldAllCtrl+CCopyEdit, CopyAllCtrl+DFill DownEdit, Fill, DownAllCtrl+FFindEdit, FindAllCtrl+GGotoEdit, GotoAllCtrl+HReplaceEdit, ReplaceAllCtrl+IItalicFormat, Cells, Font, Font Style, ItalicAllCtrl+KInsert HyperlinkInsert, HyperlinkExcel 97/2000 +Ctrl+NNew WorkbookFile, NewAllCtrl+OOpenFile, OpenAllCtrl+PPrintFile, PrintAllCtrl+RFill RightEdit, Fill RightAllCtrl+SSaveFile, SaveAllCtrl+UUnderlineFormat, Cells, Font, Underline, SingleAllCtrl+VPasteEdit, PasteAllCtrl WCloseFile, CloseExcel 97/2000 +Ctrl+XCutEdit, CutAllCtrl+YRepeatEdit, RepeatAllCtrl+ZUndoEdit, UndoAllF1HelpHelp, Contents and IndexAllF2EditNoneAllF3Paste NameInsert, Name, PasteAllF4Repeat last actionEdit, Repeat. Works while not in Edit mode.AllF4While typing a formula, switch between absolute/relative refsNoneAllF5GotoEdit, GotoAllF6Next PaneNoneAllF7Spell checkTools, SpellingAllF8Extend modeNoneAllF9Recalculate all workbooksTools, Options, Calculation, Calc NowAllF10Activate MenubarN/AAllF11New ChartInsert, ChartAllF12Save AsFile, Save AsAllCtrl+:Insert Current TimeNoneAllCtrl+;Insert Current DateNoneAllCtrl+"Copy Value from Cell AboveEdit, Paste Special, ValueAllCtrl+'Copy Formula from Cell AboveEdit, CopyAllShiftHold down shift for additional functions in Excel's menunoneExcel 97/2000 +Shift+F1What's This?Help, What's This?AllShift+F2Edit cell commentInsert, Edit CommentsAllShift+F3Paste function into formulaInsert, FunctionAllShift+F4Find NextEdit, Find, Find NextAllShift+F5FindEdit, Find, Find NextAllShift+F6Previous PaneNoneAllShift+F8Add to selectionNoneAllShift+F9Calculate active worksheetTools, Options, Calculation, Calc SheetAllCtrl+Alt+F9Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.NoneExcel 97/2000 +Ctrl+Alt+Shift+F9Rechecks dependent formulas and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated.NoneExcel 97/2000 +Shift+F10Display shortcut menuNoneAllShift+F11New worksheetInsert, WorksheetAllShift+F12SaveFile, SaveAllCtrl+F3Define nameInsert, Names, DefineAllCtrl+F4CloseFile, CloseAllCtrl+F5XL, Restore window sizeRestoreAllCtrl+F6Next workbook windowWindow, ...AllShift+Ctrl+F6Previous workbook windowWindow, ...AllCtrl+F7Move windowXL, MoveAllCtrl+F8Resize windowXL, SizeAllCtrl+F9Minimize workbookXL, MinimizeAllCtrl+F10Maximize or restore windowXL, MaximizeAllCtrl+F11Inset 4.0 Macro sheetNone in Excel 97. In versions prior to 97 - Insert, Macro, 4.0 MacroAllCtrl+F12File OpenFile, OpenAllAlt+F1Insert ChartInsert, Chart...AllAlt+F2Save AsFile, Save AsAllAlt+F4ExitFile, ExitAllAlt+F8Macro dialog boxTools, Macro, Macros in Excel 97 Tools,Macros - in earlier versionsExcel 97/2000 +Alt+F11Visual Basic EditorTools, Macro, Visual Basic EditorExcel 97/2000 +Ctrl+Shift+F3Create name by using names of row and column labelsInsert, Name, CreateAllCtrl+Shift+F6Previous WindowWindow, ...AllCtrl+Shift+F12PrintFile, PrintAllAlt+Shift+F1New worksheetInsert, WorksheetAllAlt+Shift+F2SaveFile, SaveAllAlt+=AutoSumNo direct equivalentAllCtrl+`Toggle Value/Formula displayTools, Options, View, FormulasAllCtrl+Shift+AInsert argument names into formulaNo direct equivalentAllAlt+Down arrowDisplay AutoComplete listNoneExcel 95Alt+'Format Style dialog boxFormat, StyleAllCtrl+Shift+~General formatFormat, Cells, Number, Category, GeneralAllCtrl+Shift+!Comma formatFormat, Cells, Number, Category, NumberAllCtrl+Shift+@Time formatFormat, Cells, Number, Category, TimeAllCtrl+Shift+#Date formatFormat, Cells, Number, Category, DateAllCtrl+Shift+$Currency formatFormat, Cells, Number, Category, CurrencyAllCtrl+Shift+%Percent formatFormat, Cells, Number, Category, PercentageAllCtrl+Shift+^Exponential formatFormat, Cells, Number, Category,AllCtrl+Shift+&Place outline border around selected cellsFormat, Cells, BorderAllCtrl+Shift+_Remove outline borderFormat, Cells, BorderAllCtrl+Shift+*Select current regionEdit, Goto, Special, Current RegionAllCtrl++InsertInsert, (Rows, Columns, or Cells) Depends on selectionAllCtrl+-DeleteDelete, (Rows, Columns, or Cells) Depends on selectionAllCtrl+1Format cells dialog boxFormat, CellsAllCtrl+2BoldFormat, Cells, Font, Font Style, BoldAllCtrl+3ItalicFormat, Cells, Font, Font Style, ItalicAllCtrl+4UnderlineFormat, Cells, Font, Font Style, UnderlineAllCtrl+5StrikethroughFormat, Cells, Font, Effects, StrikethroughAllCtrl+6Show/Hide objectsTools, Options, View, Objects, Show All/HideAllCtrl+7Show/Hide Standard toolbarView, Toolbars, StardardAllCtrl+8Toggle Outline symbolsNoneAllCtrl+9Hide rowsFormat, Row, HideAllCtrl+0Hide columnsFormat, Column, HideAllCtrl+Shift+(Unhide rowsFormat, Row, UnhideAllCtrl+Shift+)Unhide columnsFormat, Column, UnhideAllAlt or F10Activate the menuNoneAllCtrl+TabIn toolbar: next toolbarNoneExcel 97/2000 +Shift+Ctrl+TabIn toolbar: previous toolbarNoneExcel 97/2000 +Ctrl+TabIn a workbook: activate next workbookNoneExcel 97/2000 +Shift+Ctrl+TabIn a workbook: activate previous workbookNoneExcel 97/2000 +TabNext toolNoneExcel 97/2000 +Shift+TabPrevious toolNoneExcel 97/2000 +EnterDo the commandNoneExcel 97/2000 +Alt+EnterStart a new line in the same cell.NoneExcel 97/2000 +Ctrl+EnterFill the selected cell range with the current entry.NoneExcel 97/2000 +Shift+Ctrl+FFont Drop Down ListFormat, Cells, FontAllShift+Ctrl+F+FFont tab of Format Cell Dialog boxFormat, Cells, FontBefore 97/2000Shift+Ctrl+PPoint size Drop Down ListFormat, Cells, FontAll