How to Move Cells in Excel with Arrow Keys (6 Methods)

Get FREE Advanced Excel Exercises with Solutions!

Sometimes while working on a large worksheet, we need to move cells in Excel to work faster and for ease of working. We can move cells in Excel using the arrow keys from our keyboard. In this article, I will tell you about 6 easy ways how to move cells in Excel with the arrow keys from your keyboard without any need to use your mouse.


How to Move Cells in Excel with Arrow Keys: 6 Suitable Methods

Let’s assume a scenario where we have an Excel worksheet of different universities in the United States. We have 10 different universities in this worksheet and various information. The information includes which state one specific university is in, the faculty and student number, and the world ranking of that university. Now, we will try to move our cells using 4 arrow keys on our keyboard along with CTRL, SCROLL DOWNPAGE UP, and PAGE DOWN keys. We will learn 6 different ways to move our cells conveniently. Every method, however,  is suited for a particular type of work. We will try to learn the techniques and use them according to our needs.

How to Move Cells in Excels with Arrow Keys


1. Move to Next Cell in Excel with Arrow Key

You can move to the next adjacent cell by just pressing one of the four arrow keys. You can do so by following these steps-

Step 1:

  • If you want to move to the next right cell, you have to just press the RIGHT ARROW (→)

Move to Next Cells with Arrow Keys

  • In case of toggling to the cell left of the currently selected cell, you have to press the LEFT ARROW (←).

How to Move Cells in Excels with Arrow Keys

Step 2:

  • If you want to move to the cell just below the current cell, you have to just press the DOWN ARROW (→).
  • In case of moving up to the cell just above the selected one, press the UP ARROW (↑).

Read More: How to Make Excel Move Automatically to the Next Cell


2. Move to the End of Column or Row Range with Arrow and CTRL Key

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.

Step 1:

  • 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). 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

Move to the End of Column

  • Then we will press the CTRL and RIGHT ARROW (→) key together to move to the last column (Ranking) in this data range.

Move to the End of Columns or Rows with Arrow Keys

  • 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.

Step 2:

  • 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. 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 we will select a cell from this row or we can also select the entire row.

How to Move Cells in Excels with Arrow Keys

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

Move to the End of Column

Read More: How to Move Cells without Replacing in Excel


3. Move One Row or One Column with Arrow Key and Scroll LOCK

If you need to just move one row up or down, then you have to follow these steps-

Step 1:

  • Press Scroll Lock. See the Things to Remember section down below to find out how to activate the Scroll Lock key on your keyboard.
  • Upon pressing the Scroll Lock key, you will see a Scroll Lock bar appear on the bottom of your Excel worksheet.

Move One Row or One Column with Arrow Keys

Step 2:

  • 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.
Note: As you scroll up or down using this technique, it will not affect your current selection. The current cell will not be affected as you go up or down the worksheet.

Read More: How to Move Cells with Keyboard in Excel


4. Move One Window Using SCROLL LOCK, CTRL, and ARROW Key

If you need to move one window up or down or want to slide one window left or right, do these steps-

Step 1:

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

 Step 2:

  • Hold down the CTRL key while you press the LEFT or RIGHT ARROW key to scroll one window left or right. 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.

How to Move Cells in Excels with Arrow Keys


5. Move between Sheets in Excel With Arrow Keys

Working with a large Excel file with a lot of worksheets will be a lot easier if you can conveniently toggle between them. You can move from one worksheet to another in your Excel file following these easy steps.

Step 1:

  • To move to the sheet right of the current one, hold down CTRL, then press the PgDn key.
  • To keep moving to the right, press the PgDn key again.

Step 2:

  • If you want to move to the left sheet next to the one you are now, press the PgUp key while holding down the CTRL key.

Move Sheets with Arrow Keys

  • To keep moving to the left, press the PgUp key again.

Move between Sheets


6. Move Cells Using Arrow Signs

You can move a single column or row of cells using the arrow sign that will appear when you select a cell, row, or column. Use that arrow sign to move your desired cells to another location. You have to follow these steps-

Step 1:

  • First, select the cells you want to move.
  • Place your cursor over the edge of the selected cells. You will see a four-sided arrow appear. We are trying to move the Ranking column (column F) over to column G. So we will select the Ranking column following the above-mentioned steps.

Move between SheetsStep 2:

  • Then just click and drag the cell to the location you want it to be. You will notice a green outline of the cell and the new cell reference (location) display when you drag it. Simply release when the cell lands in its new spot.
  • As we try to drag the Ranking column (column F) to column G, we will see a green outline of the cell in column G. We will also see the new reference display G4:G14.

Move Cells Using Arrow Signs

  • When we release the cursor, we will see the Ranking column is moved to column G.

How to Move Cells in Excels with Arrow Keys

Read More: How to Move a Group of Cells in Excel


Things to Remember

  • Some keyboards do not include SCROLL LOCK. If your keyboard does not have a Scroll Lock key, on your computer, click Start > Settings > Ease of Access > Keyboard. Click the On-Screen Keyboard button to turn it on. When the on-screen keyboard appears on your screen, click the ScrLk button.
  • You can turn off SCROLL KEY LOCK using the same On-Screen Keyboard. To turn off SCROLL LOCK, click the ScrLk, and then close the On-Screen Keyboard.
  • When SCROLL LOCK is on, Scroll Lock is displayed on the status bar in Excel.
  • To use the ARROW KEYs to shift between cells, you must turn SCROLL KEY.
  • To use the ARROW KEYs to toggle between cells, you must turn SCROLL KEY To do that, press the Scroll Lock key. This key is labeled as ScLk on the keyboard.

Download Practice Workbook


Conclusion

In this article, we have learned 6 easy ways to move cells with arrow keys in Excel. We have learned how to use the CTRL, SCROLL LOCK, and the ARROW KEYS together to move to the next cell, to the end of the row or column in a data range, move one row or column, move from one sheet to another in Excel with arrow keys and move cells using arrow signs. I hope now you have a clear idea of how to move cells.


Related Articles


<< Go Back to Move Cells | Excel Cells | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
ASM Arman
ASM Arman

Abu Saleh Arman is a Marine engineer and Excel & VBA expert. He loves programming with VBA. He finds VBA programming a time-saving tool to manipulate data, handle files, and interact with the internet. He is very interested in Python, MATLAB, PHP, Deep Neural Networks, and Machine Learning, showcasing his diverse skill set. Arman holds a B.Sc in Naval Architecture & Marine Engineering from BUET, Bangladesh. However, he switched to a content developer, where he writes technical content... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo