100 Important Short Keys
Ctrl + N: Create a new workbook.Ctrl + O: Open an existing workbook.
Ctrl + S: Save the current workbook.
Ctrl + P: Print the current workbook.
Ctrl + Z: Undo the last action.
Ctrl + Y: Redo the last action.
Ctrl + X: Cut the selected cells.
Ctrl + C: Copy the selected cells.
Ctrl + V: Paste the copied or cut cells.
Ctrl + A: Select all cells in the worksheet.
Ctrl + B: Apply or remove bold formatting.
Ctrl + I: Apply or remove italic formatting.
Ctrl + U: Apply or remove underlined formatting.
Ctrl + L: Insert a table.
Ctrl + R: Fill the rightmost cell of a selected range with the contents of the leftmost cell.
Ctrl + E: Flash fill the selected range.
Ctrl + J: Justify the cell content.
Ctrl + K: Insert a hyperlink.
Ctrl + D: Fill down.
Ctrl + H: Replace content in cells.
Ctrl + G: Go to a specific cell or range.
Ctrl + W: Close the workbook.
Ctrl + Shift + N: Create a new worksheet.
Ctrl + Shift + F: Display the Format Cells dialog box.
Ctrl + Shift + P: Insert a page break.
Ctrl + Shift + S: Apply strikethrough formatting.
Ctrl + Shift + U: Toggle uppercase/lowercase of the selected text.
Ctrl + Shift + L: Apply or remove filter.
Ctrl + Shift + F3: Create a name using the names of the selected cells.
Ctrl + Shift + ~: Apply the General number format.
Ctrl + Shift + $: Apply the Currency number format.
Ctrl + Shift + %: Apply the Percentage number format.
Ctrl + Shift + #: Apply the Date format.
Ctrl + Shift + @: Apply the Time format.
Ctrl + Shift + !: Apply the Number format with two decimal places, thousands separator, and minus sign for negative values.
Ctrl + Shift + &: Apply an outline border to the selected cells.
Ctrl + Shift + _: Remove the outline border from the selected cells.
Ctrl + Shift + *: Select the current region around the active cell.
Ctrl + Shift + Arrow keys: Extend the selection to the last non-empty cell in the same column or row as the active cell.
Ctrl + Shift + Home: Select the entire worksheet.
Ctrl + Shift + End: Extend the selection to the last cell used on the worksheet (lower-right corner).
Ctrl + Shift + Page Up/Page Down: Switch between worksheets.
Ctrl + Shift + Tab: Move to the previous worksheet.
Ctrl + Shift + F12: Save the workbook.
Ctrl + Shift + F6: Switch between open workbooks.
Ctrl + Shift + F9: Calculate all worksheets in all open workbooks.
Ctrl + Shift + F10: Display the shortcut menu.
Ctrl + Shift + F11: Insert a new worksheet.
Ctrl + Shift + F12: Open the Save As dialog box.
Ctrl + Alt + V: Paste special.
F2: Edit the active cell.
F4: Repeat the last action.
F5: Go to a specific cell.
F7: Spell check the selected text or document.
F9: Calculate the selected formula.
F11: Create a chart of the selected data.
F12: Open the Save As dialog box.
Alt + =: AutoSum selected cells.
Alt + Enter: Insert a line break within a cell.
Alt + Tab: Switch between open applications.
Alt + Shift + F1: Insert a new worksheet.
Alt + Shift + Arrow keys: Adjust the column width or row height.
Alt + Shift + F10: Display the right-click menu.
Alt + Shift + F11: Insert a new Microsoft Excel 4.0 macro sheet.
Alt + Shift + F9: Calculate all worksheets in all open workbooks.
Alt + Shift + F3: Create a name using the names of the selected cells.
Alt + Shift + F6: Switch between open workbooks.
Alt + Shift + F8: Run a macro.
Alt + Shift + F11: Visual Basic for Applications (VBA) editor.
Alt + Down Arrow: Open a drop-down menu for the selected cell.
Alt + Up/Down Arrow: Move to the previous or next item in the drop-down menu.
Alt + Left/Right Arrow: Move to the previous or next toolbar.
Alt + Page Up/Page Down: Move to the previous or next worksheet.
Alt + Spacebar: Display the control menu for the Excel window.
Alt + Enter: Start a new line in the same cell.
Alt + F1: Create an embedded chart of the data in the current range.
Alt + F4: Close the Excel application.
Alt + F8: Open the Macro dialog box.
Alt + F11: Open the Visual Basic for Applications (VBA) editor.
Alt + F12: Save As.
Ctrl + Shift + $: Apply currency formatting.
Ctrl + Shift + #: Apply date formatting.
Ctrl + Shift + %: Apply percentage formatting.
Ctrl + Shift + ^: Apply exponential formatting.
Ctrl + Shift + @: Apply time formatting.
Ctrl + Shift + !: Apply number formatting.
Ctrl + Shift + &: Apply outline border to selected cells.
Ctrl + Shift + _: Remove outline border from selected cells.
Ctrl + Shift + *: Select the current region around the active cell.
Ctrl + Shift + Arrow keys: Extend selection to last non-empty cell in the same column or row as the active cell.
Ctrl + Shift + Home: Select the entire worksheet.
Ctrl + Shift + End: Extend selection to last used cell on the worksheet (lower-right corner).
Ctrl + Shift + Tab: Switch to the previous workbook.
Ctrl + Shift + F6: Switch to the previous workbook window.
Ctrl + Alt + V: Display the Paste Special dialog box.
Ctrl + Alt + F9: Calculate all worksheets in all open workbooks, regardless of whether they have changed since the last calculation.
Ctrl + Alt + Shift + F9: Recheck dependent formulas and then calculates all cells in all open workbooks, including cells not marked as needing to be calculated.
Ctrl + Alt + Shift + F10: Display the menu or message for an Error Checking button.
Ctrl + Alt + F11: Display the Microsoft Script Editor.
No Comment to " Excel Short Keys "