Excel shortcuts

The 5 Best Excel Match Destination Formatting Shortcuts

If you're like most Excel users, you probably spend a lot of time reformatting data that you've copied and pasted from one place to another. Maybe you've even written a macro or two to automate the process. But there's a better way. With a little bit of knowledge about Excel's "Paste Special" feature, you can save yourself a lot of time and effort.

Here are the five best Excel "Paste Special" destination formatting shortcuts:

  1. Paste Special Destination Formatting Shortcut #1: Paste Values and Number Formats

If you want to paste just the values and number formats from your source data, select the destination cells and then use this shortcut:

Ctrl+Alt+V, V

This shortcut will paste the values and number formats from your source data, but it will not paste any other formatting (e.g., font size, bold, etc.).

  1. Paste Special Destination Formatting Shortcut #2: Paste Formulas and Number Formats

If you want to paste just the formulas and number formats from your source data, select the destination cells and then use this shortcut:

Ctrl+Alt+V, F

This shortcut will paste the formulas and number formats from your source data, but it will not paste any other formatting (e.g., font size, bold, etc.).

  1. Paste Special Destination Formatting Shortcut #3: Paste Column Widths

If you want to paste just the column widths from your source data, select the destination cells and then use this shortcut:

Ctrl+Alt+V, W

This shortcut will paste the column widths from your source data, but it will not paste any other formatting (e.g., font size, bold, etc.).

  1. Paste Special Destination Formatting Shortcut #4: Paste All Except Borders

If you want to paste all of the formatting from your source data except for the borders, select the destination cells and then use this shortcut:

Ctrl+Alt+V, B

This shortcut will paste all of the formatting from your source data except for the borders. So, if your source data has bold text and a yellow background, those formatting features will be applied to the destination cells.

  1. Paste Special Destination Formatting Shortcut #5: Paste All

If you want to paste all of the formatting from your source data, select the destination cells and then use this shortcut:

Ctrl+Alt+V, A

This shortcut will paste all of the formatting from your source data, including the borders. So, if your source data has bold text and a yellow background, those formatting features will be applied to the destination cells.

There you have it! Five shortcuts that will save you time and effort when reformatting data in Excel. Give them a try the next time you need to copy and paste data from one place to another.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.