Learn about the different hot keys in Microsoft Excel.
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.
At a glance, AOL On turns on your day with what you should be watching now – whether that’s breaking news, a quick LOL, the newest tech demo, or an easy recipe for dinner. We’ve got the most relevant video on every topic sifted, sorted and served to you by AOL On video experts, celebrities and news outlets.
We program our channels with videos from hundreds of your favorite brands like E!, The Food Network, and The Doctors. That means coming to one place and getting the whole story. If there’s a topic that’s trending or breaking news happening – you’ll find it on our front page thanks to our world class video programming team. They work 24/7 to update our channels with the latest.
Comments