Paste Values
Access KeyStrip formulas and keep only the visible values.
Primary sequence
Alt, E, S, V, Enter
Alternative
Ctrl+Alt+V, V, Enter
Where it helps: A default move before reviews, handoffs, and breaking external links.
All 66 shortcuts · Mac/Windows
Complete coverage from Ctrl+C, Ctrl+V, F2 to advanced shortcuts. Boost your Excel efficiency.
Create a new Excel workbook.
Open an existing workbook.
Save the current workbook.
Save a copy with a new file name.
Open the print preview and print settings.
Close the current workbook.
Copy the selected cells or range.
Cut the selected cells or range.
Paste the copied or cut content.
Choose whether to paste values, formulas, formats, and more.
Copy the cell above downward.
Copy the cell on the left to the right.
Fill values automatically based on a detected pattern.
Undo the last action.
Redo an action that was undone.
Insert the current date.
Edit the active cell in place.
Remove values or formulas while keeping the formatting.
Insert a SUM formula automatically.
Insert a line break within the same cell.
Insert or edit a note/comment.
Repeat the last action.
Insert a hyperlink into the selected cell.
Insert the current time.
Copy the formula from the cell above.
Toggle between values and displayed formulas.
Toggle relative and absolute references inside a formula.
Apply bold formatting.
Apply italic formatting.
Underline text.
Open the Format Cells dialog.
Apply the Number format.
Apply the Time format.
Apply the Date format.
Apply the Currency format.
Apply the Percentage format.
Apply the Exponential format.
Insert cells, rows, or columns at the selection.
Delete selected cells, rows, or columns.
Hide the selected row.
Hide the selected column.
Reveal hidden rows.
Reveal hidden columns.
Toggle AutoFilter on the current range.
Convert the selected range into an Excel table.
Open a filter dropdown from the keyboard.
Select the current region, then the whole sheet when pressed again.
Jump to the edge of a contiguous data range.
Extend the selection to the edge of a contiguous range.
Select the entire column of the active cell.
Select the entire row of the active cell.
Move to the next worksheet tab.
Move to the previous worksheet tab.
Extend the sheet selection to the next worksheet.
Extend the sheet selection to the previous worksheet.
Jump to a specific cell or named range.
Search for text or values in the worksheet.
Replace text or values in bulk.
Move one cell up within the active selection.
Move one cell left within the active selection.
Jump to cell A1.
Jump to the bottom-right cell of the used range.
Extend the selection from the active cell back to A1.
Extend the selection to the bottom-right of the used range.
Insert a new worksheet into the workbook.
Recalculate the entire workbook.
Recalculate the active worksheet.
Refresh all data connections and queries.
Create an embedded chart from the selection.
These Alt sequences are access keys rather than true shortcuts, but they show up constantly in real modeling work. They can change with ribbon configuration or Excel version.
Strip formulas and keep only the visible values.
Primary sequence
Alt, E, S, V, Enter
Alternative
Ctrl+Alt+V, V, Enter
Where it helps: A default move before reviews, handoffs, and breaking external links.
Move formulas without bringing over the source formatting.
Primary sequence
Alt, E, S, F, Enter
Alternative
Ctrl+Alt+V, F, Enter
Where it helps: Useful when the destination already has the right layout and formatting.
Transfer formatting only while keeping destination values and formulas intact.
Primary sequence
Alt, E, S, T, Enter
Alternative
Ctrl+Alt+V, T, Enter
Where it helps: A fast way to standardize layout before sharing or reviewing a model.
Resize selected columns to fit their contents instantly.
Primary sequence
Alt, H, O, I
Where it helps: A core clean-up move when making wide models review-ready.
Quickly fix row height after wrapped text or notes change the layout.
Primary sequence
Alt, H, O, A
Where it helps: Especially useful for note-heavy schedules and comment columns.
Keep key headers or columns visible while scrolling through large models.
Primary sequence
Alt, W, F, F
Where it helps: Makes review passes faster because context does not disappear while you scroll.
Add rows without breaking flow or reaching for the mouse.
Primary sequence
Alt, I, R
Alternative
Ctrl+Shift++
Where it helps: Common when adding bridge rows, assumptions, or sensitivity blocks.
Insert comparison or helper columns quickly from the keyboard.
Primary sequence
Alt, I, C
Alternative
Ctrl+Shift++
Where it helps: Useful when adding prior-year, variance, or notes columns.
Collapse detail sections so reviewers can move between summary and detail quickly.
Primary sequence
Alt, D, G, G
Where it helps: Great for hiding support schedules while keeping the summary visible.
Remove outline groups when the structure has become noisy or outdated.
Primary sequence
Alt, D, G, U
Where it helps: Useful during cleanup after review cycles or model rebuilds.
Merged cells often break sorting, references, and model maintenance.
Leaving live links in place invites broken references and accidental updates.
A good model is not only correct; it is easy to review without friction.
Whether you want to review shortcuts first or jump straight into drills, this page keeps both paths simple and immediate.