Selecting Cells | Selecting Rows | Selecting Column in Workbook

Selecting cells in a workbook (using the mouse)

• Before you can work with cells, you need to select one or more.
• To select one cell, click it.
• To select a group of cells, be sure the mouse pointer shows as the selection mouse pointer, click in the first cell and drag through to the last cell (first cell will show white and all others will be shaded).
• To de-select cells, click once in any cell – there will always be one cell active
• To select the entire worksheet, press Ctrl+A on the keyboard or click the blank area to the left of column A and just above row 1.

Note: When using Ctrl +A - if the selected cell is within the data area, only data will be selected. If the selected cell is outside the data area, the entire worksheet will be selected.

Selecting rows or columns

• To select one column (e.g. column A), click on the A (above the cells) – the entire column shows selected.
• To select one row (e.g. row 1), click on the 1 (to the left  of the cells) – the entire row is selected.
• To select multiple columns click the letter for one column and drag right or left to include other columns
• To select multiple rows click the number for one row  and drag down or up to include other rows

Freezing Rows or Columns

When you need to keep the top row or left column in view  as you work with a large amount of data, you can Freeze it  so it’s always visible on the screen (note – this does not  affect printing).
1. Go to View/Freeze Panes
2. Select either Freeze Top Row (freezes row 1) or Freeze First Column (freezes column A)

To unfreeze, select Unfreeze Panes