Home > Articles > Home & Office Computing > Microsoft Applications

  • Print
  • + Share This
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.

start.jpg

circle_1.jpg To copy and paste, click the first cell in the range you want to copy and then drag down to highlight the entire range.

circle_2.jpg Click the Copy command on the Home tab.

circle_3.jpg Click the cell to which you want the range to be pasted.

circle_4.jpg Click the Paste command on the Home tab. Excel duplicates your range.

cut-and-paste.jpg

circle_5.jpg To copy and paste, click the first cell in the range you want to copy and then drag down to highlight the entire range.

circle_6.jpg Click the Cut command on the Home tab.

circle_7.jpg Click the cell you want the range pasted to.

circle_8.jpg Click the Paste command on the Home tab. Excel moves your range.

end.jpg
  • + Share This
  • 🔖 Save To Your Account