MS-Excel

Selecting Objects

"Objects" refers to all the parts that make up your worksheet. For example, an identifier is considered an object, as are data, a graphic, a cell, a column, a row, and an entire worksheet etc. When an object is selected, it is highlighted, or blocked by a thick black rectangle.

Objects must be selected if you wish to modify their appearance, color, size, font etc.

· To select a cell, you just need to click it.

· To select a row or a column, you just need to click its identifier.

· To select the entire worksheet, you need to click the rectangle where the column and row identifiers intersect.

You can select more than one object at a time to avoid performing the same operation on each object. These objects can be adjacent to or separate from one another. For example, if you wish to select columns A to D, follow these steps:

· Click one of the identifiers for a column that will border your block, that is, identifier A or D;

· Hold down the SHIFT key;

· Click the column that was not selected, that is A or D;

· Release the SHIFT key.

Columns A through D will be selected. No matter which command you execute, columns A, B, C and D will all be modified.

If you wish to select more than one adjacent cell, you just need to repeat that same procedure.

When you wish to select objects that are not adjacent, the procedure is just as simple. Here is what you must do to select cells A1 to A8 and cell C5:

· Since cells A1 to A8 are adjacent, use the same procedure as above.

· Press and hold the CTRL key.

· Click cell C5 and you will notice that cells A1 to A8 remain bolded by a rectangle and that another rectangle has been created around cell C5.

· Release the CTRL key.

Deleting the Content of One or more Cells

To delete the contents of one or more cells,

· First select the cells containing the text you wish to delete.

· Now press Delete key present on the keyboard or right click and then select Delete from the shortcut menu.

Back to Index