movement between cells in excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to move automatically (without hitting tab or enter) between cells, so
once I reach the end of my cell (how it is viewed on screen), I want to
automatically continue writing in the cell below, like in Word when you reach
the end of the line it automatically goes down to the next line. Anyone know
how to do this?
 
I understand hiting "tab" and "enter" will move the cursor between cells, I
want to know if there is anyway to have automatic movement between cells
after you have reached the end of the cell, or cell range. So, while I am
typing in one cell and hit the end of that cells range, I won't get a warning
I would just continue on to another cell.
 
Select all the cells you want to work with first, then use the Tab key after
you enter data or to move to the next cell. The cursor/activecell will
travel within the selected cells.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA set thick borders around non empty cells in range 0
Cell Movement 2
Cell to Cell Movement Speed 4
Application.Caller calls from ActiveWorkbook not the actual cell workbook 1
Border formatting row of cells 22
Relative movements within macros 3
Code to add comments to selected cells within a selected range 30
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3

Back
Top