Ms-Excel Shortcut Keys

USER INTERFACE
Ctrl+F1	Show or hide the ribbon
Alt	Show or hide the Shortcuts all tabs, office button & quick access tool bar.
Ctrl+9	Hide selected rows
Ctrl+Shift+9	Unhide hidden rows within the selection
Ctrl+0	Hide selected columns
Shift+F10, then U	Unhide selected columns
FILE TAB
Ctrl +O	Open file via standard open dialog box
Alt +F, O	File Open via Excel file manager
Alt +F, O + 1...9	Open recent file
Alt +F, O, Y,	Open recent file
Ctrl +S	Save File with current file name
F12	Save file as via standard save dialog box
Alt +F, A	File Save as via Excel file manager
Ctrl +P	Print.
Alt +F, P	Open File Print menu
I in Print Menu	Select printer
G in Print Menu	Page setup
N in Print Menu	Set Number of copies
Esc	Exit open/ save menu
Worksheet Tabs
Ctrl+ Page Down/Page Up	Move to the next/ previous worksheet in current workbook
Ctrl +Page Down	Move to the previous worksheet in current workbook
Alt +H, IS	Insert worksheet (Home - Insert Sheet)
Alt +H, DS	Delete worksheet Home - Delete Sheet
Alt +H, OR	Rename worksheet
Alt +H, OM	Move worksheet (Home - Format - Move worksheet)
Alt +H, OT	Worksheet tab color, continue with mouse or arrow keys (Home - Format - Tab color)
Column Width and Row Height
Alt+ HO	Home - Format Worksheet
Alt+ HO + H	Set row Height
Alt+ HO + A	Auto fit row height
Alt+ HO + W	Set column Width
Alt+ HO + I	Auto fit column width
Alt+ HO + D	Set Default width
Formulas
=	Start a formula
Alt+=	Insert the AutoSum formula
Ctrl +A with formula present	Edit formula in formula Bar
Ctrl +Shift +U	Expand/ collapse formula bar
Shift+F3 with empty cell	Display the 'insert function; dialog box
Shift+F3 with formula present	Edit arguments of formula at cursor position
Alt +H, FD, U	Select all Formulas (Home - Find - Formulas
Ctrl+~	Show/ hide all formulas. This will automatically extend all column widths which reverses when pressed again
Ctrl +'	Duplicate formula from cell above
F3	Paste named range in formula
Using Worksheets
Arrow Keys	Navigate by one cell at a time in any direction
Page Down	Move one screen down
Page Up	Move one screen up
Alt +Page Down	Move one screen right
Alt + Page Up	Move one screen left
Tab	Move one cell to the right in a worksheet
Shift +Tab	Move one cell to the left in a worksheet
Ctrl +Arrow Keys	Move to the edge of next data region
Home	Move to the beginning of row
Ctrl +Home	Move to the beginning of worksheet
Ctrl +End	Move to the last cell with content of worksheet
Ctrl +G	Display the Go To dialog box
Select Cells
Shift +Arrow Keys	Extend selection by one cell
Shift +Page Down	Extend selection one screen down
Shift +Page Up	Extend selection one screen up
Ctrl +A	Select all
Ctrl +Shift +Home	Extend selection to first cell of the worksheet
Shift +Space	Select current row
Shift +Space, then Shift+ Arrow Down	Select current row, then expand selection by one row down
Shift +Space, then Shift+ Arrow Up	Select current row, then expand selection by one row up
Shift +Space, then Shift +Page Down	Select current row, then expand selection by one page down
Shift +Space, then Shift + Page Up	Select current row, then expand selection by one page up
Ctrl +Space	Select current column
Shift +Space, then Shift +Arrow Right	Select current column, then expand selection by one column right
Shift +Space, then Shift + Arrow Left	Select current column, then expand selection by one column left
Shift +Space, then Shift +Alt +Page Down	Select current column, then expand selection by one screen right
Shift +Space, then Shift +Alt+ Page Up	Select current column, then expand selection by one screen left
GENERAL SHORTCUT KEYS
Ctrl +Z	Undo
Ctrl +Y	Redo
Ctrl +X	Cut cell(s) to clipboard
Ctrl +C	Copy cell(s) to clipboard
Ctrl +V	Paste cell(s) from clipboard
Ctrl +Alt +V	Open Paste Special Menu
Ctrl +Alt +V, then V, Enter	Paste Values
Ctrl +Alt +V, then T, Enter	Paste Formats
Ctrl +Alt +V, then E, Enter	Paste Transposed
Ctrl +Alt +V, then W, Enter	Paste Column Width
Ctrl +Alt +V, then U, Enter	Paste Values and Number Formats
F3	Paste a defined name into a formula
Ctrl +F	Display the Find and Replace dialog box
Ctrl +H	Display the find and replace dialog box
Escape	Close the find and replace dialog Box
Shift+F4	Find next
Ctrl+Shift+F4	Find previous
Duplicate Cells, Rows, and Columns
Ctrl +D	Fill Down from cell(s) above into current cell(s)
Ctrl +D with a row selected	Duplicate row via fill down - Fill current row with content from row above.
Ctrl +D with multiple empty cells selected	Duplicate content of first cell(s) in first row to all cells in selection downward.
Ctrl +R	Fill right from cell(s) on the left into current cell(s)
Ctrl +R with a column selected	Duplicate column via fill right - Fill current column with content from column on the left.
Ctrl +D with multiple empty cells selected	Duplicate content first cell(s) in first column to all cells in selection to the right.
Ctrl+'	Duplicate formula from cell above
GENERAL CELL FORMAT
Alt +Enter	Repeat a previous cell format action on current cell
Ctrl+1	Open Format Cells dialog with last selection active
Ctrl +Shift +F	Open Format Cells dialog with Font Tab active
Ctrl +B	Apply/ remove bold format
Ctrl +I	Apply/ remove italic format
Ctrl +U	Apply/ remove underline format
Ctrl +5	Apply/ remove strikethrough formatting
Alt +HH, then N	Set to No fill color
NUMBER FORMATS
Ctrl +Shift+ ~	Apply the general number format
Ctrl +Shift+ 1	Apply the number format with two decimal places, thousands separator
Ctrl +Shift+ 2	Apply the time format with the hour and minute, and indicate AM or PM
Ctrl +Shift+ 3	Apply the date format with the day, month, and year
Ctrl +Shift+ 4	Apply the currency format with two decimal places
Ctrl +Shift+ 5	Apply the percentage format with no decimal places
Ctrl +Shift+ 6	Apply the scientific number format
Alignments
Alt +H, AL	Align Left
Alt +H, AR	Align Right
Alt +H, AC	Align Center
Alt +H, AT	Align Top
Alt +H, AM	Align Middle
Alt +H, AB	Align Bottom
Wrap and Merge
Alt +H, W	Wrap or unwrap text
Alt +H, MM	Merge cells - Merge
Alt +H, MU	Merge - Unmerge
Alt +H, MC	Merge and Center
Alt +H, MA	Merge Across
Borders
Alt +H, BM	Home - Border - Menu
Alt +T	Top border
Alt +B	Bottom border
Alt +R	Right border
Alt +L	Left border
Alt +H	Horizontal interior border
Alt +V	Vertical interior border
Alt +U	Upwards diagonal border
Alt +D	Downwards diagonal border
Ctrl +Shift + &	Add outline borders from cell or selection
Ctrl +Shift + -	Remove outline borders from cell or selection
SPECIAL SHORTCUTS KEYS
Alt +W +FF	View - Freeze or unfreeze; unfreeze works for any Freeze Setting
Alt +W +R	View - Freeze first visible Row on screen
Alt +W +C	View - Freeze first Column on screen
Alt +WS	Split or un split Worksheet at current position
Ctrl +K	Insert or edit hyperlink (for complete cell only)
Shift +F10, then R	Remove one or multiple hyperlink(s)
Shift +F2	Insert/ edit a cell comment
Ctrl +Shift +O	Select all cells with comments
Shift+F10, then M	Delete single comment
Alt +Shift +Arrow Right	Group rows or columns
Alt +Shift +Arrow Left	Ungroup rows or columns
Ctrl +T	Create auto Table from selection
Shift +Space	Select table column
Ctrl +Space	Select table row
Alt +NV	Insert PivotTable after selecting data range.
F10 +R	Refresh PivotTable
Ctrl +-	Hide selected item
Alt+F1	Create Pivot Chart in same Worksheet
F1	Create Pivot Chart in new Worksheet
COMMON SHORTCUT KEYS
Ctrl+F1	Minimize/ restore Excel ribbons
Shift+F7	Display the thesaurus dialog box
F7	Display the spelling dialog box
Alt+F4	Close Excel
F1	Help
Alt+'	Style dialog box
Ctrl+F3	Define a name or dialog
Ctrl+Shift+F3	Create names from row and column labels
Ctrl+F6	Scroll between open workbooks
Alt+F8	Display macro dialog box
THE END