Excel Shortcut Keys Library
Speed up your daily workflow 10x with authentic 3D keyboard shortcuts organized by category. Toggle between Windows and Mac key combinations instantly.
Copy Selection
Copies the selected cells, values, or objects to clipboard.
Paste Clipboard Content
Pastes copied content at the active cell location.
Cut Selection
Cuts selected cells for moving to another location.
Undo Last Action
Reverses the previous cell edit, formatting, or command.
Redo / Repeat Action
Redoes previous undone action or repeats last command.
Save Workbook
Quickly saves changes to the current active Excel file.
Find Text or Numbers
Opens the Find tab to search within sheet or workbook.
Find & Replace
Opens Replace tab to bulk substitute strings and formulas.
Edit Active Cell
Enters edit mode and places the cursor at the end of cell.
Create an Excel Table
Instantly converts selected range into a structured dynamic Table.
Select Entire Worksheet
Selects all cells on current sheet (or entire current table).
Repeat Last Command
Repeats your last formatting or action onto the selected cells.
Jump to Edge of Data
Jumps cursor to the last non-empty cell in the arrow direction.
Jump to First Cell (A1)
Instantly returns to the top-left cell A1 of the worksheet.
Jump to Last Used Cell
Navigates to the bottom-right used cell with data/formatting.
Next Worksheet
Switches to the next sheet tab on the right.
Previous Worksheet
Switches to the previous sheet tab on the left.
Open Go To Dialog
Quickly jumps to any specified cell reference (e.g. AZ1000).
Switch Open Workbooks
Cycles focus between open Microsoft Excel window documents.
Extend Selection to Edge
Highlights all cells up to the next non-empty cell in the direction.
Select Entire Row
Selects all columns in the currently active row.
Select Entire Column
Selects all rows in the currently active column.
Select Visible Cells Only
Selects only non-hidden cells in a filtered table or outline.
Scroll to Active Cell
Brings the active cell back into view without unselecting range.
Open Format Cells Dialog
Opens complete formatting dialog (Numbers, Font, Border, Fill).
Toggle Bold Style
Applies or removes bold font weight from selected text/numbers.
Toggle Italic Style
Applies or removes italic slant styling.
Toggle Underline
Applies single underline underneath cell content.
Format as Currency ($)
Quickly formats numbers as currency with two decimal places.
Format as Percentage (%)
Applies percentage format with zero decimal places.
Format as Date (DD-MMM-YY)
Converts serial numbers into standard readable date format.
Format as Standard Number
Formats numbers with thousands comma separator and 2 decimals.
Apply General Format
Clears specific number formatting back to standard General.
Toggle Strikethrough
Applies a strike line through the middle of cell text.
AutoSum Adjacent Numbers
Inserts a SUM formula automatically across continuous rows/columns.
Toggle Absolute References ($A$1)
In formula bar, cycles $A$1 -> A$1 -> $A1 -> A1 reference lock.
Show / Hide All Formulas
Toggles between showing formula results and formula text on sheet.
Insert Current Date
Pumps current static date directly into the active cell.
Insert Current Time
Pumps current static timestamp (HH:MM) into the cell.
Insert Function Dialog
Opens function builder wizard to search arguments for functions.
Calculate All Worksheets
Forces full recalculation of formulas across all open workbooks.
Evaluate Formula Expression
Highlights part of a formula and presses F9 to preview computed result.
Expand / Collapse Formula Bar
Expands the formula bar height to comfortably view multi-line formulas.
Toggle AutoFilter On/Off
Toggles filter dropdowns on the selected table or header row.
Flash Fill Pattern
Automatically extracts or combines text based on recognized patterns.
Fill Down from Above
Fills content and formula from cell immediately above into selection.
Fill Right from Left
Fills content and formula from cell immediately to left into selection.
Insert Cells / Rows / Columns
Opens insert dialog or inserts full selected row/column.
Delete Cells / Rows / Columns
Opens delete dialog or deletes full selected row/column.
Hide Selected Rows
Hides current rows from view in worksheet.
Unhide Selected Rows
Unhides any hidden rows inside the current selection.
Hide Selected Columns
Hides current columns from view in worksheet.
Open Filter Dropdown
Opens header dropdown filter menu or cell validation list.
Create New Workbook
Spawns a clean blank Excel workbook document.
Open Existing Workbook
Opens file picker to locate and open Excel workbooks.
Close Current Workbook
Closes the current workbook window without quitting Excel.
Insert New Worksheet Tab
Instantly adds a new blank worksheet into the workbook.
Save As Dialog
Opens Save As dialog to choose file name, path, or format (XLSX, CSV, PDF).
Show / Hide Ribbon Bar
Minimizes or expands the Excel ribbon toolbars to maximize screen space.
Create Instant Embedded Chart
Generates a default column chart on the active worksheet instantly.
Create Chart on New Sheet
Generates a dedicated full-screen chart sheet in the workbook.
Refresh Active PivotTable
Refreshes data cache and updates the currently active PivotTable.
Refresh All PivotTables & Connections
Refreshes all queries, external data, and pivot tables across the workbook.
Insert Hyperlink
Opens hyperlink dialog to link to URL, email, or another sheet cell.
Insert / Edit Cell Note
Opens note popup box to attach documentation to the active cell.
Want to build muscle memory on real keyboard drills?
Test your speed in our interactive Shortcut Trainer. Beat the timer, earn mastery badges, and build keyboard-only speed!