The Easy Shortcut Key for Paste Special in Excel
Excel is a powerful spreadsheet application that offers numerous features and functionalities to help users manage and analyze data efficiently. One of the most useful features in Excel is theΒ Paste SpecialΒ option, which allows you to paste data with specific formatting or perform mathematical operations while pasting. In this article, weβll explore theΒ shortcut key for Paste Special in ExcelΒ and how to use it effectively.
What is the Shortcut Key for Paste Special in Excel?
The shortcut key for Paste Special in Excel isΒ Ctrl + Alt + VΒ for Windows users andΒ Command + Option + VΒ for Mac users. By pressing these keys simultaneously, you can quickly access the Paste Special dialog box without having to navigate through the ribbon menu.
How to Use the Paste Special Shortcut Key in Excel
To use the Paste Special shortcut key in Excel, follow these simple steps:
- Select the cell or range of cells containing the data you want to copy.
- PressΒ Ctrl + CΒ (Windows) orΒ Command + CΒ (Mac) to copy the selected data.
- Select the cell or range of cells where you want to paste the data.
- PressΒ Ctrl + Alt + VΒ (Windows) orΒ Command + Option + VΒ (Mac) to open the Paste Special dialog box.
- Choose the desired paste option from the dialog box and clickΒ OK.
Different Paste Special Options in Excel
The Paste Special dialog box offers several options for pasting data in Excel. Here are some of the most commonly used options:
Paste Values
TheΒ Paste ValuesΒ option allows you to paste only the values from the copied cells, without any formatting or formulas. This is useful when you want to preserve the original formatting of the destination cells.
To use the Paste Values option, follow these steps:
- Copy the data you want to paste.
- Select the destination cells.
- PressΒ Ctrl + Alt + VΒ (Windows) orΒ Command + Option + VΒ (Mac) to open the Paste Special dialog box.
- SelectΒ ValuesΒ from the list of options.
- ClickΒ OK.
Alternatively, you can use the shortcutΒ Ctrl + Shift + VΒ (Windows) orΒ Command + Shift + VΒ (Mac) to directly paste values without opening the Paste Special dialog box.
You can also use the key combination ALT + E + S + V to directly paste values in excel. Hereβs how you can use it:
- Copy the cell range containing the values you want to paste.
- Press the ALT key on your keyboard.
- While holding the ALT key, press the E key, followed by the S key, and then the V key.
- This shortcut combination will open the Paste Special options.
- Select the βValuesβ option.
- Finally, click on the βOKβ button to paste the copied values.
Paste Formulas
TheΒ Paste FormulasΒ option pastes only the formulas from the copied cells, without any formatting or values. This is helpful when you want to apply the same formulas to a different set of data.
To use the Paste Formulas option, follow these steps:
- Copy the cells containing the formulas you want to paste.
- Select the destination cells.
- PressΒ Ctrl + Alt + VΒ (Windows) orΒ Command + Option + VΒ (Mac) to open the Paste Special dialog box.
- SelectΒ FormulasΒ from the list of options.
- ClickΒ OK.
You can also use the shortcutΒ Ctrl + Shift + FΒ (Windows) orΒ Command + Shift + FΒ (Mac) to directly paste formulas without opening the Paste Special dialog box.
Paste Formats
TheΒ Paste FormatsΒ option allows you to paste only the formatting from the copied cells, without any values or formulas. This is useful when you want to apply the same formatting to a different set of data.
To use the Paste Formats option, follow these steps:
- Copy the cells containing the formatting you want to paste.
- Select the destination cells.
- PressΒ Ctrl + Alt + VΒ (Windows) orΒ Command + Option + VΒ (Mac) to open the Paste Special dialog box.
- SelectΒ FormatsΒ from the list of options.
- ClickΒ OK.
Alternatively, you can use the shortcutΒ Ctrl + Alt + EΒ (Windows) orΒ Command + Option + EΒ (Mac) to directly paste formats without opening the Paste Special dialog box.
Paste Links
TheΒ Paste LinksΒ option creates a dynamic link between the copied cells and the destination cells. This means that any changes made to the original data will be automatically reflected in the linked cells.
To use the Paste Links option, follow these steps:
- Copy the cells you want to link.
- Select the destination cells.
- PressΒ Ctrl + Alt + VΒ (Windows) orΒ Command + Option + VΒ (Mac) to open the Paste Special dialog box.
- SelectΒ Paste LinkΒ from the list of options.
- ClickΒ OK.
Mathematical Operations with Paste Special
In addition to pasting data with specific formatting, the Paste Special feature in Excel also allows you to perform mathematical operations while pasting. This can save you time and effort when working with large datasets.
Here are some of the mathematical operations you can perform using Paste Special:
Operation | Description |
---|---|
Add | Adds the copied values to the existing values in the destination cells. |
Subtract | Subtracts the copied values from the existing values in the destination cells. |
Multiply | Multiplies the existing values in the destination cells by the copied values. |
Divide | Divides the existing values in the destination cells by the copied values. |
To perform a mathematical operation using Paste Special, follow these steps:
- Copy the cells containing the values you want to use in the operation.
- Select the destination cells.
- PressΒ Ctrl + Alt + VΒ (Windows) orΒ Command + Option + VΒ (Mac) to open the Paste Special dialog box.
- Select the desired mathematical operation from theΒ OperationΒ section.
- ClickΒ OK.
Additional Paste Special Shortcuts
Besides the main Paste Special shortcut key, there are a few additional shortcuts that can help you quickly access specific Paste Special options:
- Ctrl + Alt + SΒ (Windows) orΒ Command + Option + SΒ (Mac): Pastes only the column widths from the copied cells.
- Ctrl + Alt + UΒ (Windows) orΒ Command + Option + UΒ (Mac): Pastes only the borders from the copied cells.
- Ctrl + Alt + RΒ (Windows) orΒ Command + Option + RΒ (Mac): Pastes only the comments from the copied cells.
- Ctrl + Alt + WΒ (Windows) orΒ Command + Option + WΒ (Mac): Pastes only the validation rules from the copied cells.
Tips for Using the Paste Special Shortcut Key Efficiently
Here are some tips to help you use the Paste Special shortcut key more efficiently:
Use the Keyboard
Instead of navigating through the ribbon menu to access the Paste Special dialog box, use the keyboard shortcutΒ Ctrl + Alt + VΒ (Windows) orΒ Command + Option + VΒ (Mac). This will save you time and increase your productivity.
Memorize the Most Common Options
Familiarize yourself with the most commonly used Paste Special options, such asΒ Values,Β Formulas, andΒ Formats. This will help you quickly select the desired option without having to search through the list.
Combine with Other Shortcuts
You can combine the Paste Special shortcut key with other Excel shortcuts to perform tasks more efficiently. For example, you can useΒ Ctrl + CΒ (Windows) orΒ Command + CΒ (Mac) to copy data, then useΒ Ctrl + Alt + VΒ (Windows) orΒ Command + Option + VΒ (Mac) to paste it with a specific formatting or mathematical operation.
Create Custom Keyboard Shortcuts
If you frequently use a specific Paste Special option, you can create a custom keyboard shortcut for it. To do this, go toΒ File > Options > Customize RibbonΒ (Windows) orΒ Excel > Preferences > Keyboard ShortcutsΒ (Mac), and assign a new shortcut to the desired Paste Special command.
Final Thoughts
TheΒ Paste Special shortcut key (Ctrl + Alt + V for Windows and Command + Option + V for Mac)Β is a powerful tool in Excel that allows you to paste data with specific formatting or perform mathematical operations while pasting. By mastering this shortcut key and understanding the various Paste Special options, you can save time and increase your productivity when working with Excel spreadsheets.
Remember to use the keyboard, memorize the most common options, and combine the Paste Special shortcut key with other Excel shortcuts to streamline your workflow. Additionally, take advantage of the additional Paste Special shortcuts and consider creating custom keyboard shortcuts for frequently used options.
FAQs
What is the shortcut key for Paste Special in Excel?
What are the different Paste Special options in Excel?
- Paste Values
- Paste Formulas
- Paste Formats
- Paste Links
Can I perform mathematical operations using Paste Special in Excel?
Are there any additional Paste Special shortcuts in Excel?
- Ctrl + Alt + S (Windows) or Command + Option + S (Mac): Pastes only the column widths from the copied cells.
- Ctrl + Alt + U (Windows) or Command + Option + U (Mac): Pastes only the borders from the copied cells.
- Ctrl + Alt + R (Windows) or Command + Option + R (Mac): Pastes only the comments from the copied cells.
- Ctrl + Alt + W (Windows) or Command + Option + W (Mac): Pastes only the validation rules from the copied cells.
How can I create a custom keyboard shortcut for a specific Paste Special option in Excel?

Vaishvi Desai is the founder of Excelsamurai and a passionate Excel enthusiast with years of experience in data analysis and spreadsheet management. With a mission to help others harness the power of Excel, Vaishvi shares her expertise through concise, easy-to-follow tutorials on shortcuts, formulas, Pivot Tables, and VBA.