|
You're probably already familiar with many basic Excel keyboard shortcuts. However, there are some little-known shortcuts that can help you work even more efficiently in selecting ranges and moving around a worksheet.
For example, you can quickly select an entire data region (a range of data cells bordered by empty cells) by clicking within the range and then holding down CTRL-SHIFT-* (asterisk). Another way to select a data range is to place your cell pointer in the range and then press CTRL-A; press CTRL-A a second time to select the entire worksheet. You can also press CTRL-Spacebar to select the column where your cell pointer is located.
Another helpful keyboard shortcut is to press END followed by an Up, Down, Left, or Right arrow key to efficiently move the cell pointer to the outermost edge of a data range.
|
