nomadagro.blogg.se - How to turn off scroll lock in excel 2016

#How to turn off scroll lock in excel 2016 how to#

Move between Sheets in Excel With Arrow Keys If you want to move one window up or down you can press the UP or DOWN ARROW Using this technique, you can also move through a large distance in your worksheet.ĥ.

Hold down the CTRL key while you press the LEFT or RIGHT ARROW key to scroll one window left or right.

Press the SCROLL LOCK key from your keyboard or your On-Screen Keyboard if you do not have that key on your keyboard.

If you need to move one window up or down or want to slide one window left or right, do these steps. Move One Window Using SCROLL LOCK, CTRL, and ARROW Key

The current cell will not be affected as you go up or down the worksheet.Ĥ. Note: As you scroll up or down using this technique, it would not affect your current selection. After that, press the UP or DOWN ARROW key to scroll one row up or down or the LEFT or RIGHT ARROW key to move one column left or right.Upon pressing the Scroll Lock key, you will see a Scroll Lock bar appear on the bottom of your Excel worksheet.

#How to turn off scroll lock in excel 2016 how to#

See the Things to Remember section down below to find out how to activate the Scroll Lock key on your keyboard. If you need to just move one row up or down, then you have to follow these steps. Move One Row or One Column with Arrow Key and Scroll LOCK

After that, we have to hold down the CTRL and DOWN ARROW ( ↓) key together to reach the last row in this data range.ģ.

So we will select a cell from this row or we can also select the entire row. 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 data you 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 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 in a convenient way. 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