Microsoft Office Keyboard Shortcuts Matrix
Boost your daily productivity by 40% with dual Windows & macOS key combinations for Excel, PowerPoint, and Word. Filter by application or search by task.
Google AdSense Responsive Unit (horizontal)
Publisher ID: ca-pub-7444400132160337. Ad unit ready for live ad serving upon Google approval.
Flash Fill (Auto-detect & fill patterns)
Instantly splits, merges, or re-formats text based on the pattern you provide in the first cell.
AutoSum selected range
Inserts the SUM formula automatically for the row or column above or to the left.
Toggle Absolute Reference ($A$1)
Cycles cell references between absolute ($A$1), row absolute (A$1), column absolute ($A1), and relative (A1).
Create Excel Table
Converts the current data range into a structured Excel Table with sorting, filtering, and structured references.
Select entire data region
Selects the contiguous block of data surrounding the active cell.
Select Visible Cells Only
Crucial before copying filtered or grouped data to avoid copying hidden rows or columns.
Open Format Cells Dialog
Quickly opens the full formatting window for numbers, alignment, fonts, borders, and protection.
Insert Current Date
Stamps today’s static date into the active cell without recalculating in the future.
Insert Current Time
Stamps the current static timestamp into the active cell.
Open Paste Special Dialog
Allows pasting Values only, Formats only, Formulas, Column Widths, or mathematical operations (Multiply/Add).
Toggle Formula View (Show Formulas)
Switches the entire worksheet display between calculated results and raw formula expressions.
Jump to Edge of Data Region
Navigates instantly to the top, bottom, left, or rightmost cell with data in a continuous table.
Filter / Unfilter Data Table
Toggles AutoFilter dropdown arrows on the table header row.
Evaluate Formula Step-by-Step
Opens the formula auditor to debug nested IFs, XLOOKUPs, and complex math step-by-step.
Duplicate Selected Slide or Object
Creates a rapid clone of the selected shape, text box, or entire slide preserving exact coordinates.
Start Slide Show from Beginning
Launches full-screen presentation mode starting from slide 1.
Start Slide Show from Current Slide
Begins presentation playback directly on the slide you are currently editing.
Group Selected Shapes / Objects
Combines multiple selected elements into a single movable, scalable unit.
Ungroup Selected Elements
Breaks a grouped collection of shapes back into individual independent elements.
Copy Formatting (Format Painter)
Copies all visual formatting (fill color, stroke, font, shadows) from the selected shape.
Paste Formatting (Format Painter)
Applies copied visual styling to any other shape or text box with a single keystroke.
Toggle Black Screen during Presentation
Turns the projector screen pitch black to focus all audience attention back onto the speaker.
Toggle White Screen during Presentation
Turns the presentation screen pure white for interactive dry-erase whiteboard explanations.
Constrain Aspect Ratio while resizing
Prevents distorting images, icons, or geometric shapes while scaling.
Open Selection Pane (Layer Manager)
Opens the layer hierarchy to name, reorder, show, or hide overlapping design objects.
Change Case (Upper, Lower, Title Case)
Cycles the selected text through UPPERCASE, lowercase, and Capitalize Each Word.
Apply Heading 1 Style
Applies Heading 1 style to the current paragraph for automatic Table of Contents generation.
Apply Heading 2 Style
Applies Heading 2 sub-heading style to the selected paragraph.
Apply Normal Paragraph Style
Resets the paragraph styling back to default body text.
Clear Character Formatting
Removes manual font overrides, bold, italics, or odd font sizes, returning text to base style.
Insert Page Break
Forces subsequent text onto a clean new page without spamming the Enter key.
Open Find and Replace Dialog
Opens advanced find and replace for words, styles, special characters (paragraph breaks, tabs).
Toggle Track Changes
Turns revision tracking on or off to record edits, deletions, and comments in team review.
Insert Footnote
Inserts a numbered citation footnote at the bottom of the current page.
Spike (Cut multiple items & paste all at once)
Adds selected text to a cumulative clipboard buffer. Press Ctrl+Shift+F3 to paste all collected snippets.
Google AdSense Responsive Unit (auto)
Publisher ID: ca-pub-7444400132160337. Ad unit ready for live ad serving upon Google approval.