Using "newspaper"-type columns - can it be done?

[Guest]

My boyfriend just asked me an interesting question about setting up "newspaper"-type columns in Excel. He'd like to have a set number of rows, in this case 30 rows, two columns wide. When they need to enter another name alphabetically, and the corresponding case number, he'd like for Row #31 to kick to the top of the next two columns instead of going down to the next line or next page

Does it require a macro to cause this type of behaviour, or is there an Excel function that he can use to do it?

 

[Peter atherton]

Lexi?

The way to do it is to select the range first. To make the
selection easy first create a range name for A1 to B30.

Select these cells, then choose, Insert, Name, Define and
call the range Names. click OK & Close the dialog box.
You can know select the range by selecting it from the
Name Box at the left of the Formula Bar.

To move in a selection use the Tab key to move between
columns and Enter to move own the column. When you get to
the end of the selection Excel will 'Jump' to the next
column as you want.

Regards
peter

-----Original Message-----
My boyfriend just asked me an interesting question about

setting up "newspaper"-type columns in Excel. He'd like
to have a set number of rows, in this case 30 rows, two
columns wide. When they need to enter another name
alphabetically, and the corresponding case number, he'd
like for Row #31 to kick to the top of the next two
columns instead of going down to the next line or next
page.

Does it require a macro to cause this type of behaviour,

or is there an Excel function that he can use to do it?

 

[Guest]

Thanks so much, Peter!! I haven't tried it yet, but it sounds like it'll work. I appreciate your help, and my boyfriend is sure going to come off looking like a hero at his office! Until now, they've had to cut and paste to make their columns work. This will definitely make life simpler for them

::hugs:

lex


----- Peter atherton wrote: ----

Lexi

The way to do it is to select the range first. To make the
selection easy first create a range name for A1 to B30

Select these cells, then choose, Insert, Name, Define and
call the range Names. click OK & Close the dialog box
You can know select the range by selecting it from the
Name Box at the left of the Formula Bar

To move in a selection use the Tab key to move between
columns and Enter to move own the column. When you get to
the end of the selection Excel will 'Jump' to the next
column as you want

Regard
pete

-----Original Message----
My boyfriend just asked me an interesting question about

setting up "newspaper"-type columns in Excel. He'd like
to have a set number of rows, in this case 30 rows, two
columns wide. When they need to enter another name
alphabetically, and the corresponding case number, he'd
like for Row #31 to kick to the top of the next two
columns instead of going down to the next line or next
pageor is there an Excel function that he can use to do it