Monday, September 16, 2013

How to Move Information Inside an Excel Spreadsheet


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.

Blogger news