This content requires Flash

To view this content, JavaScript must be enabled, and you need the latest version of the Adobe Flash Player.

Download the free Flash Player now!

Now, the next set of functionality were the next set of tricks that allows you to move up and down very quickly through a data set or not necessarily function that you can select on the Ribbon or any kind of demand boxes. These are hot keys that you would press on the keyboard. The first one is Control End. You would first press the Control button and then press the End button on your keyboard. What that does is it takes you to the last cell of your data table.

If you would select Control Home, press the Control Key and then press the Home key and you will go to the top of your data set. If you want to go to the last cell of the column that you are currently in, select Shift Control then the Down Arrow, this will first select the entire range of the column that you are currently in and then you would simply click the cell underneath. Now, your cursor is in your active cell that you got at the end to the data table. If you are working with the table that has lots of columns, you can move to the right most columns by pressing Control Shift then the Right Arrow. Let us demonstrate this by clicking a cell here, Control Shift then the Right Arrow and then simply click the cell to the right of that.

Now, the next set of functionality were the next set of tricks that allows you to move up and down very quickly through a data set or not necessarily function that you can select on the Ribbon or any kind of demand boxes. These are hot keys that you would... click to read more