Copying and moving by clicking and dragging
We can move or copy the data in Excel by selecting and dragging the data.
To move the contents of cells first select the cells, slide your mouse pointer over the edge of the selection, and when it changes into a four pointed-arrow, click and drag the range of cells to the position you want.

To copy the contents of cells, first select the cells, hold the Ctrl key on your keyboard, move your mouse pointer over the edge of the selection, and when it changes to an arrow and a plus-sign, drag it down.

Merging cells and rows
In Excel we have the opportunity to merge columns and rows together.
For this we first select the cells, and click the “Merge and center” button in the “Ribbon”.
This opens a drop-down menu with 4 options which seems to be clear.

This combines cells and makes a large cell.
We can move the text in this cell by using the “Top Align”, “Middle Align”, “Bottom Align”, “Align Text Left”, ” Center” and “Align Text Right”.

The “Undo” and “Redo” buttons
In the “Quick Access” toolbar we find these buttons:
1. “Undo”
2. “Redo”
Using the “Undo” command we can undo the last command executed.

By clicking on the black pointing arrow next to this button we can do up to 100 undos.

The shortcut for the undo is Ctrl Z

If you want to “Redo” undone action, click on the button again
By clicking on the black pointing arrow next to this button we can redo multiple actions.
The shortcut for redo is Ctrl Y

The “Clear” button
The “Clear” button is found in the “Home” tab of the “Ribbon”, under the “Editing” group.
To “Clear” cells, first select the cell (s) and click on the “Clear” button.
This opens a drop-down menu with 4 options.
I think these are clear.

Featured Courses

• Downloading iPad Apps
• Lesson 1: Introduction to Publisher
• Lesson 65: File Formats