Copy and Paste using Shortcuts

Creating and editing spreadsheets in Excel is most common in businesses. To easily edit information within a spreadsheet, you can copy and paste information from one cell to another. Copying and pasting can save a lot of your time when compared to retyping data into your Excel spreadsheets.

Copying and Pasting is a lot easier when done using keyboard shortcut instead of the mouse. Copying text can be useful if you need to duplicate words you have already typed as it saves time and effort.

In this article let us see how to copy selected text and paste it into another part of a document.

                                                                 Shortcuts
Ctrl + V Paste the last item from your clipboard
Ctrl + X Cut the active cell or selected range
Ctrl + Alt + V Paste special
Ctrl + Alt + V + B Skip blanks when pasting from your clipboard
Ctrl + Alt + V + C Only paste comments
Ctrl + Alt + V + D Add values to the paste range from the range in your clipboard
Ctrl + Alt + V + E Transpose when pasting from your clipboard
Ctrl + Alt + V + F Only paste formulas
Ctrl + Alt + V + H Paste all using the source theme
Ctrl + Alt + V + I Divide the paste range by values from the range in your clipboard
Ctrl + Alt + V + M Multiply paste range by values from the range in your clipboard
Ctrl + Alt + V + N Only paste data validation
Ctrl + Alt + V + R Only paste formula and number formatting
Ctrl + Alt + V + S Subtract values to the paste range from the range in your clipboard
Ctrl + Alt + V + T Only paste formats
Ctrl + Alt + V + U Only paste values and number formatting
Ctrl + Alt + V + V Only paste values
Ctrl + Alt + V + W Only paste column widths
Ctrl + Alt + V + X Paste all except any borders
About the author

FAME is a leading Accountancy training provider. FAME brings together under one roof a wide range of accounting courses blended with real world experience and practical application. FAME aims to bridge the gap between theoretical knowledge and practical challenges that accountants face in their day to day working. We provide practical workplace skills for finance staff meeting the needs of employers, bankers, government and learners, both now and in the future. Our students are integral to the success of an organisation and at the heart of ensuring the smooth running of an accounting department.