Thursday 14 February 2008

Excel Training - Small Tips - Entering Data

Some small tips when using Excel.

You can enter the same data to multiple cells by highlighting them, enter your data, then hold down CTRL when pressing Enter.

Or.
On selecting a cell, move your mouse over thick border, you get big 4 way arrow, click and drag to move the data to another cell.

Or.
On selecting a cell, move your mouse over bottom right corner get smaller 4 way cross, click and drag to copy to data to new cells. At this point you can also select the smart tag and select Fill Series to generate series of data.

No comments: