In order to format cells, copy formulas, text cell text, etc. in Excel, you need to first select the cells. This can be accomplished by holding down your left mouse button and dragging.
You can also select cells without using your mouse button by using Excel’s Extend Mode. Simply press the F8 key and then click the final cell in your range with the mouse. You can also select a range of cells in Extend mode by using the arrow keys. You know that you are in Extend mode when the words “Extend Selection” appear in the Status Bar.
To extend the selection with a non-contiguous range of cells, using the Shift + F8 keystroke combination to add additional blocks of cells to the range.
To use Excel’s Extend Feature
- Click in the first cell of the range.
- Press the F8 key.
- Click in the last cell of the range or use the arrow keys on your keyboard to select the cells.
- For a extremely large range of cells, press F5 to activate the Go menu, enter in the cell range and then press Enter to extend the selection.
- To add a non-contiguous block of cells, press Shift + F8 and drag-select the cells you want to include in the range.
Similar Posts:
- Shortcut Keys in Excel
- Using the AutoSum Button in Excel
- Enter data in multiple cells in Excel 2007
- Using the Min, Max, Count and Average Functions in Excel
- Naming a Range in Excel
- Entering in Functions Manually in Excel
- Moving Cells in Excel
