Thursday, April 3, 2008

Copying cells in OpenOffice.org Calc

Moving or copying cells in OpenOffice.org may seem rather strange for MS Office users. One of the problems is that the cursor remains as an "I-bar". In yesterday's training session, how to move single and multiple cells came up. I will explain the steps with an example of contents from cell C6 to C7 or also known as C6:C7.

1. Copying multiple cells.

Aim: To copy cells C6:C7 to B12:

  1. Highlight the cells. Do this by left click on cell C6 and drag to C7.
  2. Release the left button.
  3. Move cursor over the highlighted area (default is black) and left click. Drag cursor over to B12. Release the left button.

2. Copying or moving a single cell

Aim: To copy cells C6 to B12

  1. Highlight the cells. Do this by triple (i.e. 3 times) left click on cell C6. Note that when the cursor is over the selected cell, it is an “I” bar shape.
  2. Drag cell C6 over to B12. Release the left button.

Note: To move the cell, press the Control (i.e. Ctrl) button while dragging.


No comments: