• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Moving Data

Select the cells you want to move.

Click the border of the selected cells and drag the cells to the location in the worksheet where you want to paste the cell data.

Release the mouse button to drop the data in its new location.

INTRODUCTION

Excel lets you move information from one cell into another cell, which means you do not have to type the data into the new cell and then erase the data in the old location. You might want to move data in a worksheet because the layout of the worksheet has changed.


TIP

Undoing a move

If you move the wrong data or move the data to the wrong location, click the Undo button on the Standard toolbar to undo the most recent move. Then start over. (See the task ”Undoing and Redoing Changes” earlier in this part for more information.)


  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint