Re: i've got a simple excel problem that needs solving...



It doesn't deselect as I type! You could hide columns E through to IV but I
still don't think it will give you what you want.

--
Andy.


"massive" <massive@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:82155D00-0B21-4328-B5B0-04C029FF8556@xxxxxxxxxxxxxxxx
> Hello, Thanks for replying. I need to be inputting data as i go along
> though.
> If i select all the boxes it will de-select as soon as i begin to type!
>
> Is there anyway to get a custom 4 column work***??
>
> Regards,
>
> Jay
>
> "Andy B" wrote:
>
>> Hi
>> One way is to select columns A:D before you start. Each time you hit TAB,
>> it
>> will take you through only those columns. So the order would go: A1, B1,
>> C1,
>> D1, A2, B2, C2, D2, A3, ETC
>>
>> --
>> Andy.
>>
>>
>> "Massive" <Massive@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:3F125544-F471-4BB2-ACCB-3F1382FDDFF3@xxxxxxxxxxxxxxxx
>> > Hello, i'm new to the wonderful world of all thing's Microsoft, I've
>> > got
>> > Excel 2004 for the Mac and i'm having to use it as a database for my
>> > large
>> > record collection as they don't make Access for the Mac unfortunately.
>> >
>> > I need a custom work*** of just 4 columns long, the reason being that
>> > when
>> > i get to the last column in the row (the rows being Artist, Title,
>> > Label,
>> > Comment) i want the cursor to jump to the 1st column of the next row
>> > when
>> > i
>> > press TAB as this would save a lot of time when inputting my record
>> > names.
>> > (instead of moving the cursor down with the arrow and key's and then
>> > moving
>> > it back four everytime)
>> >
>> > The number of row's will depend on how many records i have....
>> >
>> > Can someone tell me how to do this... i've tried the help funtion
>> > within
>> > the
>> > program but can't seem to get any further and deleting columns from the
>> > insrt
>> > menu doesn't seem to have the affect i want or need.
>> >
>> > Many thanks
>> >
>>
>>
>>


.


Loading