keyboard shortcut for paste special values

The copied values are get stored in clipboardĬtrl + V: To paste the copied values in the selected cellsĬtrl + Alt + V: This shortcut key displays the “Paste Special Box”. To perform “General” operations in excel sheetĬtrl + Z: Use this shortcut to “undo” the last change made in the excel sheetĬtrl + Y: Use this shortcut to “redo” the last change made in the excel sheetĬtrl + X: To cut the values of selected cellsĬtrl + C: To copy the values of selected cells. Using this option user can save the file at the required folder locationĬtrl + F4: This is used to close the current active excel workbook 2. To do “File” operations:Ĭtrl + O: To open required excel workbookĬtrl + S: To save current active excel workbookį12: This shortcut key is used for directly access the “Save As” option.

If you are looking for an way to improve your Excel skills sets, Check out some of the Best Excel Courses Online for less than $20 1. These 70 tips range from general to data operation. These should help you become much more efficient and leave more time to analyze and visualize your data. So, here is a collection of some of the most useful Excel Keyboard shortcuts. One thing that I love to do more than anything is save time.

Keyboard shortcut for paste special values