DOWNLOAD
Microsoft Excel is one of the most widely used spreadsheet software applications in the world, with millions of people relying on it for everything from simple calculations to complex data analysis. One of the most effective ways to use Excel efficiently is by learning and utilizing keyboard shortcuts. In this article, we'll take a look at some of the most useful Excel shortcuts that can help you save time and improve your productivity.
Alt+F4: Close Excel
Alt+F: Open the File tab/menu
Alt+H: Open the Home tab/menu
Alt+N: Open the Insert tab/menu
Alt+P: Open the Page Layout tab/menu
Alt+A: Open the Data tab/menu
Alt+R: Open the Review tab/menu
Alt+M: Open the Formulas tab/menu
Alt+W: Open the View tab/menu
Alt+Q: Close Excel and all open workbooks
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+F: Open the Find and Replace dialog box
Ctrl+H: Open the Find and Replace dialog box (Replace tab)
Ctrl+G: Open the Go To dialog box
Ctrl+K: Insert a hyperlink
Ctrl+L: Create a table
Ctrl+T: Insert a table
Ctrl+B: Bold text
Ctrl+I: Italicize text
Ctrl+U: Underline text
Ctrl+Y: Redo an action
Ctrl+D: Fill down
Ctrl+R: Fill right
Ctrl+Z: Undo an action
Ctrl+X: Cut selected cells
Ctrl+V: Paste copied cells
Ctrl+C: Copy selected cells
Ctrl+Shift+C: Copy the value from the cell above
Ctrl+Shift+V: Paste special
Ctrl+Shift+L: Turn on or off filters
Ctrl+Shift+* (asterisk): Select the current region around the active cell
Ctrl+Shift+~: Apply general number format
Ctrl+Shift+$: Apply currency format
Ctrl+Shift+%: Apply percentage format
Ctrl+Shift+#: Apply date format
Ctrl+Shift+@: Apply time format
Ctrl+Shift+!: Apply comma format
Ctrl+Shift+^: Apply exponential number format
Ctrl+Shift+_ (underscore): Remove borders
Ctrl+Shift+&: Add borders
Ctrl+Shift+: (colon): Insert current time
Ctrl+Shift+; (semicolon): Insert current date
Ctrl+Shift+Page Up: Select the current and previous sheet
Ctrl+Shift+Page Down: Select the current and next sheet
Ctrl+Shift+Home: Select from the current cell to the beginning of the worksheet
Ctrl+Shift+End: Select from the current cell to the end of the worksheet
Ctrl+Shift+F: Open the Format Cells dialog box
Ctrl+Shift+P: Create a pivot table
Ctrl+Shift+S: Open the Save As dialog box
Ctrl+Shift+T: Create a table
Ctrl+Shift+Z: Undo an undo
Ctrl+Shift+Enter: Enter a formula as an array formula
Ctrl+Alt+F1: Create a new worksheet
Ctrl+Alt+V: Paste special
Ctrl+Alt+F9: Calculate all worksheets in all open workbooks
Ctrl+Alt+F3: Open the Create Names dialog box
Ctrl+Alt+F5: Open the Excel Options dialog box
Ctrl+Alt+Arrow keys: Move to the
#webappninja