PDA

View Full Version : Excel not so powerful??



Silenoz
09-03-2003, 11:17 PM
Im trying to make a crossword in MS Excel 2000. Is it possible to enter just one letter in a cell and have that cell move to the right or down a cell straight after?

Heather P
09-03-2003, 11:31 PM
Depends how it's set up but the defaults are:
Press <Enter> to go down one square; <tab> to go one cell to the right.

Silenoz
10-03-2003, 12:06 AM
I realise that by entering or using TAB's or arrrows moves to the next cell, but I want it to move automatically to the next cell without having to use these default keys.

leshibbard
10-03-2003, 02:52 PM
Silenoz, Mental Telepathy perhaps, how does a cell know what length word you want to enter, you would need a complex Macro to describe each cell's length.

Before I retired 10 years ago, we used to use a software program called UGEN, which used to have fields requiring certain length numbers or characters, and after each entry skipped along to the next field.

Les3

Heather P
10-03-2003, 03:58 PM
Actually, you can probably do it with any number of programming languages. As you're in Excel you could possibly use Visual Basic. (?)

B.M.
10-03-2003, 08:27 PM
Was rather hopeing there was a simple answer to this one as Iíve been trying to do the same thing for ages now. :(