Home

How-To

Help Desk

PBZine

PBZine

Download More
  Information

BizStore

Subscribe and stay informed!
Name:
Email:

Practical Business Course - "How-To" Tips

Get clued up with our regular "how-To" tips. This month the focus is on Microsoft Excel...

Microsoft Excel - Moving and Copying Cells Groups of cells can easily be moved or copied to other parts of the spreadsheet...

Moving Cells:

  • Move the mouse pointer to cell A1.
  • Click and drag down to cell E12.
  • The area should be highlighted
  • Move the pointer to the edge of the group of cells. (The pointer must appear as )
  • Click and drag the group of cells so that the spreadsheet title now starts in B2.

To Copy a Group of Cells:

  • Repeat the above while holding down the Control key as you drag