View Single Post
  #3   Report Post  
massive
 
Posts: n/a
Default

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" wrote in message
...
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