Summary of useful keyboard shortcuts in excel
Format cells
Ctrl + 1: Display the Format dialog box.
Ctrl + B: Add or remove bold formatting.
Ctrl + I: Add or cancel italic format.
Ctrl + U: Add or remove an underline.
Ctrl + 5: Add or cancel dash formatting.
Alt + ': Display the Style dialog box.
Number format
Ctrl + Shift + $: Format currency with two decimal places.
Ctrl + Shift + ~: General number format
Ctrl + Shift +%: Format percent without decimal places.
Ctrl + Shift + #: Format dates by style: day, month and year.
Ctrl + Shift + @: Format time with hours, minutes
Ctrl + Shift +! Key: Format numbers with two decimal places and minus sign (-) for negative values.
Ctrl + Shift + ^: Format numbers with two decimal places.
F4: Repeat the selection of the last format, frozen rows and columns
Align the cell
Alt + H, A, R: Align cell to the right
Alt + H, A, C: Center the cell
Alt + H, A, L: Align cell to the left
Recipe
Alt + =: Insert the AutoSum formula.
Shift + F3: Open the Insert Function dialog box.
Ctrl + A: Open input method after entering the name of the formula.
Ctrl + Shift + A: Insert arguments in a formula after entering the name of the formula.
shift + F3: Insert a function into a formula.
Ctrl + Shift + Enter: Enter a formula as an array formula.
F4: After typing a cell reference (e.g. = E3) as an absolute reference (= $ E $ 4)
F9: Calculate all worksheets in all worksheets.
Shift + F9: Calculate the active worksheet.
Ctrl + Shift + U: Switch the mode to expand or collapse the formula bar.
Ctrl + `: Switch the mode to display formulas in cells instead of values
Edit the contents of the cells
Ctrl + D: Copy content in the box above
Ctrl + R: Copy cell to the left
Ctrl + ": Copy the cell contents above and in the editing state
Ctrl + ': Copy the formula of the cell above and in the editing state.
Ctrl + -: Open menu to delete cells or rows or columns
Ctrl + Shift + +: Open the menu to insert cells or rows or columns
Shift + F2: Insert or edit a comment box
Shift + f10, then m: Delete the comment
Alt + F1: Create and insert a chart with data in the current range
F11: Create and insert a chart with data in the current range in a separate chart sheet
Ctrl + KS: Insert a link
Enter (in a cell containing the link): Activate the link.
Hide and unhide data
Ctrl + 9: Hide selected rows
Ctrl + Shift + 9: Unhide hidden rows in a selection containing that row.
Ctrl + 0 (number 0): Hide the selected column.
Ctrl + Shift + 0 (number 0): Unhide the column that is currently hidden in the selection
Alt + Shift + Right arrow: Group rows or columns.
Alt + Shift + left arrow: Un groups rows or columns.
Move
Arrow Keys: Move up or down or left or right in a worksheet.
Page Down or Page Up: Move to the bottom of the worksheet to the top of the worksheet
Alt + Page Down or Alt + Page Up: Move the screen right or left in a worksheet.
Tab or Shift + Tab: Move a cell to the right or left in a worksheet.
Ctrl + arrow key: Move to the edge of the data area
Home: Move to the first cell of a row in a worksheet.
Ctrl + Home: Move to the first cell of a worksheet.
Ctrl + End: Move to the last cell containing content on a worksheet.
Ctrl + F: Search
Ctrl + H: Replace
Shift + F4: Repeat the previous search
Ctrl + G (or f5): Open the 'Go to' dialog box.
Ctrl + left arrow or Ctrl + Right arrow: Inside a cell: Move to the left / right cell of that cell.
Alt + down arrow: Display the AutoComplete list
You should read it
Office information
Useful keyboard shortcuts in Microsoft Word (Part 1)
Useful keyboard shortcuts in Microsoft Word (Part 2)
Useful keyboard shortcuts in Microsoft Word (Part 3)
How to page numbering and create Header, Footer in odd and even pages in Word 2007 and 2010
How to set a password for a column of data in excel
Instructions for inserting Pictures and Clip Art in PowerPoint