Tip of the Day | Thursday 8 October 2026

Discover new tools to get things done.

Paste Values and Formatting

Quickly paste both values and formatting in a single step.
This eliminates the need to use Excel's built-in Paste Special twice, once for values and once for formatting, making your workflow more efficient.

How to use:
1. Copy your data range (e.g., with Ctrl+C).
2. Select the destination cell or range.
3. Run this tool to paste both values and formatting instantly.

Starting this tool

Specify a Keyboard Shortcut: ASAP Utilities  › My Tools & Shortcuts › Manage My Tools & Shortcuts...

Tip:Alt+P for the previous tool.