Cell Select sequence

L

Lyn

Hi,

I want to know whether is there a way that the cell can be
in a sequence such that, it is in order when i wanna key
in the information.
E.G when i enter the value in C10, then follow by C11,
then D10, D11, E10, E11, E12, & so on. There is a way when
we hit the ENTER button in an assigned sequence?

Thanks,
Lyn
 
D

Debra Dalgleish

One way is to select the block of cells in which you want to enter the
data. Then, type a value in cell C10, and press Enter to move to the
next cell in the block.
 
J

JMay

On the Menu select Insert, Name Define... a name, say "Entry1" in the Define
name dialog box. In the refers to box enter:
=Sheet1!$C$11,Sheet1!$D$10,Sheet1!$D$11,Sheet1!$C$10
Save the Workbook and Close
Then re-Open the workbook,,
First thing, from the Name Box dropdown, select Entry1
your set to stay within the presubscribed cells.. This is Sample only..
HTH
 

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

Top