press Enter Figure . Selecting a Cell . . Selecting Multiple Cells: Continuous cells can be selected using the keyboard or the mouse.
. . . Selecting Multiple cells using mouse: • Click in a cell.
• Press and hold down the left mouse button. • Move the mouse till the desired location is selected. • Once the desired block of cells is selected, release the left mouse button. Range of Cells Highlighted Rows (Selected) Highlighted Colums (Selected) Figure .
Selecting Multiple Sheets . . . Selecting multiple cells using keyboard: • Move to the starting cell.
• Holding down the Shift key, use the cursor movement arrow keys to select the rest of the range. . . Selecting single column or single row: • To select a single column, click on the column identifier letter • To select a single row, click on the row identifier number.
Selected Columns Click Row number to select entire row Click Column heading to select entire Column Figure . Selecting Single column or single row . . Selecting Continuous multiple columns or rows • Click on the first column or row in the group.
• Hold down the Shift key. Click the last column or row in the group. ( ) Click on the Column heading ( ) Click last Column Entire Columns will be selected ( ) Hold down Shift key Shift Figure . Selecting Continuous multiple columns or rows .
. Selecting multiple columns or rows that are not continuous: • Click on the first column or row in the group. • Hold down the Ctrl key . • Click on all of the subsequent columns or rows while holding down the Ctrl key.
To select range of non-continuous cells • Select the cell or range of cells using one of the methods above. • Move the mouse pointer to the start of the next range or single cell. • Hold down the Ctrl key and Click or Click-and-drag to select another range of cells with already selected range. • Repeat if necessary.
. – Hide/Show Rows and Columns When elements are hidden, they are neither visible nor printed,