>
0 items - $0.00

Your shopping cart is empty

Why not add some items in our Shop
Call Us at +27 21 786 1224

Easily moving cell contents to a different location. No Cut and Paste needed.

 

Sometimes we built a list in Excel and we want to move some cell entries up or down according to our preference. As an example, say we have the months of a year:
January
February
March
April
May
June
July
August
September
October
November
December

Now we might want to have the months starting at March, as it is considered the start of a financial year in some countries. Often we would do as follows: We will select the range that we want to move, right click, select Cut. Then we will click in the cell where we will want to insert this contents. Here we will right click and select Insert Cut Cells.

Instead we can do this:
Select the range you want to move. Keep the Shift key in. Move the mouse to the border of the selected range until the mouse pointer change to a Mouse arrow with a four pointed arrow.

Excel-Training-Mouse-Pointer-1

Now drag the range to where you want in. An Ibeam will show where this range will be inserted as you drag along.

Excel-Training-Mouse-Pointer-2

The contents will be placed where we want it and the remainder of the contents will move up to where we removed the selected range.

Excel-Training-Mouse-Pointer-3

 

Share this article

Comments

Leave a comment

Your email address will not be published. Required fields are marked *