Copy selected text [CTRL][C] Paste selected text [CTRL][V] Cut selected text [CTRL][X] Delete selected text [DEL] Delete selected text [CTRL][-] Undo the last action [CTRL][Z] Insert blank cells [CTRL][SHIFT][+] Activate cell and formula bar [F2] Carry out an action [ENTER] Cancel an action [ESC] Repeat the last action [F4] Start a new line in the same cell [CTRL][ENTER] Clear the formula bar [BACKSPACE] Edit a cell note [SHIFT][F2] Paste a name into a formula [F3] Display the Formula Wizard [CTRL][A] Insert argument names [CTRL][SHIFT][A] Define a name [CTRL][F3] Create names from cell text [CTRL][SHIFT][F3] Calculate all sheets in all open workbooks [F9] Calculate all sheets in all open workbooks [CTRL][I] Calculate the active sheet [SHIFT][F9] Insert AutoSum formula [ALT][I] Insert date [CTRL][;] Insert time [CTRL][MOUSE RIGHT] Fill down [CTRL][D] Fill right [CTRL][R] Move down through a selection [ENTER] Move up through a selection [SHIFT][ENTER] Move right through a selection [TAB] Move left through a selection [SHIFT][TAB] Display the style dialog box [ALT][_] Apply general number format [CTRL][SHIFT][~] Apply currency format [CTRL][SHIFT][$] Apply percentage format [CTRL][SHIFT][%] Apply exponential number format [CTRL][SHIFT][^] Apply date format with day:month:year [CTRL][SHIFT][#] Apply time format with hour:minute [CTRL][SHIFT][@] Apply two-decimal-place format [CTRL][SHIFT][!] Apply outline border [CTRL][SHIFT][&] Remove all borders [CTRL][SHIFT][_] Apply or remove bold [CTRL][B] Apply or remove italic [CTRL][I] Apply or remove underline [CTRL][U] Apply or remove strikethrough [CTRL][F5] Hide rows [CTRL][F9] Unhide rows [CTRL][SHIFT][(] Hide columns [CTRL][0] Unhide columns [CTRL][SHIFT][)]
Get online help [F1] Insert a new worksheet [F1][ALT][SHIFT] Activate a cell [F2] Edit a cell note [F2][SHIFT] Display the info window [F2][CTRL] Paste a name into a formula [F3] Display the Function Wizard [F3][SHIFT] Define a name [F3][CTRL] Create names from cell text [CTRL][SHIFT][F3] Repeat last action [F4] Repeat a Find or Go To action [F4][SHIFT] Close an open window [F4][CTRL] Execute the Go To command [F5] Execute the Find command [F5][SHIFT] Restore the window size [F5][CTRL] Go to the next pane [F6] Go to the previous pane [F6][SHIFT] Go to the next workbook [F6][CTRL] Go to the previous workbook [F6][CTRL][SHIFT] Perform a spelling check [F7] Perform the Move command [F7][CTRL] Extend a selection [F8] Shrink a selection [F8][SHIFT] Perform the Size command [F8][CTRL] Calculate all sheets in all open workbooks [F9] Calculate the active spreadsheet [F9][SHIFT] Minimize the workbook [F9][CTRL] Activate the menu bar [F10] Display a shortcut menu [F10][SHIFT] Maximize the document window [F10][CTRL] Create a chart [F11] Save file under another name, Save As [F12] Save file [F12][SHIFT] Open file [F12][CTRL] Print file [F12][CTRL][SHIFT]
Go one page to the left [CTRL][LEFT ARROW] Go one page to the left [SHIFT][TAB] Go one page to the right [CTRL][RIGHT ARROW] Go one page to the right [TAB] Go to next sheet in workbook [CTRL][PG UP] Go to previous sheet in workbook [CTRL][PG DN] Go to the cell in the upper-left corner [HOME] Go to previous field in the current record [LEFT ARROW] Go to next field in the current record [RIGHT ARROW] Go to the first record [HOME] Go to the last record [END] Align data to the left ['] Align data to the right ["] Center data within a cell [^] Repeat characters across a cell [\]
Select a field [ALT] character underlined in name Go to same field in next record [DOWN ARROW] Go to same field in previous record [UP ARROW] Go to next editable field [TAB] Go to previous editable field [SHIFT][TAB] Go to first field in next record [ENTER] Go to first field in previous record [SHIFT][ENTER] Go to same field ten records forward [PG DN] Go to same field ten records back [PG UP] Go to a new record [CTRL][PG DN] Go to the first record [CTRL][PG UP] Go to beginning of a field [HOME] Go to end of a field [END] Go one character to the left in a field [LEFT ARROW] Go one character to the right in a field [RIGHT ARROW] Extend the selection to the beginning of a field [SHIFT][HOME] Extend the selection to the end of a field [SHIFT][END] Select a character to the left [SHIFT][A] Select a character to the right [SHIFT][RIGHT ARROW] Display the list for the selected column label [ALT][DOWN ARROW] Close the list for the selected column label [ALT][W] Select the previous item on the list [UP ARROW] Select the next item on the list [DOWN ARROW] Select the first item on the list [HOME] Select the last item on the list [END] Filter the list using the selected item [ENTER]
Detect the root of the next field button on the list [UP ARROW] Detect the root of the previous field button on the list [DOWN ARROW] Move selected field into the page area [ALT][P] Move selected field into the row area [ALT][R] Move selected field into the column area [ALT][C] Move selected field into the data area [ALT][D] Display the pivot table field dialog box [ALT][L]
Display the page field list [ALT][DOWN ARROW] Close the page field list [ALT][UP ARROW] Select the previous item on the list [UP ARROW] Select the next item on the list [DOWN ARROW] Select the next visible item on the list [HOME] Select the last visible item on the list [END] Display the selected item [ENTER] Group selected pivot table items [ALT][SHIFT][RIGHT ARROW] Ungroup selected pivot table items [ALT][SHIFT][LEFT ARROW]
Complete a cell entry [ENTER] Cancel a cell entry [ESC] Start a new line in the same cell [ALT][ENTER] Insert a tab character in a cell [CTRL][ALT][TAB] Delete a character [BACKSPACE] Delete a character [DEL] Delete text to the end of the line [CTRL][DEL] Move one character up [UP ARROW] Move one character down [DOWN ARROW] Move one character right [RIGHT ARROW] Move one character left [LEFT ARROW] Move to the beginning of the line [HOME] Fill the selected cell range with the current entry [CTRL][ENTER] Complete a cell entry and move down one cell [ENTER] Complete a cell entry and move up one cell [SHIFT][ENTER] Start a formula [=] Calculate all sheets in all open workbooks [ALT][=] Insert a line break [ALT][ENTER] Insert a blank cell [CTRL][SHIFT][+] Copy value into active cell or formula bar [CTRL][SHIFT]["] Toggle between cell values and cell formulas [CTRL]['] Copy formula into active cell or formula bar [CTRL][V] Enter a formula as an array formula [CTRL][SHIFT][ENTER] Display step two of the Function Wizard [CTRL][A] Insert function argument name [CTRL][SHIFT][A] Activate the autocomplete list [ALT][DOWN ARROW] Execute the style command [ALT]['] Execute the format cells command [CTRL][F1] Extend selection by one cell right [SHIFT][RIGHT ARROW] Extend selection by one cell left [SHIFT][LEFT ARROW] Extend selection by one cell up [SHIFT][UP ARROW] Extend selection by one cell down [SHIFT][DOWN ARROW] Extend selection to end of current data region [CTRL][SHIFT][RIGHT ARROW] Extend selection to beginning of a row [SHIFT][HOME] Extend selection to beginning of worksheet [CTRL][SHIFT][HOME] Extend selection to last cell in worksheet [CTRL][SHIFT][END] Select an entire column [CTRL][SPACEBAR] Select an entire row [SHIFT][SPACEBAR] Select an entire worksheet [CTRL][A] Collapse Selection to the active cell [SHIFT][SPACEBAR] Extend selection down one screen [SHIFT][PG DN] Extend selection up one screen [SHIFT][PG UP] Select the current region [CTRL][SHIFT][*] Select all objects on a sheet [CTRL][SHIFT][SPACEBAR] Hide or display objects or object placeholders [CTRL][F6] Show or hide the standard toolbar [CTRL][F7] Turn end mode on or off [END]
Copyright (c) 1995 Ziff-Davis Publishing Company. All rights reserved. Reproduction in whole or in part in any form or medium without express written permission of Ziff-Davis Publishing Company is prohibited. PC Computing Online and the PC Computing Online logo are trademarks of Ziff-Davis Publishing Company.