excel keyboard shortcuts

general key command_1

ctrl + page up ===== from left to right switching between worksheet tabs

ctrl + page down ===== from right to left switching between worksheet tabs

ctrl + shift + ( ===== selected any hidden rows un-hide

ctrl + shift + & ===== selected cell's outline border apply

ctrl + shift + _ (under line) ===== selected cell's outline border remove

ctrl + shift + ~ ===== general number format apply

ctrl + shift + $ ===== two decimal places currency format (negative numbers in parentheses) apply

ctrl + shift + % ===== no decimal places percentage format apply

ctrl + shift + ^ ===== two decimal places scientific number format apply

ctrl + shift + # ===== date (day, month, year) format apply

ctrl + shift + @ ===== time (minute, hour, am/pm) format apply

ctrl + shift + ! ===== two decimal places number (thousands separator,  [-] minus for negative value) format apply

ctrl + shift + * ===== current region with data area enclosed by blank rows and blank columns select

ctrl + shift + : ===== current time enter/apply

ctrl + shift + " ===== value from the cell above the active cell into the cell/formula bar copy

ctrl + shift + + (plus) ===== display/view insert dialog box to insert blank cells

ctrl + - (minus) ===== display/view delete dialog box to delete the selected cells

ctrl + ; ===== current date enter/apply

ctrl + ` ===== alternate between displaying worksheet's displaying formulas & cell values 

ctrl + ' ===== from cell above active cell into formula bar/cell copy a formula

ctrl + 1 ===== format cells dialog box display/show

ctrl + 2 ===== bold formatting display/show

ctrl + 3/ctrl + i ===== italic formatting display/show

ctrl + 4 ===== underlining display/show

ctrl + 5 ===== strike through display/show

ctrl + 6 ===== alternates between displaying & hiding objects

ctrl + 8 ===== outline symbols hide/display

ctrl + 9 ===== selected rows hide

ctrl + 0 ===== selected columns hide

ctrl + a ===== entire worksheet select

ctrl + shift + a ===== inserts argument names and parentheses

ctrl + b ===== bold formatting hide/display

ctrl + c ===== copy

ctrl + d ===== fill down command to copy the content

ctrl + f ===== find/replace

shift + f5 ===== repeats last find action

ctrl + shift + f ===== font tab selected format cells dialog box open

ctrl + g/f5 ===== go to dialog box view/display

ctrl + h ===== replace tab selected find and replace box view/display

ctrl + k ===== insert hyperlink dialog box view/display

ctrl + l ===== create table dialog box view/display

ctrl + n ===== new/blank workbook

ctrl + o ===== open

ctrl + shift + o ===== contain comment's cell(s) selects all

ctrl + p ===== print

ctrl + shift + p ===== font tab selected format cells dialog box open

ctrl + r ===== format of the leftmost cell & copy contents fill right command

ctrl + s ===== save

ctrl + t ===== create table dialog box display/show

ctrl + u ===== underline

ctrl + shift + u ===== switch between collapsing & expanding of formula bar

ctrl + v ===== paste

ctrl + alt + v ===== paste special

ctrl + w ===== close 
ctrl + x ===== cut

ctrl + y ===== redo

ctrl + z ===== undo

general key command_2 (function keys)

f1 ===== help

ctrl + f ===== ribbon display/hide

alt + f1 ===== create an embedded chart

alt + shift + f1 ===== a new worksheet insert

f2 ===== edit active cell

shift + f2 ===== cell comment add/edit

ctrl + f2 ===== print preview

f3 ===== available only if there are existing names in the workbook displays the paste name dialog box

shift + f3 ===== insert function dialog box display/view

f4 ===== last action/command repeat

ctrl + f4 ===== closes the selected workbook window.

alt + f4 ===== quite

f5 ===== go to dialog box display/view

ctrl + f5 ===== selected workbook window restore window size

f6 ===== switching between ribbon, task pane, worksheet & zoom controls

shift + f6 ===== switching between task pane, worksheet, zoom controls & ribbon

ctrl + f6 ===== switching to next workbook window

f7 ===== spelling dialog box display/view

ctrl + f7 ===== move command

f8 ===== turn on/off extend mode

shift + f8 ===== enable to add a range/nonadjacent cell

ctrl + f8 ===== size command perform

alt + f8 ===== macro dialog box display/view

f9 ===== all worksheets calculate

shift + f9 ===== active worksheet calculate

ctrl + alt + f9 ===== all worksheets in all open workbooks calculate

ctrl + alt + shift + f9 ===== dependent formulas & then calculate recheck

ctrl + f9 ===== minimize

f10 ===== turn on/off key tips

shift + f10 ===== shortcut menu for a selected item display/view

alt + shift + f10 ===== message for an error checking button/menu display/view

ctrl + f10 ===== restore/maximize selected workbook window

f11 ===== a chart of the data create

shift + f11 ===== new worksheet insert

alt + f11 ===== visual basic open

f12 ===== save as