Explain how to copy information in a worksheet from one location to another. (Excel-2007)

Q. Explain how to copy information in a worksheet from one location to another.

Ans. You can copy a cell or range of cells using different methods.

      You must first select the cell or range of cells to copy the data

1.            You can use copy and paste command to copy. Select Home Button /Clipboard/Copy, transfers a copy 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 enter key in the destination cell.

2. You can use shortcut menu commands for copying and pasting. After selecting the cell or range of cells right click the range and choose copy 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+ C to Copy and Control +V to Paste.

       4. Drag and Drop method can also be used to copy cells or range of cells. Select the cell or range of cells keep the Control key pressed and move the mouse to one of the selection border, now the mouse pointer is augmented with a small plus sign and then simply drag the selection to its new location while you continue pressing the control key. The original selection remains behind and Excel makes a new copy when you release the mouse button.

Related Posts by Categories