| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 31021 | 2003-03-09 10:17:00 | Excel not so powerful?? | Silenoz (3319) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 126852 | 2003-03-09 10:17:00 | 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? | Silenoz (3319) | ||
| 126853 | 2003-03-09 10:31:00 | 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. |
Heather P (163) | ||
| 126854 | 2003-03-09 11:06:00 | 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. | Silenoz (3319) | ||
| 126855 | 2003-03-10 01:52:00 | 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 |
leshibbard (873) | ||
| 126856 | 2003-03-10 02:58:00 | Actually, you can probably do it with any number of programming languages. As you're in Excel you could possibly use Visual Basic. (?) | Heather P (163) | ||
| 126857 | 2003-03-10 07:27:00 | Was rather hopeing there was a simple answer to this one as I’ve been trying to do the same thing for ages now. :( | B.M. (505) | ||
| 1 | |||||