In our case, the first row is the header row that includes the name of all the columns ( University, State, Faculty No, Student No, Ranking).
So, if we want to toggle down to our last row from the first row in the data range, we have to first select one of the cells in the first row. If we want to move back to our first column, we have to press the CTRL and LEFT ARROW ( ←) key together instead of the RIGHT ARROW. Then we will press the CTRL and RIGHT ARROW ( →) key together to move to the last column ( Ranking) in this data range. So, if we want to move to the Ranking column from the first column University, we have to first select one of the cells of the University In the worksheet we are working on, the first column is University ( Column B) and the last column in this range is Ranking ( Column F). If you need to move to the last column or last row of the datayou are working on, all you have to do is to hold down the CTRL and RIGHT ARROW key together to scroll to the start and end of each range in a column or row before reaching the end of the worksheet. Move to the End of Column or Row Range with Arrow and CTRL Key Read More: How to Shift Cells Right in Excel (4 Quick Ways)Ģ. In case of moving up to the cell just above the selected one, press the UP ARROW ( ↑). If you want to move to the cell just below the current cell, you have to just press the DOWN ARROW ( →). In case of toggling to the cell left of the currently selected cell, you have to press the LEFT ARROW ( ←). 
If you want to move to the next right cell, you have to just press the RIGHT ARROW ( →).You can move to the next adjacent cell by just pressing one of the four arrow keys. Move to Next Cell in Excel with Arrow Key
We will try to learn the techniques and use them according to our needs.ġ. Every method, however, is suited for a particular type of work. We will learn 6 different ways to move our cells conveniently. Now, we will try to move our cells using 4 arrow keys on our keyboard along with CTRL, SCROLL DOWN, PAGE UP, and PAGE DOWN keys. The information includes which state one specific university is in, the faculty and student number, and the world ranking of that university. We have 10 different universities in this worksheet and various information. Let’s assume a scenario where we have an Excel worksheet of different universities in the United States. 6 Suitable Methods to Move Cells in Excel with Arrow Keys
0 kommentar(er)
