How to Copy and Paste in Excel

By Techwalla Computers Editor

Creating and editing spreadsheets in Excel is commonplace in most businesses. To easily edit information within a spreadsheet, you can copy and paste information from one cell to another. Follow these steps and you will save time by copying and pasting instead of retyping data into your Excel spreadsheets.

Step 1

Open an existing Excel file to edit or create a new one. When creating a new file, select "New" from the "File" menu. To edit an existing file, select "Open" from the "File" menu.

Step 2

Enter data that you want to copy into a cell or identify a cell that you wish to copy that already has data in it. Select the text by highlighting the exact text you want to copy within the textbox at the top of the screen or by clicking the individual cell the text is in.

Step 3

Copy the selected text or cell by selecting "Copy" from the "Edit" menu at the top of the screen. You can also use a shortcut key by holding the "Ctrl" and "C" keys on your keyboard to copy the data. A third option would be to right-click your mouse and select "Copy" from the short-cut menu that pops up.

Step 4

Select the cell you wish to paste the copied text into by clicking on it. Paste the data into the selected cell by choosing "Paste" from the "Edit" menu. To use a shortcut key you can hold the "Ctrl" and "V" keys down to paste the data more quickly or right-click the mouse again and select "Paste" from the short-cut menu that pops up.

Step 5

Continue editing, copying and pasting data until all the data is entered in your spreadsheet. Save your work by selecting "Save" or "Save As" from the "File" menu.

Tips & Warnings

  • If you have trouble getting all the text in a cell to be highlighted by clicking it, simply click a different cell and then try to click the original cell again.