Explain how to move information in a worksheet from one location to another? (Excel-2007)
Q. Explain how to move information in a worksheet from one location to another. ?
Ans. You can move content of a cell or range of cells using different methods. You must first select the cell or range of cells to move the data
1. You can use cut and paste command to copy. Select Home Button /Clipboard/CUT, transfers contents of the selected cell or range of cells to the clipboard. After performing this, select the cell where you want to copy cell or range of cells and then choose Home/Clipboard/Paste option. Or you can just press the enter key in the destination cell.
2. You can use shortcut menu commands for cut and paste. After selecting the cell or range of cells right click the range and choose cut from the shortcut menu.
Activate the destination cell right click and choose paste from the shortcut menu. Or Press the enter key.
3. You can also use the shortcut key Control+ X to Cut and Control +V to Paste.
4. Drag and Drop method can also be used to move contents of a cell or range of cells. Select the cell or range of cells move the mouse to one of the selection border, now the mouse pointer is augmented with a Four Headed Arrow and then simply drag the selection to its new location.
0 comments:
Post a Comment