Alt or F10
|
Activate menu
|
Alt + ’
|
Format Style dialog
box
|
Alt + =
|
AutoSum
|
Alt + Down arrow
|
Display AutoComplete
list
|
Alt + Enter
|
Start a new line in
the same cell
|
Alt + Esc
|
Toggle Between most
recent two applications in taskbar
|
Alt + F1
|
Insert a Chart sheet
|
Alt + F11
|
Open Visual Basic
Editor
|
Alt + F2
|
Save As
|
Alt + F4
|
Exit Workbook
|
Alt + F8
|
Macro dialog box
|
Alt + i + c
|
Insert column
|
Alt + i + r
|
Insert row
|
Alt + Shift + F1
|
New worksheet
|
Alt + Shift + F2
|
Save Workbook
|
Ctrl W
|
Close Workbook
|
Ctrl + –
|
Delete
|
Ctrl + "
|
Copy Value from Cell
Above
|
Ctrl + :
|
Insert Current Time
|
Ctrl + ;
|
Insert Current Date
|
Ctrl + 0
|
Hide columns
|
Ctrl + 1
|
Format cells dialog
box
|
Ctrl + 2
|
Bold
|
Ctrl + 3
|
Italic
|
Ctrl + 4
|
Underline
|
Ctrl + 5
|
Strikethrough
|
Ctrl + 6
|
Show/Hide objects
|
Ctrl + 7
|
Show/Hide Standard
toolbar
|
Ctrl + 8
|
Toggle Outline symbols
|
Ctrl + 9
|
Hide rows
|
Ctrl + A
|
Select All Cells in
range
|
Ctrl + Alt + F9
|
Forces FULL
calculation of all worksheets in all open workbooks
|
Ctrl + Alt + Shift +
F9
|
Forces FULL
calculation with dependency tree rebuild
|
Ctrl + B
|
Bold
|
Ctrl + C
|
Copy
|
Ctrl + D
|
Fill Down
|
Ctrl + End
|
Move to last used cell
in a worksheet
|
Ctrl + Enter
|
Fill the selected cell
range with the current entry.
|
Ctrl + F
|
Find
|
Ctrl + F10
|
Maximize or restore
window
|
Ctrl + F11
|
Inset 4.0 Macro sheet
|
Ctrl + F12
|
File Open
|
Ctrl + F3
|
Define name
|
Ctrl + F4
|
Close
|
Ctrl + F5
|
XL, Restore window
size
|
Ctrl + F6
|
Next workbook window
|
Ctrl + F7
|
Move window
|
Ctrl + F8
|
Resize window
|
Ctrl + F9
|
Minimize workbook
|
Ctrl + G
|
Goto
|
Ctrl + H
|
Replace
|
Ctrl + Home
|
Move to the first
non-header cell of the sheet
|
Ctrl + I
|
Italic
|
Ctrl + K
|
Insert Hyperlink
|
Ctrl + N
|
New Workbook
|
Ctrl + N
|
New Workbook
|
Ctrl + O
|
Open
|
Ctrl + P
|
Print
|
Ctrl + Page Down
|
Move to next worksheet
|
Ctrl + Page Up
|
Move to previous
worksheet
|
Ctrl + R
|
Fill Right
|
Ctrl + Right Arrow
|
Move to right end of
range
|
Ctrl + Right Arrow
|
Move to right end of
range
|
Ctrl + S
|
Save
|
Ctrl + Shift + !
|
Comma format
|
Ctrl + Shift + +
|
Insert Cells, Rows,
Columns
|
Ctrl + Shift + #
|
Date format
|
Ctrl + Shift + $
|
Currency format
|
Ctrl + Shift + %
|
Percent format
|
Ctrl + Shift + &
|
Place outline border
around selected cells
|
Ctrl + Shift + (
|
Unhide rows
|
Ctrl + Shift + )
|
Unhide columns
|
Ctrl + Shift + *
|
Select current region
|
Ctrl + Shift + @
|
Time format
|
Ctrl + Shift + ^
|
Exponential format
|
Ctrl + Shift + _
|
Remove outline border
|
Ctrl + Shift + ~
|
General format
|
Ctrl + Shift + 1
|
Format cell to two
decimal places
|
Ctrl + Shift + 2
|
Format cell to time
|
Ctrl + Shift + 3
|
Format cell to date
|
Ctrl + Shift + 4
|
Format cell to
currency
|
Ctrl + Shift + 5
|
Format cell to
percentage
|
Ctrl + Shift + 6
|
Format cell to
scientific notation
|
Ctrl + Shift + 7
|
Draws outline around
your selection
|
Ctrl + Shift + A
|
Insert argument names
into formula
|
Ctrl + Shift + Enter
|
Used to enter an array
formula
|
Ctrl + Shift + F12
|
Print
|
Ctrl + Shift + F3
|
Create name by using
names of row and column labels
|
Ctrl + Shift + F6
|
Previous Window
|
Ctrl + Spacebar
|
Select the current
column
|
Ctrl + Tab
|
In a workbook:
activate next workbook
|
Ctrl + U
|
Underline
|
Ctrl + V
|
Paste
|
Ctrl + X
|
Cut
|
Ctrl + Y
|
Repeat
|
Ctrl + Z
|
Undo
|
Enter
|
Do the command
|
F1
|
Help
|
F10
|
Activate Menubar
|
F11
|
New Chart
|
F12
|
Save As
|
F2
|
Edit
|
F3
|
Paste Name
|
F4
|
Repeat last action
|
F4
|
While typing a
formula, switch between absolute/relative refs
|
F5
|
Goto
|
F6
|
Next Pane
|
F7
|
Spell check
|
F8
|
Extend mode
|
F9
|
Recalculate all
workbooks
|
Shift
|
Hold down shift for
additional functions in Excel’s menu
|
Shift + Ctrl + F
|
Font Drop Down List
|
Shift + Ctrl + F + F
|
Font tab of Format
Cell Dialog box
|
Shift + Ctrl + F6
|
Previous workbook
window
|
Shift + Ctrl + P
|
Point size Drop Down
List
|
Shift + Ctrl + Tab
|
In toolbar: previous
toolbar
|
Shift + Ctrl + Tab
|
In a workbook:
activate previous workbook
|
Shift + Enter
|
Go to previous cell
|
Shift + F1
|
What’s This?
|
Shift + F10
|
Display shortcut menu
|
Shift + F11
|
New worksheet
|
Shift + F12
|
Save
|
Shift + F2
|
Edit cell comment
|
Shift + F3
|
Paste function into
formula
|
Shift + F4
|
Find Next
|
Shift + F5
|
Find
|
Shift + F6
|
Previous Pane
|
Shift + F8
|
Add to selection
|
Shift + F9
|
Re-calculate active
worksheet
|
Shift + Spacebar
|
Select the current row
|
Shift + Tab
|
Previous application
in taskbar
|
Tab
|
Next tool
|
राजस्थान पुलिस,भारतीय रेल,एसएससी,बैंक,पटवारी,संघ लोक सेवा आयोग,टिकट कलक्टर और सभी परीक्षाओं के लिए सामान्य ज्ञान का संग्रह
Latest Exam Gk Quize
Tuesday, 1 March 2016
Excel Short Method
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment