Paste Formulas and Number Formats
Select this option to copy both formulas and the number formatting (e.g., currency, dates, percentages) from the source cells, while ignoring other types of formatting such as cell color or font style.
| Shortcut | Windows | Mac |
|---|---|---|
| Paste Formulas and number formats | Ctrl Alt V , R | Cmd Ctrl V , R |
Relevant Excel Shortcuts
Discover related Excel keyboard shortcuts in the paste special options category.
Download Your Complete Excel Shortcuts Cheat Sheet
Get instant access to a comprehensive PDF guide of all Excel keyboard shortcuts available on our website. Perfect for quick reference and offline use for both Mac and Windows users. Click below to download your copy and boost your productivity today!
