Define the location of the next cell
Define the location of the next cell
(OP)
Somewhat (?) off topic...
I have a spread sheet (Excel) with 4 columns. As I enter data and hit enter I move to the next cell. But... at the end I want to move down 1 row and back to the first row. Currently to do this I hit the down arrow and home keys. This is time consuming and I wonder if there is some way to define where my sheet stops and force a down and return.
Thanks for any advice
Ralph
I have a spread sheet (Excel) with 4 columns. As I enter data and hit enter I move to the next cell. But... at the end I want to move down 1 row and back to the first row. Currently to do this I hit the down arrow and home keys. This is time consuming and I wonder if there is some way to define where my sheet stops and force a down and return.
Thanks for any advice
Ralph





RE: Define the location of the next cell
Link:
http
I haven't yet had to use them, but they're in there.
RE: Define the location of the next cell
RE: Define the location of the next cell
Unlock cells through the formatting dialog. Protect the worksheet through the Tools menu.
I colour the unlocked cells so that I can visually tell them apart. I print with the "black and white" page setup option so that the printed page is legible (no gray background).
RE: Define the location of the next cell
CODE
If Target.Column = 5 Then
Cells(Target.Row + 1, 1).Select
End If
End Sub
Good Luck
johnwm
________________________________________________________
To get the best from these forums read FAQ731-376 before posting
UK steam enthusiasts: www.essexsteam.co.uk
RE: Define the location of the next cell
31 Mar 05 16:20
I think that your need will be met by selecting your data area before you begin entering your data values. Then your movements after <enter> are restricted to being inside the selected area.<end quote)
Interesting...How do you do this?
RE: Define the location of the next cell
"Highlight" your rectangular block of cells the same way that you would normally highlight a range (eg dragging the mouse diagonally across the screen whilst holding the left button down). You will notice that the top-left cell of the highlighted range is still individually "selected", and if you type a character on your keyboard it will be placed in that top-left cell. When you have completed your entry for that cell, hit <enter>. The selection will move to the next "highlighted" cell (either downwards or to the right according to your edit options) but the entire highlighted block remains highlighted.
If you end the data entry for a cell with an arrow-key instead of the <enter> key, you destroy the highlighting so the method does not work.
HTH
RE: Define the location of the next cell
Denial's method works pretty slick too... give 'em both a shot.
RE: Define the location of the next cell
RE: Define the location of the next cell
RE: Define the location of the next cell
Cheers,
Joerd
Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.
RE: Define the location of the next cell
Again, thanks to all that offered sugestions..