Selecting Cells in a Worksheet
To copy, move, delete, and format numbers and words in a worksheet, you have to select the cells in which the numbers and words are found. Here are ways to select cells and the data inside them:
- A block of cells: Drag diagonally across the worksheet from one corner of the block of cells to the opposite corner. You can also click in one corner and Shift+click the opposite corner.
- Adjacent cells in a row or column: Drag across the cells.
- Cells in various places: While holding down the Ctrl key, click different cells.
- A row or rows: Click a row number to select an entire row. Click and drag down the row numbers to select several adjacent rows.
- A column or columns: Click a column letter to select an entire column. Click and drag across letters to select several adjacent columns.
- Entire worksheet: Click the Select All button, the square to the left of the column letters and above the row numbers; press Ctrl+A; or press Ctrl+Shift+Spacebar.
Press Ctrl+Spacebar to select the column that the active cell is in; press Shift+Spacebar to select the row where the active cell is.
You can enter the same data item in several different cells by selecting cells and then entering the data in one cell and pressing Ctrl+Enter. This technique comes in very handy, for example, when you want to enter a placeholder zero (0) in several different cells.
In this tutorial:
- Refining Excel Worksheet
- Editing Worksheet Data
- Moving Around in a Worksheet
- Better Look at the Worksheet
- Freezing and splitting columns and rows
- Your own customized views
- Hiding columns and rows
- Comments for Documenting Your Worksheet
- Selecting Cells in a Worksheet
- Deleting, Copying, and Moving Data
- Handling the Worksheets in a Workbook
- Tampering with Worksheets
- Hiding a worksheet
- Protecting a worksheet