MS Excel - 2007
SHORTCUT KEY
Keys for the Office interface
ALT+TAB : Switch to the next program.
ALT+SHIFT+TAB : Switch to the previous program.
CTRL+ESC : Display the Windows Start menu.
CTRL+W or CTRL+ F4 : Close the selected
workbook window.
CTRL+F5 : Restore the window size of the
selected workbook window.
F6 : Switch to the next pane in a
worksheet that has been split
SHIFT+F6 : Switch to the previous pane in a
worksheet that has been split.
CTRL+F6 : When more than one workbook window is
open
CTRL+SHIFT+F6 : Switch to the previous workbook window.
CTRL+F7 : When a workbook window is not
maximized
CTRL+F8 : When a workbook window is not
maximized
CTRL+F9 : Minimize a workbook window to an
icon.
CTRL+F10 : Maximize or restore the selected
workbook window.
ALT+PRINT SCREEN : Copy a picture of the
selected window to the Clipboard.
SHIFT+F10 : Open
a; open a drop-down menu for the selected gallery item
Keys for workbooks and worksheets
SHIFT+F11 or : Insert a new worksheet.
CTRL+PAGE DOWN : Move to the next sheet in the
workbook.
CTRL+PAGE UP : Move to the previous sheet in the
workbook.
SHIFT+CTRL+PAGE DOWN : Select
the current and next sheet. To cancel selection of multiple sheets,
CTRL+PAGE DOWN : To
select a different sheet, press CTRL+PAGE UP.
SHIFT+CTRL+PAGE UP : Select the current and previous
sheet.
ALT+O H R : Rename the current sheet
ALT+E M : Move or copy the current sheet
ALT+E L : Delete the current sheet
CTRL+ Arrow key : Move to the edge of the current
HOME : Move to the beginning of the row.
CTRL+HOME : Move to the beginning of the
worksheet.
CTRL+END : Move to the last cell on the
worksheet, in the bottom-most used row
of the Ghettos used column.
PAGE DOWN : Move down one screen.
PAGE UP : Move up one screen.
ALT+PAGE DOWN : Move one screen to the right.
ALT+PAGE UP : Move one screen to the left.
F5 : Go To dialog box.
SHIFT+F5 : Find dialog box.
SHIFT+F4 : Repeat the last Find action.
Keys for selecting data and cells
CTRL+SPACEBAR : Select the entire column.
SHIFT+SPACEBAR : Select the entire row.
SHIFT+BACKSPACE : With multiple cells selected, select
only the active cell. .
SHIFT+ Arrow key : Extend the selection by one cell.
SHIFT+HOME : Extend the selection to the beginning
of the row.
CTRL+SHIFT+HOME : Extend the selection to the beginning
of the worksheet.
CTRL+SHIFT+END : Extend the selection to the last used
cell on the worksheet (lower-right
corner).
SHIFT+PAGE DOWN : Extend the selection down one screen.
SHIFT+PAGE UP : Extend the selection up one screen.
CTRL+SHIFT+F3 : Create from row and column labels.
CTRL+F3 : Define a name/Name Manager
CTRL+; (semicolon) : Enter the date.
CTRL+SHIFT+: (colon) : Enter the time.
ALT+DOWN ARROW : Display a drop-down list of the
values in the current column of a range.
ALT+0162 : Enters the cent character ¢.
ALT+0163 : Enters the pound sterling character
£.
ALT+0165 : Enters the yen symbol ¥.
ALT+0128 : Enters the euros symbol €.
= (equal sign) : Start a formula.
F2 : Edit cell.
CTRL+SHIFT+ENTER : Enter a formula as.
SHIFT+F3 : Insert Function
dialog box.
F3 : Paste a in to a formula.
ALT+= (equal sign) : Insert an AutoSum formula with the SUM function.
CTRL+SHIFT+" : Copy the value from the cell above the active cell into the cell
or the Formula
Bar.
CTRL+` : displaying formulas.
F9 : Calculate all worksheets in all open workbooks.
SHIFT+F9 : Calculate the active worksheet.
ALT+ENTER : Start a new line in the same cell.
F7 : Display the Spelling dialog box.
SHIFT+F2 : Edit a cell comment.
ENTER : Complete a cell entry and select the next cell below.
CTRL+HYPHEN : Delete the selected cells.
CTRL+SHIFT+(+) : Insert blank cells.
ALT+' (apostrophe) : Display the Style dialog box.
CTRL+SHIFT+~ : Apply the General number format.
CTRL+SHIFT+$ : Apply the Currency format with two
decimal places
CTRL+SHIFT+% : Apply the Percentage format with no
decimal places.
CTRL+SHIFT+^ : Apply the Exponential number format
with two decimal places.
CTRL+SHIFT+# : Apply the Date format with the day,
month, and year.
CTRL+SHIFT+@ : Apply the Time format with the hour
and minute, and AM or PM.
CTRL+SHIFT+! : Apply the Number format with two
decimal places, thousands separator,
and minus sign (–) for negative values.
CTRL+SHIFT+( : Unhide any hidden rows within the
selection.
CTRL+SHIFT+) : Unhide any hidden columns within the
selection.
CTRL+SHIFT+& : Apply the outline border to the selected
cells.
CTRL+SHIFT+_ : Remove the outline border from the
selected cells.
CTRL+SHIFT+ ( : Unhide any hidden rows within the
selection.
CTRL+SHIFT+) : Unhide any hidden columns within the
selection.
CTRL+0 (zero) : Hide the selected columns.
CTRL+1 : Display the Format Cells dialog box.
CTRL+5 : Apply or remove strikethrough.
Keys for charts
F11 : Creates a chart of the
data in the current range in another sheet
ALT+F1 : Creates a chart of the data in the
current range in current sheet
ALT+F8 : Displays the Macro dialog box.
ALT+F11 : Displays the Visual
Basic Editor.
CTRL+F11 : Inserts a Microsoft
Excel 4.0 macro sheet.
Ctrl command
Ctrl+A : Select the entire worksheet
Ctrl+B : Bold
Ctrl+C : Copy
Ctrl+D : fill down
Ctrl+E :
Ctrl+F : Find
Ctrl+G : Go to
Ctrl+H : Replace
Ctrl+I : Italic
Ctrl+J :
Ctrl+K : Insert hyperlink
Ctrl+L : Create list
Ctrl+M :
Ctrl+N : New file
Ctrl+O : Open file
Ctrl+P : Print
Ctrl+Q :
Ctrl+R : Fill to the right.
Ctrl+S : Save / Save as
Ctrl+T :
Ctrl+U : Underline
Ctrl+V : Paste copied cells.
Ctrl+W : File close
Ctrl+X : Paste copied cells.
Ctrl+Y : Repeat undo
Ctrl+z : Undo
the last action.
No comments:
Post a Comment