10/10/2013 - 2:43 PM



#Excel ##Excel keyboard shortcuts ###The best keyboard shortcuts for selecting data

The first step of selecting cells or a group of cells (called a range) is to position the cursor on a cell that is a corner of the area you want to select. Use the arrow keys to do this.

To select a rectangle area around the active cell, hold down the SHIFT key and press the arrow keys. For example, to select a 2 by 4 rectangle, hold down the SHIFT key and press the RIGHT ARROW key one time and the DOWN ARROW key three times.

Holding down the SHIFT key can be cumbersome, so Excel provides a way to "turn on" selecting with arrow keys. Press F8 to start using the arrow keys to select, and press F8 again when you are finished.

CTRL+ASelect the entire worksheet
CTRL+SPACEBARSelect the entire column
SHIFT+SPACEBARSelect the entire row
F8Turn on extending a selection by using the arrow keys
CTRL+SHIFT+ENDExtend the selection to the last used cell on the worksheet (lower-right corner)
CTRL+SHIFT+HOMEExtend the selection to the beginning of the worksheet
CTRL+SHIFT+arrow keyExtend the selection to the last nonblank cell in the same column or row as the active cell
SHIFT+F8Add another range of cells to the selection; or use the arrow keys to move to the start of the range you want to add, and then press F8 and the arrow keys to select the next range

##Excel 2013 ###Resources

  1. New functions in Excel 2013 http://office.microsoft.com/en-001/excel-help/new-functions-in-excel-2013-HA103980604.aspx?CTT=5&origin=HA102809308
  2. What's new in Excel 2013 http://office.microsoft.com/en-001/excel-help/what-s-new-in-excel-2013-HA102809308.aspx