Thursday, 16 January 2014

Microsoft Excel 2000 Keyboard Shortcuts

SHORTCUTACTION
SHFT+TABMove from right to left within the selection, or move up one cell if only one column is selected.
ALT+1Go to the previous folder; use within the Open and Save as dialog boxes (in File Menu).
ALT+2Open the folder one level up from the open folder (Up One Level button); use within the Open and Save As dialog boxes (in File menu).
ALT+3Close the open dialog box and opens your World Wide Web search page (Search the Web button); use when working in the Open and Save As dialog boxes.
ALT 4Delete the selected folder or file; use within the Open and Save As dialog boxes in Microsoft Excel.
ALT+5Create a new subfolder in the open folder; use within the Open and Save as dialog boxes.
ALT+6Switch between List, Details, Properties, and Preview views (click the arrow next to Views); use within the Open and Save As dialog boxes.
ALT+7Display the Tools menu; use within the Open and Save As dialog boxes.
ALT+BOpen the Address book in the BCC field; use when sending E-Mail.
ALT+COpen the Address Book while working in the CC field when sending E-Mail.
ALT JGo to Subject field when sending E-Mail in Microsoft Excel.
ALT+KCheck the names in the To, Cc and Bcc fields against the Address Book while sending an E-Mail.
ALT+POpen Microsoft Outlook Message Options dialog box when sending an E-Mail.
ALT+PERIODOpen the Address book while working in the To field when sending E-Mail.
ALT+SSend the active spreadsheet as an E-Mail message.
CTRL+SHFT+BOpen the Address Book when sending an E-Mail.
CTRL+SHFT+GCreate a message flag when sending an E-Mail.
SHFT+TABMove to an E-Mail header- cell A-1 must be the active cell when you press these keys.
= (EQUAL SIGN)Start a formula; works within a cell or formula bar.
ALTClose the visible menu and submenu at the same time; works with menu commands.
ALT+' (APOSTROPHE)Display the Style command (on Format menu); works in a spreadsheet.
ALT+ letter key, where key is the underlined letter in the field or menu cmndSelect a field or a menu; works within a spreadsheet in Microsoft Excel.
ALT+ letter key, where key is the underlined letter in the field or menu cmndSelect a menu, or select or clear a check box by the letter underlined in the menu command; works with dialog boxes.
ALT+ number (where hitting key for 1 selects the leftmost optn, 2 the next, and so on)Select an option in the Open or Save As dialog boxes (in File menu); works with windows and dialog boxes.
ALT+= (EQUAL SIGN)Insert the AutoSum formula; works within a cell or formula bar of a spreadsheet.
ALT+0(ZERO)Select the folder list in the Open and Save As dialog boxes (in File menu); use within a dialog box; use arrow keys to select a folder in the list.
CTRL SHFT PLUS SIGNInsert blank cells into a row or column in Microsoft Excel.
CTRL+SHFT+RIGHT ARROWSelect or unselect one word to the right of the cursor.
CTRL+SHFT+SPACEBARWith an object already selected, select all objects on a sheet.
CTRL+SHFT+TAB or CTRL+PAGE UPGo to the previous tab when working in a tabbed dialog box.
ALT+CMove the selected field into the Column area; Use within the Pivot Table Wizard.
ALT+DMove a selected field into the Data area; use when working within the Pivot Table Wizard.
ALT+DOWN ARROWDisplay the AutoComplete list when working within a cell or formula bar.
ALT+DOWN ARROWOpen a selected drop-down menu; works within a dialog box.
ALT+DOWN ARROWDisplay more Help topics; works when using Office Assistant.
ALT+ENTERStart a new line in the same cell while working in a cell or formula bar.
ALT LDisplay Pivot Table dialog box in Microsoft Excel.
ALT+PMove a selected field into the Page area when working with the Pivot Table Wizard.
ALT+PAGE DOWNDisplay next screen to the right while working in a worksheet or workbook.
ALT+PAGE UPDisplay previous screen to the left while working in a worksheet or workbook.
ALT+RMove a selected field into the Row area while working within the Pivot Table Wizard.
ALT SEMICOLONSelect only visible cells in the active window in Microsoft Excel.
ALT+SHFT+LEFT ARROWUngroup selected Pivot Table items while working with Pivot Table.
ALT+SHFT+LEFT ARROWUngroup rows or columns in an outlined spreadsheet.
ALT+SHFT+RIGHT ARROWGroup selected Pivot Table items while working within a Pivot Table.
ALT+SHFT+RIGHT ARROWGroup rows or columns while working within a worksheet or workbook.
ALT SHFT TABMove from active application window to previously active application window in Microsoft Excel.
ALT+SPACEBAROpen the menu of the leftmost icon on the main toolbar bar of the active window; this menu typically contains the following commands: Restore, Move, Size, Minimize, Maximize and Close.
ALT+TABMove from active application window to the previously used application window; to select an application from a list of the open applications, hold ALT down and press TAB more than once to move through the list.
ALT+number (where hitting key for 1 selects the leftmost optn, 2 the next, and so on)Select a Help topic while using Office Assistant.
ALT+UP ARROWClose the Auto Filter list for the current column.
ALT+UP ARROWDisplay previously viewed Help topics while using Office Assistant.
ARROW KEYMove one cell in the given direction of the arrow key when working in a worksheet or workbook.
ARROW KEYMove one cell in the given direction of the arrow key when working in a worksheet or workbook.
ARROW KEYMove around a document while in Print Preview and zoomed in.
ARROW KEYMove between options in a selected drop-down menu or dialog box or between some options in a group of options.
ARROW KEYMove between options in a selected drop-down menu or dialog box or between some options in a group of options; add ENTER to select an option.
BACKSPACEClear a selected cell or cells or to delete the character to the left of where the cursor is positioned within the active cell while editing.
CTRL+' (APOSTROPHE)Copy a formula from the cell above the active cell into the active cell or formula bar while working within a worksheet or workbook.
CTRL arrow keyMove cursor to an edge of the current data region in Microsoft Excel.
CTRL+/Select the current array, which is the array that the active cell belongs to.
CTRL+; (SEMI COLON)Enter the date where the cursor is positioned within an active cell.
CTRL+[Select only cells that are directly referred to by formulas in the specified area of a worksheet or workbook.
CTRL+\Select cells whose contents are different from the comparison cell in each row (for each row, the comparison cell is in the same column as the active cell).
CTRL+]Select only cells with formulas that refer directly to the active cell.
CTRL+` (SINGLE LEFT QUOTATION MARKAlternate view between displaying cell values and displaying cell formulas.
CTRL+0 (ZERO)Hide, or collapse, selected column(s) within a worksheet or workbook.
CTRL+1Display the Cells dialog box (in Format menu) when working in a worksheet or workbook.
CTRL+5Apply or remove strikethrough formatting to a selected area of a worksheet or workbook.
CTRL+6Alternate view between hiding, displaying and displaying placeholders for selected objects.
CTRL 7Display or hide the main toolbar of the active window in Microsoft Excel.
CTRL+8Display or hide outline symbols of an active worksheet or workbook with an outline.
CTRL+9Hide selected rows within an active worksheet or workbook.
CTRL+ADisplay Formula Palette after you type a valid function name in a formula bar.
CTRL+ASelect the entire active worksheet.
CTRL+ALT+LEFT ARROWMove to the left between nonadjacent selections within a worksheet or workbook.
CTRL+ALT+RIGHT ARROWMove to the right between nonadjacent selections in a worksheet or workbook.
CTRL+BApply or remove Bold formatting to selected text within a cell, worksheet or workbook.
CTRL BACKSPACEScroll to display the active cell in Microsoft Excel.
CTRL+CCopy selected text or area to Windows Clipboard.
CTRL+DEnter data from cell just above active cell into active cell (Fill down) on a worksheet or workbook.
CTRL+DELETEDelete text to the end of the line in which the cursor is positioned.
CTRL+DOWN ARROW or CTRL+RIGHT ARROWMove to the last page in a spreadsheet, worksheet or workbook when zoomed out while in Print Preview.
CTRL+ENDMove to the end of the current sheet of a worksheet or workbook.
CTRL+ENDMove to the last cell on the worksheet, which is the cell at the intersection of the right-most active column and the bottom-most active row (in the lower-right corner).
CTRL ENTERFill the selected range with the current cell's contents while working in a worksheet or workbook in Microsoft Excel.
CTRL+ESCDisplay Windows Start menu.
CTRL+F10Maximize or restore the active worksheet or workbook window.
CTRL+F5Restore the active workbook window.
CTRL+F6Go to the next workbook window in the active application.
CTRL+F6 or CTRL+TABMove to the next worksheet, workbook or window.
CTRL+F7Carry out the Move command (under Workbook icon menu, menu bar).
CTRL+F8Carry out the Size command (under Workbook icon menu, menu bar).
CTRL F9Minimize the active workbook window in Microsoft Excel.
CTRL+HOMEGo to the beginning of the active worksheet.
CTRL+IApply or remove italic formatting to selected characters.
CTRL+KInsert a hyperlink from a document to a specified Web page address.
CTRL+LEFT ARROW or CTRL+RIGHT ARROWMove cursor's position one word to the left or right.
CTRL+PDisplay the Print dialog box in order to print the active selection.
CTRL+PAGE DOWNMove cursor's position to the top of the next sheet in the workbook.
CTRL PAGE DOWNMove cursor's position to the beginning of a new record in Microsoft Excel.
CTRL+PAGE UPMove cursor's position to the top of the previous sheet in the workbook.
CTRL+PAGE UPGo to the first record in the worksheet.
CTRL+PERIODMove cursor's position clockwise to the next corner of the selection.
CTRL+RFill cells to the right of the active cell with the content from the active cell.
CTRL+SHFT+ arrow keyExtend the active selection to the last nonblank cell in the same column or row as the active cell.
CTRL+SHFT+!Apply the Number format with two decimal places, 1000 separator, and - for negative values.
CTRL+SHFT+ (QUOTATION MARK)Copy the value from the cell above the active cell into the active cell or the formula bar.
CTRL+SHFT+#Apply the Date format with the day, month and year into the active cell.
CTRL+SHFT+$Apply a currency format with two decimal places in the active cell (negative numbers appear in parentheses).
CTRL+SHFT+%Apply the Percentage format with no decimal places into the active cell.
CTRL SHFT
CTRL+SHFT+(Unhide selected rows in worksheet.
CTRL+SHFT+)Unhide selected columns in worksheet.
CTRL+SHFT+* (ASTERISK)Select the current region around the active cell (the current region is an area enclosed by blank rows and blank columns).
CTRL+SHFT+: (COLON)Enter the current time, including hour, minute and A.M. or P.M., into active cell.
CTRL+SHFT+@Apply the Time format with the hour and minute, and indicate A.M. or P.M.
CTRL+SHFT+^Apply the Exponential number format with two decimal places into active cell.
CTRL SHFT _Remove all borders from a selected area in Microsoft Excel.
CTRL+SHFT+{Select all cells that are directly or indirectly referred to by formulas in a selected area.
CTRL+SHFT+|Select cells in a given area whose contents are different from the comparison cell in each column (for each column, the comparison cell is in the same row as the active cell).
CTRL+SHFT+}Select all cells with formulas that refer directly or indirectly to the active cell.
CTRL+SHFT+~Apply the General number format to the active cell.
CTRL+SHFT+AInsert the argument names and parentheses for a function, after you type a valid function name in a formula.
CTRL+SHFT+ENDExtend a selection to the last cell used on the worksheet (lower-right corner).
CTRL+SHFT+ENTEREnter a formula as an array formula into the active cell.
CTRL SHFT F6Go to the previous workbook window in Microsoft Excel.
CTRL+SHFT+F6 or CTRL+SHFT+TABGo to the previous workbook window.
CTRL+SHFT+HOMEExtend the selection to the beginning of the worksheet.
CTRL+SHFT+LEFT ARROWSelect or unselect one word to the left of the cursor.
CTRL+SHFT+O (the letter O)Select all cells with comments.
CTRL+SPACEBARSelect the entire active column.
CTRL+TAB or CTRL+PAGE DOWNMove to the next tab on a tabbed dialog box.
CTRL TAB or CTRL SHFT TABSelect the next or previous toolbar in Microsoft Excel.
CTRL+UApply or remove Underline formatting to selected text.
CTRL+UP ARROW or CTRL+LEFT ARROWMove to the first page when zoomed out in Print Preview.
CTRL+VPaste a copied item(s) from the Clipboard into a selected location (You also can choose Paste from the Edit menu.).
CTRL+WClose the active workbook window.
CTRL+XCopy and remove the selected item(s) from their original location to the Clipboard. (You also can choose the Cut command from the Edit menu.).
CTRL+YRedo, or repeat, the previous action.
CTRL+ZUndo the last action; note: some actions, like Shutdown, cannot be undone (You also can choose Undo from the Edit menu.).
DELETEDelete the selected item(s), or to delete the character to the right of the cursor; if items are files they will be moved to the Recycle Bin.
DOWN ARROWSelect the previous group of chart items in Microsoft Excel.
DOWN ARROWMove to the same field in the next record.
DOWN ARROWSelect the next item in the AutoFilter list.
DOWN ARROWSelect the next item in a list when working with page fields in a Pivot Table.
DOWN ARROW or UP ARROW (with the menu or submenu displayed)Select the next or previous command on the menu or submenu.
ENDGo to the end of the line.
ENDTurn End mode on or off in Excel.
ENDGo to the cell in the lower-right corner of the window.
ENDSelect the last item in the AutoFilter list in Microsoft Excel.
ENDSelect the last visible item in the list when working in a Pivot Table.
ENDGo to the end of the entry.
END, arrow keyScroll, within a row or column, one block of data in the direction of the arrow key.
END, ENTERMove to the last cell to the right that is not blank in the current row; unavailable if you have selected the Transition navigation keys check box on the Transition tab.
END, HOMEMove to the last cell on the worksheet, which is the cell at the intersection of the right-most used column and the bottom-most used row (in the lower-right corner); cell opposite the Home cell, which is typically A1.
ENTERComplete a cell entry and move down in the selection.
ENTERMove to the first field in the next record when working in Excel data form.
ENTERFilter a list by selecting an item from AutoFilter list (Under Tools menu, Filter submenu).
ENTERDisplay the selected item when working with page fields in a Pivot Table.
ENTEROpen, or display, the selected menu on a toolbar in Microsoft Excel.
ENTERPerform the action assigned to a selected button on a toolbar.
ENTEREnter text in the selected text box in a toolbar.
ENTERPerform the action assigned to the selected default command button in a dialog box.
ENTERMove from top to bottom within the selection (down), or in the direction that is selected on the Edit tab (Tools menu, Options command).
ESCCancel an entry in the cell or formula bar.
ESCClose the visible menu, or, with a submenu visible, close the submenu only.
ESCClose a selected drop-down list in a dialog box.
ESCCancel a command and close the dialog box in Microsoft Excel.
ESCClose an Office Assistant message or tip.
F1Display Help or the Office Assistant.
F1+ALTInsert a chart sheet into a worksheet or workbook.
F1+ALT+SHFTInsert a new worksheet into a workbook.
F1+SHFTOpen Office Assistant in order to display context sensitive Help or to reveal formatting of selected characters.
F10Activate, or select, the main toolbar beginning with the first toolbar option on the left, usually File; after the first option is activated you can navigate through toolbar and menu options using the appropriate ARROW keys; press F10 or ALT again
F10 or ALTActivate, or select, the main toolbar beginning with the first toolbar option on the left, usually File; after the first option is activated you can navigate through toolbar and menu options using the appropriate ARROW keys; press F10 or ALT again
CTRL+F10Maximize or restore the workbook window.
F10 SHFTDisplay a shortcut menu in Microsoft Excel.
F11Create a chart.
F11 ALTDisplay Visual Basic Editor in Microsoft Excel.
CTRL+F11Insert a Microsoft Excel 4.0 macro sheet.
F11+SHFTInsert a new worksheet into a workbook.
F12Display Save As dialog box (file menu).
CTRL F12Display Open dialog box (File menu) in Microsoft Excel.
CTRL+SHFT+F12Display Print command (File menu).
F12+SHFTCarry out Save command (File menu).
F2Edit the active cell.
F2+ALTDisplay Save As dialog box (file menu).
F2+ALT+SHFTCarry out the Save command (File menu).
F2+SHFTEdit a cell comment.
F3Paste a name into a formula in Microsoft Excel.
CTRL+F3Define a name.
CTRL+SHFT+F3Create names by using row and column labels.
F3+SHFTPaste a function into a formula.
F4Repeat the last action in Microsoft Excel.
F4+ALTQuit Excel.
CTRL+F4Close the active window.
F4+SHFTRepeat the last Find (find next) command.
F5+Display the Go To tab on the Find and Replace dialog box (Edit menu).
CTRL+F5Restore the program window size.
F5+SHFTDisplay the Find dialog box.
F6Go to the next pane in Microsoft Excel.
CTRL+F6Move to the next open workbook window.
CTRL+SHFT+F6Go to the previous open workbook window.
F6+SHFTGo to the previous open workbook window.
F7Display Spelling and Grammar dialog box (Tools Menu).
CTRL+F7Move the window.
F8Turn Extend mode on, which allows you to select as much of a worksheet or workbook as you want; press ESC to cancel.
F8+ALTDisplay the Macro dialog box.
CTRL F8Resize the active window (document Control menu) in Microsoft Excel.
F8+SHFTIncrease the size of selected area.
F9Calculate all sheets in all open workbooks.
CTRL+F9Minimize the active workbook.
F9+SHFTCalculate the active worksheet.
HOMEGo to the beginning of the current line.
HOMEMove to the beginning of the current row in Microsoft Excel.
HOMEGo to the cell in the upper-left corner of the worksheet.
HOMESelect the first item (All) in the AutoFilter list, with Auto filter list open.
HOMESelect the first visible item in a list.
HOMEMove to the beginning of the current entry.
HOME or ENDGo to the beginning or end of the current field.
HOME or ENDSelect the first or last command on the menu or submenu in Microsoft Excel.
LEFT ARROWSelect the previous item within the current group on a chart.
LEFT ARROW or RIGHT ARROWWith scroll lock on, scroll the current screen left or right one column.
LEFT ARROW or RIGHT ARROWIn a data form, move one character left or right within a field.
LEFT ARROW or RIGHT ARROWIn the Pivot Table wizard, move the field button to the right or left in a multicolumn field button list.
LEFT ARROW or RIGHT ARROWWith a menu open, select the menu to the left or right of the original, or, with a submenu visible, switch between the main menu and the submenu.
LEFT ARROW or RIGHT ARROWMove one character to the left or right in a text box.
Letter key, where the letter is the same as the first letter in optn you want on a selected menuChoose a selected menu, drop-down list, or dialog box option by typing the first letter in the option name.
PAGE DOWNScroll down one screen.
PAGE DOWNGo to the same field 10 records forward.
PAGE UPMove up one screen in Microsoft Excel.
PAGE UPMove to the same field 10 records back when working in Data Form view.
PAGE UP or PAGE DOWNIn Print Preview, move forward or back by one preview page when zoomed out.
RIGHT ARROWSelect the next item within the group on a chart.
SCROLL LOCKTurn SCROLL LOCK on or off.
Select the cell that contains the column label, and then press ALT+DOWN ARROWDisplay the AutoFilter list for the current column.
SHFT+ ARROW KEYExtend or reduce a selection by one cell.
SHFT+BACKSPACEIf multiple cells are selected, select only the active cell.
SHFT ENDWith scroll lock on, extend the selection to the cell in the lower-right corner of the window in Microsoft Excel.
SHFT+ENDUse when working in Data form to extend a selection to the end of a field.
SHFT+ENDSelect from the insertion point to the end of the text box entry.
SHFT+ENTERComplete a cell entry and move up in a selection.
SHFT+ENTERMove to the first field in the previous record when working in Data form.
SHFT+ENTERMove with in a selection from bottom to top within the selection (up), or opposite to the direction that is selected on the Edit tab (Tools menu, Options command).
SHFT+F10Display a shortcut menu that shows a list of commands relevant to the selected object.
SHFT F6Move to the previous pane in Microsoft Excel.
SHFT+HOMEExtend the selection from the cursor's position in the row to the beginning of the row.
SHFT+HOMEExtend a selection to the cell in the upper-left corner of the window.
SHFT+HOMEExtend a selection to the beginning of a field.
SHFT+HOMESelect from the insertion point in the text box to the beginning of the text box entry.
SHFT+LEFT ARROWSelect or unselect one character to the left of the cursor's position.
SHFT PAGE DOWNExtend the selection one screen down in Microsoft Excel.
SHFT+PAGE UPExtend the selection one screen up.
SHFT+RIGHT ARROWSelect or unselect by one character to the right of the cursor's current position.
SHFT+SPACEBARSelect an entire row.
SHFT+TABComplete a cell entry and move to the left in the selection.
SHFT+TABMove to the previous option or option group in a dialog box.
SHFT+TABMove to the previous field you can edit in the selected record when working in data form.
SPACEBARPerform the action assigned to the active button, or select or clear the active check box in the dialog box.
TABComplete a cell entry and move to the right in the selection.
TABMove from left to right within a selection, or move down one cell if only one column is selected.
TABMove between unlocked cells on a protected worksheet in Microsoft Excel.
TABMove to the next field you can edit in the record.
TABMove to the next option or option group in a dialog box.
TAB or SHFT+TAB (when a toolbar is active)When a toolbar is active, select the next or previous button or menu on the toolbar.
UP ARROWSelect the next group of items in a chart in Microsoft Excel.
UP ARROWMove to the same field in the previous record when working in data form.
UP ARROWSelect the previous item in the AutoFilter list.
UP ARROWUse with page fields in a Pivot Table to select the previous item in the list.
UP ARROW or DOWN ARROWUse with Scroll Lock to scroll the screen up or down one row in Microsoft Excel.
UP ARROW or DOWN ARROWIn the Pivot Table Wizard, select the next or previous field button in the list.