Showing posts with label MS Office Tips. Show all posts
Showing posts with label MS Office Tips. Show all posts

MS-Excel Short Key


Home
Move to column A
Tab
Navigate a cell - right
Shift + Tab
Navigate a cell - left
Ctrl + Arrow
Move to edge of current data region
End + Arrow
Move to edge of current data region
Shift + Arrow
Navigate a cell - all arrow directions - with selection
Ctrl + Home
Move to the beginning of the Worksheet
Ctrl + End
Move to the end of the Worksheet
Alt + Page Down
Move one screen to right
Alt + Page Up
Move one screen to left
Ctrl + Page Down
Move to the next worksheet
Ctrl + Page Up
Move to the previous worksheet
F6
Move to the next pane in split worksheet
Shift + F6
Move to the previous pane in split worksheet
Ctrl + .
Move to the corners of selection and verify your selection
Ctrl + `
Switch between value and formula
Alt + T, U, T
Trace Precedents
Alt + T, U, D
Trace Dependents
Alt + T, U, A
Remove all arrows
Ctrl + [ or Ctrl + ]
Switch to Data Sheet from the formula or vice-versa
Editing
F2
Edit cell contents
Shift + F2
Edit/Create a cell comment
Delete
Delete cell contents
Ctrl + -
Delete selected row or column
Ctrl + Delete
Delete all text to the right of current editing
Alt + Enter
Enter a new line while editing in the same cell - word wrap
Ctrl + +
Insert a row or column before selection (row/column selection)
Ctrl + Shift + A
Type a function; press combo; inserts function syntax
Ctrl + Enter
Select range; enter data/function; press combo; copies to selection
Shift + Enter
Stop editing and move a cell up
Ctrl + Alt + V
Paste Special (Version 2007 and above)
Ctrl + F3
Define names
Shift + F3
Open all functions dialog box
Ctrl + A
Display a function window for the typed function
Ctrl + D
Copy down the selection
Ctrl + R
Copy to the right in the selection
Ctrl + Shift + "
Copy contents of above cell in the current cell and edit
Ctrl + ;
Enter Date
Formatting
Ctrl + 1
Display Format Cells dialog box
Ctrl + Shift + ~
Apply number format
Ctrl + Shift + !
Apply number format
Ctrl + Shift + $
Apply currency format
Ctrl + Shift + %
Apply percentage format
Ctrl + Shift + #
Apply date format
Ctrl + Shift + &
Apply outline border
Ctrl + Shift + _
Remove outline border
Selection
Ctrl + Shift + *
Select data region around current cell
Shift + Home
Extend selection to beginning of row
Shift + Spacebar
Select entire row
Ctrl + Spacebar
Select entire column
F8
Turn on/off selection mode; then start moving around
Shift + F8
Multi-select - select range; press combo; select another range; repeat
Alt+;
Select visible cells (ignores hidden rows/columns in the selection)