Thursday, 16 January 2014

Microsoft Excel 2001 (Mac) Keyboard Shortcuts

SHORTCUTACTION
Editing data
CTRL+UEdit the active cell
ESCCancel an entry in the cell or formula bar
DELETEClear or edit the active cell. When you are editing a cell, delete the character to the left of the insertion point.
CMD+VPaste text into the active cell
RETURNComplete a cell entry
CMD+SHFT+RETURN or CTRL+SHFT+RETURNEnter a formula as an array formula
CTRL+ADisplay the Formula Palette after you type a valid function name in a formula
CTRL+SHFT+AInsert the argument names and parentheses for a function, after you type a valid function name in a formula
Entering data on a worksheet
RETURNComplete a cell entry and move down in the selection, or move in the direction that is selected on the Edit tab (Edit menu, Preferences command)
CTRL+OPTN+RETURNStart a new line in the same cell
CTRL+RETURNFill the selected cell range with the text that you type (works on nonadjacent selections)
SHFT+RETURNComplete a cell entry and move up in the selection, or move opposite to the direction that is selected on the Edit tab (Edit menu, Preferences command)
TABComplete a cell entry and move to the right in the selection, or move in the direction that is selected on the Edit tab (Edit menu, Preferences command)
SHFT+TABComplete a cell entry and move to the left in the selection, or move opposite to the direction that is selected on the Edit tab (Edit menu, Preferences command)
ESCCancel a cell entry
DELETEDelete the character to the left of the insertion point, or delete and edit the active cell
DELDelete the character to the right of the insertion point, or delete the selection
CTRL+DELDelete text from the insertion point to the end of the line
HOMEMove to the beginning of the line
CMD+YRepeat the last action
SHFT+F2Edit a cell comment
CTRL+SHFT+F3Create names from row and column labels
CTRL+D or CTRL+SHFT+< (less than sign)Fill down
CTRL+R or CTRL+SHFT+> (greater than sign)Fill to the right
CTRL+F3 or CTRL+LDefine a name
Formatting data
CMD+SHFT+LDisplay the Style dialog box
CMD+1Display the Format Cells dialog box
CTRL+SHFT+~Apply the General number format
CTRL+SHFT+$Apply the Currency format with two decimal places (negative numbers appear in parentheses)
CTRL+SHFT+%Apply the Percentage format with no decimal places
CTRL+SHFT+^Apply the Exponential number format with two decimal places
CTRL+SHFT+#Apply the Date format with the day, month, and year
CTRL+SHFT+@Apply the Time format with the hour and minute, and indicate A.M. or P.M.
CTRL+SHFT+!Apply the Number format with two decimal places, thousands separator, and minus sign (-) for negative values
CMD+OPTN+0 (zero)Apply the outline border
CMD+OPTN+HYPHENRemove outline borders
CMD+OPTN+RIGHT ARROWApply or remove right border
CMD+OPTN+LEFT ARROWApply or remove left border
CMD+OPTN+UP ARROWApply or remove top border
CMD+OPTN+DOWN ARROWApply or remove bottom border
CMD+BApply or remove bold formatting
CMD+IApply or remove italic formatting
CMD+UApply or remove an underline
CMD+SHFT+UNDERLINEApply or remove strikethrough formatting
CMD+SHFT+> (greater than sign)Increase font size
CMD+SHFT+< (less than sign)Decrease font size
CMD+EAlign center
CMD+LAlign left
CMD+RAlign right
CMD+MIndent
CMD+SHFT+MRemove indent
CTRL+9Hide rows
CTRL+SHFT+( (opening parenthesis)Unhide rows
CTRL+0 (zero)Hide columns
CTRL+SHFT+) (closing parenthesis)Unhide columns
CMD+SHFT+WAdd or remove shadow on text
CMD+SHFT+DAdd or remove outline on text
Inserting, deleting, and copying a selection
CMD+C or CTRL+CCopy the selection
CMD+X or CTRL+XCut the selection
CMD+V or CTRL+VPaste the selection
DELETEClear or edit the active cell. When you are editing a cell, delete the character to the left of the insertion point.
CTRL+HYPHEN or CTRL+KDelete the selection
CMD+ZUndo the last action
CMD+YRepeat the last action
CTRL+I or CTRL+SHFT+PLUS SIGNInsert blank cells
Selecting cells that have special characteristics
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+/Select the current array, which is the array that the active cell belongs to
CMD+SHFT+O (the letter O)Select all cells with comments
CTRL+\In a selected row, or a selection within a row, select cells that don't match the value in the active cell.
CTRL+SHFT+|In a selected column, or a selection within a column, select cells that don't match the value in the active cell.
CTRL+[Select only cells that are directly referred to by formulas in the selection
CTRL+SHFT+{Select all cells that are directly or indirectly referred to by formulas in the selection
CTRL+]Select only cells with formulas that refer directly to the active cell
CTRL+SHFT+}Select all cells with formulas that refer directly or indirectly to the active cell
CMD+SHFT+ZSelect only visible cells in the current selection
Selecting cells, columns, or rows
CTRL+SHFT+* (asterisk)Select the current region around the active cell (the current region is an area enclosed by blank rows and blank columns)
SHFT+arrow keyExtend the selection by one cell
CTRL+SHFT+arrow keyExtend the selection to the last nonblank cell in the same column or row as the active cell
SHFT+HOMEExtend the selection to the beginning of the row
CTRL+SHFT+HOMEExtend the selection to the beginning of the worksheet
CTRL+SHFT+ENDExtend the selection to the last cell used on the worksheet (lower-right corner)
CTRL+SPACEBARSelect the entire column
SHFT+SPACEBARSelect the entire row
CMD+A or CTRL+SHFT+SPACEBARSelect the entire worksheet, or, if an object is selected, all the objects on a worksheet
SHFT+DELETESelect only the active cell when multiple cells are selected
SHFT+PAGE DOWNExtend the selection down one screen
SHFT+PAGE UPExtend the selection up one screen
CTRL+6For chart objects: Alternate between hiding objects, displaying objects, and displaying placeholders for objects. For drawing objects: Alternate between hiding objects and displaying objects.
CTRL+7Show or hide the Standard toolbar
F8Turn on extending a selection by using the arrow keys
SHFT+F8Add another range of cells to the selection; or use the arrow keys to move to the start of the range you want to add, and then press F8 and the arrow keys to select the next range
Working in cells or the formula bar
DELETEClear or edit the active cell. When you are editing a cell, delete the character to the left of the insertion point.
RETURNComplete a cell entry and move down in the selection, or move in the direction that is selected on the Edit tab (Edit menu, Preferences command)
ESCCancel an entry in the cell or formula bar
CTRL+BClear the selected cell's contents
CTRL+SHFT+RETURN or CMD+SHFT+RETURNEnter a formula as an array formula
CTRL+ADisplay the Formula Palette after you type a valid function name in a formula
CTRL+SHFT+AInsert the argument names and parentheses for a function, after you type a valid function name in a formula
CMD+KInsert a hyperlink
RETURNActivate a hyperlink (in a cell with a hyperlink)
CTRL+UEdit the active cell and position the insertion point at the end of the line
SHFT+F3Paste a function into a formula
CMD+= (equal sign) or F9Calculate all sheets in all open workbooks
SHFT+F9Calculate the active worksheet
= (equal sign)Start a formula
CMD+SHFT+TInsert the AutoSum formula
CTRL+; (semicolon)Enter the date
CMD+; (semicolon) or CMD+SHFT+: (colon) or CTRL+SHFT+: (colon)Enter the time
CMD+SHFT+ (quotation mark) or CTRL+SHFT+ (quotation mark)Copy the value from the cell above the active cell into the cell or the formula bar
CTRL+` (single left quotation mark)Alternate between displaying cell values and displaying cell formulas
CMD+' (apostrophe) or CTRL+' (apostrophe)Copy a formula from the cell above the active cell into the cell or the formula bar
OPTN+DOWN ARROWDisplay the AutoComplete list
CTRL+F3Define a name
Using AutoFilter
OPTN+DOWN ARROWDisplay the AutoFilter list for the current column (Select the cell that contains the column label, and then press )
DOWN ARROWSelect the next item in the AutoFilter list
UP ARROWSelect the previous item in the AutoFilter list
HOMESelect the first item (Sort Ascending) in the AutoFilter list
ENDSelect the last item in the AutoFilter list
RETURNFilter the list by using the selected item in the AutoFilter list
Outlining data
CTRL+8Display or hide outline symbols
CTRL+9Hide selected rows
CTRL+SHFT+( (opening parenthesis)Unhide selected rows
CTRL+0 (zero)Hide selected columns
CTRL+SHFT+) (closing parenthesis)Unhide selected columns
Moving and scrolling in a worksheet or workbook
CTRL+arrow keyMove to the edge of the current data region
HOMEMove to the beginning of the row
CTRL+HOMEMove to the beginning of the worksheet
CTRL+ENDMove to the last cell on the worksheet, which is the cell at the intersection of the rightmost used column and the bottom-most used row (in the lower-right corner); or the cell opposite the home cell, which is typically A1
PAGE DOWNMove down one screen
PAGE UPMove up one screen
OPTN+PAGE DOWNMove one screen to the right
OPTN+PAGE UPMove one screen to the left
CTRL+PAGE DOWNMove to the next sheet in the workbook
CTRL+PAGE UPMove to the previous sheet in the workbook
CTRL+TABMove to the next workbook or window
CTRL+SHFT+TABMove to the previous workbook or window
F6Move to the next pane in a workbook that has been split
SHFT+F6Move to the previous pane in a workbook that has been split
CMD+DELETE or CTRL+DELETEScroll to display the active cell
CTRL+GDisplay the Go To dialog box
CMD+FDisplay the Find dialog box
CMD+GRepeat the last Find action (same as Find Next), or, if no Find has been performed, move to the next blank cell
CMD+SHFT+GRepeat the last Find action, or, if no Find has been performed, move to the previous blank cell
CMD+HDisplay the Replace dialog box (Edit menu)
TABMove between unlocked cells on a protected worksheet
Moving within a selection
RETURNMove from top to bottom within the selection (down), and then move to the top of the next column. Or move in the direction that is selected on the Edit tab (Edit menu, Preferences command)
SHFT+RETURNMove from bottom to top within the selection (up), and then move to the bottom of the next column. Or move opposite to the direction that is selected on the Edit tab (Edit menu, Preferences command)
TABMove from left to right within the selection, and then move to the next row. Or move down one cell if only one column is selected
SHFT+TABMove from right to left within the selection, and then move to the previous row. Or move up one cell if only one column is selected
CTRL+PERIODMove clockwise to the next corner of the selection (does not move to nonadjacent selections)
CTRL+OPTN+RIGHT ARROWMove to the right among nonadjacent selections
CTRL+OPTN+LEFT ARROWMove to the left among nonadjacent selections
Using toolbars
OPTN+F10Make a toolbar active
TABSelect the next button or menu on the toolbar (when a toolbar is active)
SHFT+TABSelect the previous button or menu on the toolbar (when a toolbar is active)
CTRL+TABSelect the next toolbar (when a toolbar is active)
CTRL+SHFT+TABSelect the previous toolbar (when a toolbar is active)
RETURNPerform the action assigned to the selected button
Working with windows
CMD+TABSwitch to the next program
CMD+SHFT+TABSwitch to the previous program
CMD+WClose the active workbook window
CMD+F5Restore the active workbook window size
F6Move to the next pane in a workbook that has been split
SHFT+F6Move to the previous pane in a workbook that has been split
CMD+F6Switch to the next workbook window
CMD+SHFT+F6Switch to the previous workbook window
CTRL+F5Restore the window size
CTRL+F10Maximize or restore the workbook window
Working with dialog boxes
TABMove to the next text box
SHFT+TABMove to the previous text box
CTRL+TAB or CTRL+PAGE DOWNSwitch to the next tab in a dialog box
CTRL+SHFT+TAB or CTRL+PAGE UPSwitch to the previous tab in a dialog box
RETURNPerform the action assigned to the default command button in the dialog box (the button with the bold outline -- often the OK button)
ESCCancel the command and close the dialog box
Opening, closing, and saving workbooks
CMD+N or CTRL+NCreate a new workbook
CMD+O or CTRL+OOpen an existing workbook
CMD+S or CTRL+SSave the current workbook
CMD+QQuit Excel
Previewing and printing a document
CMD+PDisplay the Print dialog box
Arrow keysMove around the page when zoomed in
PAGE UP or PAGE DOWNMove by one page when zoomed out
CTRL+UP ARROW or CTRL+LEFT ARROWMove to the first page when zoomed out
CTRL+DOWN ARROW or CTRL+RIGHT ARROWMove to the last page when zoomed out
Working with a data form
DOWN ARROWMove to the same field in the next record
UP ARROWMove to the same field in the previous record
TABMove to the next field you can edit in the record
SHFT+TABMove to the previous field you can edit in the record
RETURNMove to the first field in the next record
SHFT+RETURNMove to the first field in the previous record
PAGE DOWNMove to the same field 10 records forward
CTRL+PAGE DOWNMove to a new record
PAGE UPMove to the same field 10 records back
CTRL+PAGE UPMove to the first record
HOMEMove to the beginning of a field
ENDMove to the end of a field
SHFT+ENDExtend a selection to the end of a field
SHFT+HOMEExtend a selection to the beginning of a field
LEFT ARROWMove one character left within a field
RIGHT ARROWMove one character right within a field
SHFT+LEFT ARROWSelect the character to the left
SHFT+RIGHT ARROWSelect the character to the right
Working with Charts
F11Create a chart
Arrow keysCycle through chart object selection
CTRL+6Alternate between hiding chart objects, displaying chart objects, and displaying placeholders for chart objects
Working with PivotTables
CMD+CMove the selected field into the Column area in the Layout dialog box in step 3 of the PivotTable Wizard
CMD+DMove the selected field into the Data area in the Layout dialog box in step 3 of the PivotTable Wizard
CMD+LDisplay the PivotTable Field dialog box from the Layout dialog box in step 3 of the PivotTable Wizard
CMD+PMove the selected field into the Page area in the Layout dialog box in step 3 of the PivotTable Wizard
CMD+RMove the selected field into the Row area in the Layout dialog box in step 3 of the PivotTable Wizard
Using function keys in Excel
F1Undo command
SHFT+F1What's This? command
F2Cut text from the active cell
SHFT+F2Edit a cell comment
F3Copy text from the active cell
SHFT+F3Paste a function into a formula
CTRL+F3Define a name
CTRL+SHFT+F3Create names by using row and column labels
F4Paste text into the active cell
SHFT+F4Repeat the last Find (Find Next) action
CTRL+F4Close the window
F5Go To command
SHFT+F5Display the Find dialog box
CTRL+F5Restore the window size
F6Move to the next pane
SHFT+F6Move to the previous pane
CTRL+F6Move to the next workbook window
CTRL+SHFT+F6Move to the previous workbook window
F7Spelling command
F8Extend a selection
SHFT+F8Add to the selection
OPTN+F8Display the Macro dialog box
SHFT+F9Calculate the active worksheet
SHFT+F10Display a contextual menu
CTRL+F10Maximize or restore the workbook window
OPTN+F10Make toolbar active
F11Create a chart
SHFT+F11Insert a new worksheet
CTRL+F11Insert a Microsoft Excel 4.0 macro sheet
OPTN+F11Display Visual Basic Editor
F12Save As command
SHFT+F12Save command
CTRL+F12Open command
CTRL+SHFT+F12Print command