The Mouse Pointer In Excel

The mouse pointer in Excel will take on different shapes depending where it is on the sheet, and each pointer type relates to a particular action.

Selecting cells is Excel is one of most common things you will do as you need to to select cells you want to do something with whether its enter text, data or a formula.

See below for a summary of the different mouse pointers below and what they mean.

To select a cell point to the cell and click once with the mouse to select it.  The cell will appear white with a black border around it.

If you want to select a  a number of cells adjacent to each other at once you need to click on  the first cell to be selected, hold down the mouse button, and then drag it to the last cell you want selected.  A quicker way is to select the first cell, hold down the SHIFT key and click on the last cell to select all you need to.

If you want to select a group of cells that are non adjacent, click on the first cell, hold the Ctrl key and then continue to select the next cells, repeat this until all the cells you require are selected.

Have a practice, it becomes second nature a you easily identify the different mouse pointers.


Other Posts You Might Like.

1. Scrolling around a worksheet

2. Text wrapping in Excel

3. Format cells that only contain text

4. Centre a title across a worksheet

 

Want More Excel Tips?
You Need 101 Secrets From An Excel Addict!


Comments

  1. Mohan says

    Sometimes the normal pointer does not change shape to fill/move pointer. If so:
    In Excel 2003: Tools|Options|Edit and check allow cells drag and drop.
    In Excel 2010: Access Excel Options dialog box, click Advanced tab, place a check mark on the option labelled Enable Fill Handle and Cell Drag-and-Drop.

Leave a Reply

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