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:
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.).
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.).
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.).
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.
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.