How to Copy and Paste in Excel

How to Copy and Paste in Excel. 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

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

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

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

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

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.