Sunday, November 25, 2012

How to Make a Selection in Microsoft Excel


1. Click a single cell with the mouse to select it. This cell will be surrounded by a black border and the row and column it belongs to will be highlighted in the frame around the spreadsheet. If you're only looking to select one cell, you're done!
2. Click the initial cell, keep the mouse button pressed down, and drag the mouse horizontally, vertically or diagonally to select multiple adjacent cells. Now the entire group of cells (called a range) will be shaded gray and surrounded by a black border.
3. Click the name of a column or row in the frame around your Excel spreadsheet to select an entire row or column. For example, click the letter 'B' to select the entire second column. Doing this will deselect any cells that are currently selected.
4. Click the mouse to select a single cell, hold down the 'Control' key of your keyboard, and click another cell to select two non-adjacent cells. As long as the 'Control' key is held down, any number of cells can be selected. Additionally, clicking an already selected cell with the 'Control' key held will deselect it without affecting other selections.

Blogger news