Home / Computer Science / Miscellenious / Shortcut Keys – Microsoft Excel

Shortcut Keys – Microsoft Excel











Shortcuts with CTRL key combination
Key Description
CTRL+PgUp Switches between worksheet
tabs, from left-to-right.
CTRL+PgDn Switches between worksheet
tabs, from right-to-left.
CTRL+SHIFT+( Unhides any hidden rows
within the selection.
CTRL+SHIFT+) Unhides any hidden columns
within the selection.
CTRL+SHIFT+& Applies the outline border
to the selected cells.
CTRL+SHIFT_ Removes the outline border
from the selected cells.
CTRL+SHIFT+~ Applies the General number
format.
CTRL+SHIFT+$ Applies the Currency format
with two decimal places (negative numbers in parentheses).
CTRL+SHIFT+% Applies the Percentage
format with no decimal places.
CTRL+SHIFT+^ Applies the Exponential
number format with two decimal places.
CTRL+SHIFT+# Applies the Date format
with the day, month, and year.
CTRL+SHIFT+@ Applies the Time format
with the hour and minute, and AM or PM.
CTRL+SHIFT+! Applies the Number format
with two decimal places, thousands separator, and minus sign (-) for negative
values.
CTRL+SHIFT+* Selects the current region
around the active cell (the data area enclosed by blank rows and blank
columns). In a PivotTable, it selects
the entire PivotTable report.
CTRL+SHIFT+: Enters the current time.
CTRL+SHIFT+" Copies the value from the
cell above the active cell into the cell or the Formula Bar.
CTRL+SHIFT+Plus
(+)
Displays the Insert dialog box to insert
blank cells.
CTRL+Minus
(-)
Displays the Delete dialog box to delete
the selected cells.
CTRL+; Enters the current date.
CTRL+` Alternates between
displaying cell values and displaying formulas in the worksheet.
CTRL+’ Copies a formula from the
cell above the active cell into the cell or the Formula Bar.
CTRL+1 Displays the Format Cells dialog box.
CTRL+2 Applies or removes bold
formatting.
CTRL+3 Applies or removes italic
formatting.
CTRL+4 Applies or removes
underlining.
CTRL+5 Applies or removes
strikethrough.
CTRL+6 Alternates between hiding
objects, displaying objects, and displaying placeholders for objects.
CTRL+8 Displays or hides the
outline symbols.
CTRL+9 Hides the selected rows.
CTRL+0 Hides the selected columns.
CTRL+A Selects the entire
worksheet.
If the worksheet contains data, CTRL+A selects the current region. Pressing CTRL+A a second time selects the current region and its summary rows.
Pressing CTRL+A a third time selects the entire worksheet.
When the insertion point is to the right of a function name in a formula, displays
the Function Arguments
dialog box.
CTRL+SHIFT+A
inserts the argument names and parentheses when the insertion point is to the
right of a function name in a formula.
CTRL+B Applies or removes bold
formatting.
CTRL+C Copies the selected cells.
CTRL+C
followed by another CTRL+C displays the Clipboard.
CTRL+D Uses the Fill Down command to copy
the contents and format of the topmost cell of a selected range into the
cells below.
CTRL+F Displays the Find and Replace dialog box,
with the
Find
tab selected.
SHIFT+F5
also displays this tab, while SHIFT+F4 repeats the last Find action.
CTRL+SHIFT+F
opens the Format Cells
dialog box with the
Font tab selected.
CTRL+G Displays the Go To dialog box.
F5
also displays this dialog box.
CTRL+H Displays the Find and Replace dialog box,
with the
Replace
tab selected.
CTRL+I Applies or removes italic
formatting.
CTRL+K Displays the Insert Hyperlink dialog box
for new hyperlinks or the
Edit Hyperlink dialog box for selected existing hyperlinks.
CTRL+N Creates a new, blank
workbook.
CTRL+O Displays the Open dialog box to open or
find a file.
CTRL+SHIFT+O
selects all cells that contain comments.
CTRL+P Displays the Print dialog box.
CTRL+SHIFT+P
opens the Format Cells
dialog box with the
Font tab selected.
CTRL+R Uses the Fill Right command to copy
the contents and format of the leftmost cell of a selected range into the
cells to the right.
CTRL+S Saves the active file with
its current file name, location, and file format.
CTRL+T Displays the Create Table dialog box.
CTRL+U Applies or removes
underlining.
CTRL+SHIFT+U
switches between expanding and collapsing of the formula bar.
CTRL+V Inserts the contents of the
Clipboard at the insertion point and replaces any selection. Available only
after you have cut or copied an object, text, or cell contents.
CTRL+ALT+V
displays the Paste Special dialog box. Available only after you have cut or copied an
object, text, or cell contents on a worksheet or in another program.
CTRL+W Closes the selected
workbook window.
CTRL+X Cuts the selected cells.
CTRL+Y Repeats the last command or
action, if possible.
CTRL+Z Uses the Undo command to reverse the
last command or to delete the last entry that you typed.
CTRL+SHIFT+Z
uses the Undo or Redo command to reverse or
restore the last automatic correction when AutoCorrect Smart Tags are
displayed.
Function keys
F1 Displays the Microsoft Office Excel Help
task pane.
CTRL+F1
displays or hides the Ribbon, a component of the Microsoft Office Fluent user
interface.
ALT+F1
creates a chart of the data in the current range.
ALT+SHIFT+F1
inserts a new worksheet.
F2 Edits the active cell and
positions the insertion point at the end of the cell contents. It also moves
the insertion point into the Formula Bar when editing in a cell is turned
off.
SHIFT+F2
adds or edits a cell comment.
CTRL+F2
displays the Print Preview window.
F3 Displays the Paste Name dialog box.
SHIFT+F3
displays the Insert Function dialog box.
F4 Repeats the last command or
action, if possible.
When
a cell reference or range is selected in a formula, F4 cycles through the
various combinations of absolute and relative references.
CTRL+F4
closes the selected workbook window.
F5 Displays the Go To dialog box.
CTRL+F5
restores the window size of the selected workbook window.
F6 Switches between the
worksheet, Ribbon, task pane, and Zoom controls. In a worksheet that has been
split (View menu, Manage This Window, Freeze Panes, Split Window command), F6
includes the split panes when switching between panes and the Ribbon area.
SHIFT+F6
switches between the worksheet, Zoom controls, task pane, and Ribbon.
CTRL+F6
switches to the next workbook window when more than one workbook window is
open.
F7 Displays the Spelling dialog box to check
spelling in the active worksheet or selected range.
CTRL+F7
performs the Move
command on the workbook window when it is not maximized. Use the arrow keys
to move the window, and when finished press ENTER, or ESC to cancel.
F8 Turns extend mode on or
off. In extend mode, Extended Selection appears in the status line, and the arrow keys extend the
selection.
SHIFT+F8
enables you to add a nonadjacent cell or range to a selection of cells by
using the arrow keys.
CTRL+F8
performs the Size
command (on the
Control menu for the workbook window) when a workbook is not
maximized.
ALT+F8
displays the Macro
dialog box to create, run, edit, or delete a macro.
F9 Calculates all worksheets
in all open workbooks.
SHIFT+F9
calculates the active worksheet.
CTRL+ALT+F9
calculates all worksheets in all open workbooks, regardless of whether they
have changed since the last calculation.
CTRL+ALT+SHIFT+F9
rechecks dependent formulas, and then calculates all cells in all open
workbooks, including cells not marked as needing to be calculated.
CTRL+F9
minimizes a workbook window to an icon.
F10 Turns key tips on or off.
SHIFT+F10
displays the shortcut menu for a selected item.
ALT+SHIFT+F10
displays the menu or message for a smart tag. If more than one smart tag is
present, it switches to the next smart tag and displays its menu or message.
CTRL+F10
maximizes or restores the selected workbook window.
SHIFT+F11 inserts a new
worksheet.
ALT+F11
opens the Microsoft Visual Basic Editor, in which you can create a macro by
using Visual Basic for Applications (VBA).
F12 Displays the Save As dialog box.
Other Combinations
Ctrl+Space To display a menu of
additional commands
TAB Select the next hidde text or hyperlik, or show all or Hide All at the
top of a topic
SHIFT + TAB select the previous hidden text or hyperlik, or the Browser View Button at the
top of a microwsoft office Web site article
ENTER Perform the action for the selected Show
All, Hide All,
hidden text, or hyperlink
ALT + LEFTARROW Move back to the previous Help topic
ALT + RIGHT ARROW Move forword to the next Help topic
CTRL + P Print the current Help topic
UP ARROW AND DOWN ARROW Scroll small amouts up ad down, respectively, within the
currently-disploayed Help topic
PAGE UP AND PAGE DOW N Scroll large amouts up ad down, respectively, with I the
curretly-displayed help topic.
ALT + U Chage whether the help widow appears coected to separate
from
SHIFT + F10 Display a menu of commads for the help widow: Requires
that the Help window have active focus
ALT + TAB Switch to the next program
ALT + SHIFT + TAB Switch to the Previous program
CTRL + ESC Display the Widows Start menu
CTRL + W or CTRL + F4 Close the selected
work book widow
CTRL + F5 Restore the widow size of the selected workbook widow
F6 Switch to the pane in a worksheet that has bee split
Shift + f6 switch to the previous pane I a worksheet that has been
split
ctrl + f6 when more that one workbook window is ope switch to the
next workbook
ctrl + shift +f6 switch to the previous workbook widow.
ctrl + f7 when a workbook window is not maxcimize, perform the Move
command
CTRl + f8 when a workbook window is not maximize, perform the Size
command on the control menu for the work book window. Use the arrow kes to
resize the widow and whe finished press ESC.
CTRL + F9 Minimize a work book widow to an icon.
CTRL + F10 Maximize or restore the selected workbook window
PRTSCR Copy a picture of screen to the clipbord
ALT + PRINT SCREE copy a picture of
selected window to the clipbord
ALT + SHIFT + F10 Display the meu or
message for a smart tag. If more tha oe smart tag is present, switch to the
next smart tag and display its meu or message.
DOWN ARROW Select the ext item In a smart tag menu.
UP ARROW Select the previous
item in a smart tag menu
ENTER Perform the action for the selected item In a smart tag
menu.
ESC Close the smart tag menu or message.
F6 To move task pane
CTRL
+ TAB
When a menu or toolbar is
active move to a task pane
TAB or SHIFT + TAB whe a task pane is active select the next pane
CTRL + SPACEBAR Display the full set of
commands on the task pane menu
DOWN ARROW or UP
ARROW
Move among choices in a
selected submenu; move among certain options in a group of options
SPACEBAR or ENTER Open the selected menu, or perform the action assigned to
the selected button
SHIFT + 10 open a shortcut menu
HOME or END When a menu or submenu is
visible, select the first or last command on the
menu or submenu
PAGE
UP or PAGE DOWN
Scroll up or down in the selected gallery list
CTRL +HOME or CTRL + END Move to the top to bottom
of the selected gallery list




Note:Resource taken from Microsoft office support page

About santosh G

Hi, i am Santosh Gadagamma, a tutor in Software Engineering and an enthusiast for sharing knowledge in Computer Science and other domains. I developed this site to share knowledge to all the aspirants of technologies like, Java, C/C++, DBMS/RDBMS, Bootstrap, Big Data, Javascript, Android, Spring, Hibernate, Struts and all levels of software project design, development, deployment, and maintenance. As a programmer I believe that, “The world now needs computers to function.” Hope, this site guides you as a learning tool towards greater heights. I believe that Education has no end points and i wish to learn more in the process of teaching you….,

Check Also

What is OS/2?

OS/2 Operating System: OS/2 is a joint project of IBM and Microsoft. OS/2 is the …