How to Move Information Inside an Excel Spreadsheet

When you are editing an Excel spreadsheet, you may want to move information inside your Excel spreadsheet to a different location within the same spreadsheet. You can do this by either moving the content of a cell or multiple cells or moving a whole sheet to a new location within your spreadsheet. Follow the steps below to use these two methods to move information inside your Excel spreadsheet.

Difficulty: Easy

Instructions

Things You'll Need:

• Microsoft Excel 2003

Move Cell Content Inside an Excel Spreadsheet

1. Start Microsoft Excel, and open a spreadsheet that contains data that you would like to move to a different area within the spreadsheet.

2. Select a cell or group of cells that you would like to cut and paste to a new location by clicking and dragging with your mouse over the cell(s).

3. Right-click on top of the selected cell(s) and choose "Cut" from the shortcut menu to delete the content from the cell(s) and add them to the Excel clipboard.

4. Click in the cell(s) where you would like the cell content that you just copied to the clipboard to be moved.

5. Use your mouse to right-click and select "Paste" from the shortcut menu to finish moving the information to it's new location within your spreadsheet.

Move a Worksheet Inside an Excel Spreadsheet

6. Locate the "Sheet" tabs at the bottom of your Excel spreadsheet.

7. Click on the sheet tab that refers to the worksheet you would like to move inside the Excel spreadsheet.

8. Drag the sheet tab either to the right or left and release the mouse button when the sheet tab appears in the desired location.