Key+Range+Highlighting

There is one more to add to your Excel key combination list, Try **Ctrl + Shift + 8**? (Actually, you're using the asterisk * key, which is the Shift of the 8). It's an awesome little trick. What it does is **highlight the entire range of cells that you are currently in**. (Range being the group of cells around the one you currently have selected, stopping wherever there is an unused cell). This can be a great time saver. Think about it. You can instantly highlight entire columns of continuous data, including the column title, but not all the empty cells at the bottom, with just one key combination. I should add here that it does highlight several columns of data that are together. So, the next logical question is, "How do I use this when I only want one column"? You can alter the highlighted range easily by holding down the Shift key and then using the other keys we're already familiar with (arrows, Page Up, Page Down, Home, End, etc).
 * Key **** Range **** Highlighting **