Switches between worksheet tabs, from left to right (Ctrl + PgDn )
Switches between worksheet tabs, from right to left (Ctrl + PgUp )
Applies the outline border to the selected Cells (Ctrl + Shift + & )
Removes the outlin border from the selected cells (Ctrl + Shift + _ )
Applies the genereal number format (Ctrl + Shift + )
Applies the currency format with two decimal places (negative numbers in parentheses ) (Ctrl +Shift+$)
Applies the percentage format with no decimal places (Ctrl + Shift + % )
Applies the scientific number format with two decimal places (Ctrl + Shift + )
Applies the date format with the day, month, and year (Ctrl + Shift + # )
Applies the time format with the hour and minute, and AM or PM (Ctrl + Shift + @ )
Applies the number format with two decimal places, thousands separator and minus sign (−) for negative values (Ctrl + Shift + ! )
Selects the current region around the active cell (the data area enclosed by blank rows and blank columns )(Ctrl + Shift + *)
In a Pivot Table, it selects the entire Pivot Table report ( )
Enters the current time (Ctrl + Shift + : )
Copies the value from the cell above the active cell in the cell or the Formula Bar ( Ctrl + Shift + '')
Displays the insert dialog box to insert blank cells (Ctrl + Shift + Plus (+))
Displays the Delete dialog box to delete the selected cells (Ctrl + Minus (−) )
Enters the current date (Ctrl + ; )
Alternates between displaying cell values and displaying formulas in the worksheet (Ctrl +`)
Copies a formula from the cell above the active cell into the cell or the formula bar (Ctrl +')
Displays the format Cells dialog box (Ctrl +1)
Applies or removes bold formatting (Ctrl +2)
Applies or removes italic formatting (Ctrl +3)
Applies or removes underlining (Ctrl +4)
Applies or removes strikethrough (Ctrl +5)
Alternates between hiding and displaying objects (Ctrl +6)
Displays or hides the outline sympols (Ctrl +8)
Hides the selected rows (Ctrl +9)
Hides the selected columns (Ctrl +0)
Applies or removes bold formatting (Ctrl +B)
Copies the selected cells (Ctrl +C)
Uses the fill down command to a copythe contents and format of the topmost cell of a selected range into the cells below (Ctrl +D)
Invoke Flash Fill to automatically recognize patterns in adjacent columns and fill the current column (Ctrl +E)
Displays the Find and Replace dialog box, with the find tab selected (Ctrl +F)
Shift + F5 also displays this tab, while Shift + F4 repeats the last Find action ( )
Ctrl +Shift + F Opens the Format Cells dialog vox with the Font tab selected ( )
Displays the Go To Dialog box ( Ctrl + G )
F5 also displays this dialog box ( )
Displays the find and replace dialog box, with the replace ta selected (Ctrl + H)
Applies or removes italic Formatting (Ctrl + I )
Displays the Insert Hyperlink dialog box for new Hyperlinks or the edit Hyperlinkdialog box for selected existing Hyperlinks (Ctrl + K )
Displays the create Table dialog box (Ctrl + L )
Creates a new, blank workbook ( Ctrl + N)
Displays the open dialog box to open or fund a file (Ctrl + O )
Selects all Cells that contain comments (Ctrl + Shift + O )
Displays the print tab in Microsoft Office Backstage view (Ctrl + P )
Opens the Format Cells dialog box with the Font tab selected (Ctrl + Shift + P )
Displays the Quick Analysis Options for your data when you have cells that contain that data selected (Ctrl + Q )
Uses the Fill Right command to copy the contenrs and format of the leftmost cell of a selected range into the cells to the right (Ctrl + R )
Saves the active file with its current file name location and file format (Ctrl + S )
Displays the create Table dialog box (Ctrl + T )
Applies or removes underlining Ctrl + Shift + U Switches between expanding and collapsing of the formula bar (Ctrl + U )
Inserts the contents of the Clipboard at the insertion point and replaces any selection, Available only after you have cut or copied an object, text , or cell contents (Ctrl + V )
Displays the paste Special dialog box, Available only after you have cut or copied an object, text, or cell contents on a worksheet or in another program (Ctrl + Alt + V )
Closes the selected workbook window (Ctrl + W )
Cuts the selected cells (Ctrl + X )
Repeats the last command or action, if possible (Ctrl + Y )
Uses the Undo command to reverse the last command or to delete the last entry that you typed
(Ctrl + Z )