NEW
Font size
WorksheetsSelecting a range of cells in Spreadsheet
Total questions: 8
Worksheet time: 4mins
How to select a range of cells horizontally?
Click the first cell, press the shift key, press the left arrow key
Click the first cell, press the shift key, press the right arrow key
Click the first cell, press the shift key, press the up arrow key
Click the first cell, press the shift key, press the down arrow key
How to select a range of cells vertically?
Click the first cell, press the shift key, press the right arrow key
Click the first cell, press the shift key, press the down arrow key
Click the first cell, press the shift key, press the left arrow key
Click the first cell, press the shift key, press the up arrow key
How to select a range of cells across rows and columns?
Click the first cell, press the shift key, press the left arrow key, press the up arrow key
Click the first cell, press the shift key, press the left arrow key, press the down arrow key
Click the first cell, press the shift key, press the right arrow key, press the up arrow key
Click the first cell, press the shift key, press the right arrow key, press the down arrow key
How to select a range of cells as follows: Cell A1: D4?
Click the first cell, press the shift key, press the right arrow key, press the down arrow key
Click the first cell, press the shift key, press the left arrow key, press the up arrow key
Click the first cell, press the shift key, press the right arrow key, press the up arrow key
Click the first cell, press the shift key, press the left arrow key, press the down arrow key
How to select a range of cells as follows: Cells B2:H5?
Click the first cell, press the shift key, press the right arrow key, press the down arrow key
Click the first cell, press the shift key, press the left arrow key, press the up arrow key
Click the first cell, press the shift key, press the right arrow key, press the up arrow key
Click the first cell, press the shift key, press the left arrow key, press the down arrow key
How to select a range of cells diagonally?
Click the first cell, press the shift key, press the right arrow key, press the down arrow key
Click the first cell, press the shift key, press the left arrow key, press the up arrow key
Click the first cell, press the shift key, press the right arrow key, press the up arrow key
Click the first cell, press the shift key, press the left arrow key, press the down arrow key
How to select a range of cells in a non-contiguous manner?
Click the first cell, press the ctrl key, click on the other cells
Click the first cell, press the shift key, click on the other cells
Click the first cell, press the alt key, click on the other cells
Click the first cell, press the tab key, click on the other cells
How to select a range of cells excluding specific cells?
Click the first cell, press the shift key, click on the other cells, press the ctrl key to deselect specific cells
Click the first cell, press the shift key, click on the other cells, press the alt key to deselect specific cells
Click the first cell, press the shift key, click on the other cells, press the tab key to deselect specific cells
Click the first cell, press the shift key, click on the other cells, press the esc key to deselect specific cells
