Tuesday, 1 March 2016

Excel Short Method


Image result for excel

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






No comments:

Post a Comment