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

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 worksheet 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

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" <[email protected]> wrote in message
news:[email protected]...
> 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 worksheet 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
>

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 worksheet??

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" <[email protected]> wrote in message
> news:[email protected]...
> > 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 worksheet 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
> >
>
>
>

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" <[email protected]> wrote in message
news:[email protected]...
> 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 worksheet??
>
> 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" <[email protected]> wrote in message
>> news:[email protected]...
>> > 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 worksheet 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
>> >
>>
>>
>>

yeah, my mistake... sure i tried that earlier but it kept de-selecting. Not
now... all sorted. Thanks loads Andy.

Regards,

Jay

"Andy B" wrote:

> 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" <[email protected]> wrote in message
> news:[email protected]...
> > 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 worksheet??
> >
> > 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" <[email protected]> wrote in message
> >> news:[email protected]...
> >> > 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 worksheet 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
> >> >
> >>
> >>
> >>
>
>
>

Select a cell in your list. Use the Data menu to choose Form. You will probably get a message saying that Excel doesn't know where your headers are and can it just use the first row. Click the OK button. A data entry from will appear for you to enter your data. You hit your tab key to go from field to field and enter to load the information into your worksheet and go to the next record (pun not intended) which is the set of information about each entry. I promise this will work.

One way is to use a Worksheet_Change event macro. In that macro, write code
to place the active cell in Column A of the next row if something is entered
into the D column. That macro would look something like this:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub
If Target = "" Then Exit Sub
If Target.Column = 4 Then _
Cells(Target.Row + 1, 1).Select
End Sub
This is a sheet event macro and must be placed in the sheet module for the
sheet in question. To do this, right-click on the sheet tab, select View
Code, and paste this macro into the displayed module. HTH Otto

"Massive" <[email protected]> wrote in message
news:[email protected]...
> 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 worksheet 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
>

Pleased to help - thanks for the feedback!

--
Andy.


"massive" <[email protected]> wrote in message
news:[email protected]...
> yeah, my mistake... sure i tried that earlier but it kept de-selecting.
> Not
> now... all sorted. Thanks loads Andy.
>
> Regards,
>
> Jay
>
> "Andy B" wrote:
>
>> 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" <[email protected]> wrote in message
>> news:[email protected]...
>> > 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 worksheet??
>> >
>> > 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" <[email protected]> wrote in message
>> >> news:[email protected]...
>> >> > 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 worksheet 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
>> >> >
>> >>
>> >>
>> >>
>>
>>
>>

An even more simple solution:
- Select the columns you use (in column headings A, B, C ...)
- unblock the selected area: Format - Cells - Protection
- protect the sheet: Tools - Protection - Protect sheet
don't allow "Selection of blocked cells" = first choice
When you confirm your input in the last column (with ENTER) you jump back to the next row in column A.