Shortcut keys for Excel Sheet
Here some
shortcut keys which you can use in excel sheet:
vCtrl+PgDn
o
Switches between worksheet tabs,
from left-to-right.
vCtrl+PgUp
o
Switches between worksheet tabs,
from right-to-left.
vCtrl+Shift+&
o
Applies the outline border to the
selected cells.
vCtrl+Shift_
o
Removes the outline border from the
selected cells.
vCtrl+Shift+~
o
Applies the General number format.
vCtrl+Shift+$
o
Applies the Currency format with two
decimal places (negative numbers in parentheses).
vCtrl+Shift+%
o
Applies the Percentage format with
no decimal places.
vCtrl+Shift+^
o
Applies the Scientific number format
with two decimal places.
vCtrl+Shift+#
o
Applies the Date format with the
day, month, and year.
vCtrl+Shift+@
o
Applies the Time format with the
hour and minute, and AM or PM.
vCtrl+Shift+!
o
Applies the Number format with two
decimal places, thousands separator, and minus sign (-) for negative values.
vCtrl+Shift+*
o
Selects the current region around
the active cell (the data area enclosed by blank rows and blank columns).
o
In a PivotTable, it selects the
entire PivotTable report.
vCtrl+Shift+:
o
Enters the current time.
vCtrl+Shift+"
o
Copies the value from the cell above
the active cell into the cell or the Formula Bar.
vCtrl+Shift+Plus
(+)
o
Displays the Insert dialog
box to insert blank cells.
vCtrl+Minus
(-)
o
Displays the Delete dialog
box to delete the selected cells.
vCtrl+;
o
Enters the current date.
vCtrl+`
o
Alternates between displaying cell
values and displaying formulas in the worksheet.
vCtrl+'
o
Copies a formula from the cell above
the active cell into the cell or the Formula Bar.
vCtrl+1
o
Displays the Format Cells dialog
box.
vCtrl+2
o
Applies or removes bold formatting.
vCtrl+3
o
Applies or removes italic
formatting.
vCtrl+4
o
Applies or removes underlining.
vCtrl+5
o
Applies or removes strikethrough.
vCtrl+6
o
Alternates between hiding and
displaying objects.
vCtrl+8
o
Displays or hides the outline
symbols.
vCtrl+9
o
Hides the selected rows.
vCtrl+0
o
Hides the selected columns.
vCtrl+A
o
Selects the entire worksheet.
o
If the worksheet contains data,
Ctrl+A selects the current region. Pressing Ctrl+A a second time selects the
entire worksheet.
o
When the insertion point is to the
right of a function name in a formula, displays the Function Arguments dialog
box.
vCtrl+Shift+A
o
inserts the argument names and
parentheses when the insertion point is to the right of a function name in a
formula.
vCtrl+B
o
Applies or removes bold formatting.
vCtrl+C
o
Copies the selected cells.
vCtrl+D
o
Uses the Fill Down command
to copy the contents and format of the topmost cell of a selected range into
the cells below.
vCtrl+E
o
Adds more values to the active
column by using data surrounding that column.
vCtrl+F
o
Displays the Find and
Replace dialog box, with the Find tab selected.
vShift+F5
o
also displays this tab, while
Shift+F4 repeats the last Find action.
vCtrl+Shift+F
o
opens the Format Cells dialog
box with the Font tab selected.
vCtrl+G
o
Displays the Go To dialog
box.
o
F5 also displays this dialog box.
o
vCtrl+H
o
Displays the Find and Replace dialog
box, with the Replace tab selected.
vCtrl+I
o
Applies or removes italic
formatting.
vCtrl+K
o
Displays the Insert
Hyperlink dialog box for new hyperlinks or the Edit Hyperlink dialog
box for selected existing hyperlinks.
vCtrl+L
o
Displays the Create Table dialog
box.
vCtrl+N
o
Creates a new, blank workbook.
vCtrl+O
o
Displays the Open dialog
box to open or find a file.
vCtrl+Shift+O
o
selects all cells that contain
comments.
vCtrl+P
o
Displays the Print tab
in Microsoft Office Backstage view.
vCtrl+Shift+P
o
opens the Format Cells dialog
box with the Font tab selected.
vCtrl+Q
o
Displays the Quick Analysis options
for your data when you have cells that contain that data selected.
vCtrl+R
o
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.
vCtrl+S
o
Saves the active file with its
current file name, location, and file format.
vCtrl+T
o
Displays the Create Table dialog
box.
vCtrl+U
o
Applies or removes underlining.
vCtrl+Shift+U
o
switches between expanding and
collapsing of the formula bar.
vCtrl+V
o
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.
vCtrl+Alt+V
o
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.
vCtrl+W
o
Closes the selected workbook window.
vCtrl+X
o
Cuts the selected cells.
vCtrl+Y
o
Repeats the last command or action,
if possible.
vCtrl+Z
o
Uses the Undo command
to reverse the last command or to delete the last entry that you typed.
Comments
Post a Comment