Microsoft Excel 2007 tutorial: select cells


Select cells

XIV. Select cells

You can select a single cell, a range of cells, all cells on a worksheet, and nonadjacent cells or cell ranges by using keyboard shortcuts or mouse.

XIV.1. Select a single cell, a range of cells, all cells, nonadjacent cells by using keyboard shortcuts

To select Do this
A single cell
Place cell pointer to any cell in a worksheet that you want to select by using the arrow keys to move.
A range of cells
Hold down Shift key, and then use the arrow keys to extend the selection or select the first cell in a range, then press F8, and then press the arrow keys to extend the selection.

If you use F8 to extend the selection, when you want to stop
extending the selection, press F8 again.
All cells on a worksheet
Press Ctrl + A or press Shift + Ctrl + Space Bar.
Note: If your worksheet contain data, you need to place cell pointer above a cell or a range of cells or to the left of a cell or cell ranges that contain data two cells before press Ctrl + A or Shift + Ctrl + Space Bar.
Nonadjacent cells or cell ranges
Select the first cell or range of cells, and then press Shift + F8 to add another nonadjacent cell or range to the selection. If you want to stop adding nonadjacent cell, press Shift + F8 again.
Note: You cannot remove the selection of a cell or a range of cells from nonadjacent selection without removing the whole selection. To cancel the entire selection, place cell pointer to any cell in a worksheet, then press Escape, and then move cell pointer to any cell by using the arrow keys.

XIV.2. Select a single cell, a range of cells, all cells, nonadjacent cells by using mouse

To select Do this
A single cell
Click any cell in a worksheet that you want to select, or press the arrow keys to move the cell.
A range of cells Click the first cell in the range, and then drag to the last cell.
All cells on a worksheet 
Click the Select All button.

Excel 2007 the Select All button
Nonadjacent cells or cell ranges
Click the first cell or range of cells, and then hold down Ctrl key while you click other cells or ranges.
Note: You cannot remove the selection of a cell or a range of cells from nonadjacent selection without removing the whole selection. To cancel the entire selection, click any cell in a worksheet.

 


Comments

Michael Leng comment

 Michael Leng

I like "Click the Select All button" by clicking the square top left of column and row.


2013-09-07




This website intents to provide free and high quality tutorials, examples, exercises and solutions, questions and answers of programming and scripting languages:
C, C++, C#, Java, VB.NET, Python, VBA,PHP & Mysql, SQL, JSP, ASP.NET,HTML, CSS, JQuery, JavaScript and other applications such as MS Excel, MS Access, and MS Word. However, we don't guarantee all things of the web are accurate. If you find any error, please report it then we will take actions to correct it as soon as possible.