Hi
Scott,
Yes, there are keyboard shortcuts for both
Paste Special Values and
Formats in
Microsoft Excel. Here are the steps to use them:
- For Paste Special Values:
- Select the cell or range of cells that you want to paste.
- Press Ctrl + C to copy the cells.
- Select the cell where you want to paste the values.
- Press Alt + E + S + V and then press Enter.
- For Paste Special Formats:
- Select the cell or range of cells that you want to copy the format from.
- Press Ctrl + C to copy the cells.
- Select the cell or range of cells where you want to apply the format.
- Press Alt + E + S + T and then press Enter.
These keyboard shortcuts work in all versions of
Microsoft Excel. They are a great way to save time and be more efficient when working with large amounts of data.
Formula:
//No macro or Visual Basic code found in the text