How to Cut and Paste in Excel
Learning to cut and paste data in Excel can make your life a whole lot easier. This technique allows you to take information from one or more spreadsheets and quickly combine or arrange data. When cutting information from a spreadsheet, you must be careful to promptly paste it or the information may be lost.
Open your Excel file by clicking on "File" and selecting "Open." Highlight the file you are working with and click "Open." If you are transferring data to a new spreadsheet, click "File" and select "New."
Select the data you want to cut by clicking on the cell containing the pertinent data. If your data is contained in more than one cell, click the top right cell and drag your mouse until all the cells with the pertinent data are highlighted.
Cut or remove the data from your spreadsheet by clicking on "Edit" and selecting "Cut." The data will immediately disappear from your screen.
Choose the cell where your data will be relocated. You can choose to simply move the data to a different area of your existing spreadsheet or you can move it to a new spreadsheet.
Click on the cell where you want the data to be placed. Click on "Edit" and select "Paste" to transfer the cut data.
Tips & Warnings
- If you accidentally cut or change data during the cut and paste process, you can easily go back to your starting point by clicking on "Edit" and selecting "Undo."
- You can also cut by selecting the data, holding down the "Ctrl" key and pressing the "X" key on your keyboard.
- You can also paste by clicking on the cell where you wish the data to be placed, holding down the "Ctrl" key and pressing the "V" key on your keyboard.
- Once you have pasted your data, you may need to adjust the size of your cells in order to view the data. Do this by positioning your cursor on the right edge of the cell and double clicking.