Dragging in Microsoft Excel

Open Microsoft Excel and try the following:

(1) Click any cell. Note the black border:

Microsoft Excel 2003: Cell's Black Border

Move your mouse around the black border and note the black cross which appears only in the lower right corner:

Microsoft Excel 2003: Cell's Black Border's Black Cross

(2) Write something inside the cell:

Microsoft Excel 2003: Writing in the Cell

(3) Drag outside the cell up or down several cells away …

Microsoft Excel 2003: Dragging the Cell Outside

… and release the mouse. You will see the cell copied to the cells you dragged into:

Microsoft Excel 2003: Dragging the Cell Outside - the Copies

(4) Write something in another cell …

Microsoft Excel 2003: Writing in the Cell

… and click any cell outside to deselect it:

Microsoft Excel 2003: Deselect the Cell

Click the cell you wrote inside again and drag to the inside by clicking and moving your mouse from the lower right corner of the border …

Microsoft Excel 2003: Dragging the Cell to the Inside

… release the mouse and the content will be deleted:

Microsoft Excel 2003: Cell's Content Deleted

(5) Hit Ctrl and Z in your keyboard at the same time to undo the deletion. Now copy the cell several times down …

Microsoft Excel 2003: Copy the Cell

… then select them all …

Microsoft Excel 2003: Select the Cells

… and drag from lower right corner to upper left corner to delete the content of all the cells:

Microsoft Excel 2003: Delete Content by Dragging in

Here are some tips for you:

1. Notice the yellow box

Microsoft Excel 2003: Copy the Cell

… it tells you what will be copied into the next cell you are going to drag in.

2. Select and Drag can save you time when writing dates of a month, days of a week, or serial numbers in a column in an ascending order.

For example, in Microsoft Excel write “July 01”, go down and write “July 02”. Now, select both cells and drag from lower right corner down …

Microsoft Excel 2003: Auto Complete by Dragging

… to auto-complete the list of dates:

Microsoft Excel 2003: Auto Complete by Dragging

Try to do it in a descending order by dragging from down to top. Also, try to experiment this technique with days of a week and serial numbers. It is so fun!

3. And, if you are not pleased with the format of the dates, select them all, right-click, select Format Cells, and then click the Number tab. In the Category pane, click Date and choose the format you like on the right. Or, you can write a custom date by clicking on Custom under Category and write your custom format in the text box to the right:

Microsoft Excel 2003: Customizing the Date Format

Experiment and experiment and experiment and …

Advertisements

Tags: , , ,


%d bloggers like this: