- Entering Data and Making Changes
- Entering Data
- Editing and Deleting Existing Data
- Zooming Into Your Data
- Undoing and Redoing Changes
- Copying and Pasting Data
- Freezing Rows and Columns
- Splitting a Worksheet
- Inserting Cells
- Deleting Cells
- Inserting and Deleting Rows
- Inserting and Deleting Columns
- Moving Data
- Finding Data
- Replacing Data
- Applying a Data Filter
- Sorting Data
- Adding and Managing Cell Comments
This chapter is from the book
This chapter is from the book
This chapter is from the book
Copying and Pasting Data
You can avoid the trouble of retyping duplicate information in a worksheet by cutting or copying data from one part of worksheet to another. For example, if you need to duplicate a column of data, there is no need to retype that data. You can copy the data and paste it where you need it. If you want to move the column, you can cut it from its location and paste it to a new location.
)
To copy and paste, click the first cell in the range you want to copy and then drag down to highlight the entire range.
Click the Copy command on the Home tab.
Click the cell to which you want the range to be pasted.
Click the Paste command on the Home tab. Excel duplicates your range.
)
To copy and paste, click the first cell in the range you want to copy and then drag down to highlight the entire range.
Click the Cut command on the Home tab.
Click the cell you want the range pasted to.
Click the Paste command on the Home tab. Excel moves your range.
Tip: Using Keyboard Shortcut Keys
A quick and easy way to copy and paste data is to use the Ctrl+C and Ctrl+V shortcuts. Hold down the Ctrl key while pressing the C key to copy. Then hold down the Ctrl key while pressing the V key to paste. To cut and paste, you can use the Ctrl+X and Ctrl+V shortcut key combinations.