How to format this way?
 

Running Excel 2000.

I get the feeling this can't be done: I need 10 cells across, in columns A
through J, all the same size (that's easy). But, below those 10 cells, I'd
like one wide cell, as wide as the 10 above it. This wide cell would be for
long text entries. This pattern needs to repeat down the page. I know I
could stick a text box below the 10 cells, but I wonder if there's a way to
achieve this without a text box.

How to format this way?
 

When you've created your top to row, select them both and drag down as far as
you want.

"JoeSpareBedroom" wrote:

Running Excel 2000.

I get the feeling this can't be done: I need 10 cells across, in columns A
through J, all the same size (that's easy). But, below those 10 cells, I'd
like one wide cell, as wide as the 10 above it. This wide cell would be for
long text entries. This pattern needs to repeat down the page. I know I
could stick a text box below the 10 cells, but I wonder if there's a way to
achieve this without a text box.

How to format this way?
 

Hi Joe

If you mark cells A2:J2, FormatCellsAlignmentMerge
Then mark A1:J2, double click the Format Painter icon and paint over as
many rows from column A to J as you require.

--
Regards

Roger Govier


"JoeSpareBedroom" wrote in message
...
Running Excel 2000.

I get the feeling this can't be done: I need 10 cells across, in
columns A through J, all the same size (that's easy). But, below those
10 cells, I'd like one wide cell, as wide as the 10 above it. This
wide cell would be for long text entries. This pattern needs to repeat
down the page. I know I could stick a text box below the 10 cells, but
I wonder if there's a way to achieve this without a text box.

How to format this way?
 

Hi

Highlight all ten cells in row below your ten cells,
then select from toolbar

Format - Cells - Alignment - 'tick' merge cells

This will give you one long cell beneath.

Hope I've understood correctly

Graham



"JoeSpareBedroom" wrote:

Running Excel 2000.

I get the feeling this can't be done: I need 10 cells across, in columns A
through J, all the same size (that's easy). But, below those 10 cells, I'd
like one wide cell, as wide as the 10 above it. This wide cell would be for
long text entries. This pattern needs to repeat down the page. I know I
could stick a text box below the 10 cells, but I wonder if there's a way to
achieve this without a text box.

How to format this way?
 

Gimme a break. I've been using Excel since 1989 and I've never seen that
little check box? Thanks, Roger. I will now make a long overdue appointment
with my eye doctor and get new glasses. :-)


"Roger Govier" wrote in message
...
Hi Joe

If you mark cells A2:J2, FormatCellsAlignmentMerge
Then mark A1:J2, double click the Format Painter icon and paint over as
many rows from column A to J as you require.

--
Regards

Roger Govier


"JoeSpareBedroom" wrote in message
...
Running Excel 2000.

I get the feeling this can't be done: I need 10 cells across, in columns
A through J, all the same size (that's easy). But, below those 10 cells,
I'd like one wide cell, as wide as the 10 above it. This wide cell would
be for long text entries. This pattern needs to repeat down the page. I
know I could stick a text box below the 10 cells, but I wonder if there's
a way to achieve this without a text box.

How to format this way?
 

Thanks, Graham, but Roger beat you to it. He wins the case of virtual beer.
:-)


"GrahamV" wrote in message
...
Hi

Highlight all ten cells in row below your ten cells,
then select from toolbar

Format - Cells - Alignment - 'tick' merge cells

This will give you one long cell beneath.

Hope I've understood correctly

Graham



"JoeSpareBedroom" wrote:

Running Excel 2000.

I get the feeling this can't be done: I need 10 cells across, in columns
A
through J, all the same size (that's easy). But, below those 10 cells,
I'd
like one wide cell, as wide as the 10 above it. This wide cell would be
for
long text entries. This pattern needs to repeat down the page. I know I
could stick a text box below the 10 cells, but I wonder if there's a way
to
achieve this without a text box.

How to format this way?
 

"JoeSpareBedroom" wrote in message
...
Thanks, Graham, but Roger beat you to it. He wins the case of virtual
beer.

Dreadful stuff this virtual beer - when I was drinking I was virtually drunk
all the time! <g

--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk

How to format this way?
 

hic! wazat u z Sandy? <bg

--
Regards

Roger Govier


"Sandy Mann" wrote in message
...
"JoeSpareBedroom" wrote in message
...
Thanks, Graham, but Roger beat you to it. He wins the case of virtual
beer.

Dreadful stuff this virtual beer - when I was drinking I was virtually
drunk all the time! <g

--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk

How to format this way?
 

OK - I'm confused. Why can't you just use MERGE across cells?

As in LEFT - MIDDLE - RIGHT - MERGE ACROSS CELLS?



"JoeSpareBedroom" wrote:

Gimme a break. I've been using Excel since 1989 and I've never seen that
little check box? Thanks, Roger. I will now make a long overdue appointment
with my eye doctor and get new glasses. :-)


"Roger Govier" wrote in message
...
Hi Joe

If you mark cells A2:J2, FormatCellsAlignmentMerge
Then mark A1:J2, double click the Format Painter icon and paint over as
many rows from column A to J as you require.

--
Regards

Roger Govier


"JoeSpareBedroom" wrote in message
...
Running Excel 2000.

I get the feeling this can't be done: I need 10 cells across, in columns
A through J, all the same size (that's easy). But, below those 10 cells,
I'd like one wide cell, as wide as the 10 above it. This wide cell would
be for long text entries. This pattern needs to repeat down the page. I
know I could stick a text box below the 10 cells, but I wonder if there's
a way to achieve this without a text box.

How to format this way?
 

"Danny C" wrote in message
...
OK - I'm confused. Why can't you just use MERGE across cells?

As in LEFT - MIDDLE - RIGHT - MERGE ACROSS CELLS?


Isn't that exactly what Roger suggested?

How to format this way?
 

Not exactly - my way is at the top of the screen on the ICONS for
LEFT-MIDDLE-RIGHT-MERGE ACROSS. Same result much less steps.

His is to use the FORMAT, etc.

"JoeSpareBedroom" wrote:

Running Excel 2000.

I get the feeling this can't be done: I need 10 cells across, in columns A
through J, all the same size (that's easy). But, below those 10 cells, I'd
like one wide cell, as wide as the 10 above it. This wide cell would be for
long text entries. This pattern needs to repeat down the page. I know I
could stick a text box below the 10 cells, but I wonder if there's a way to
achieve this without a text box.

How to format this way?
 

OK - I see what you mean. The menu method's faster for me. No need for the
mouse.


"Danny C" wrote in message
...
Not exactly - my way is at the top of the screen on the ICONS for
LEFT-MIDDLE-RIGHT-MERGE ACROSS. Same result much less steps.

His is to use the FORMAT, etc.

"JoeSpareBedroom" wrote:

Running Excel 2000.

I get the feeling this can't be done: I need 10 cells across, in columns
A
through J, all the same size (that's easy). But, below those 10 cells,
I'd
like one wide cell, as wide as the 10 above it. This wide cell would be
for
long text entries. This pattern needs to repeat down the page. I know I
could stick a text box below the 10 cells, but I wonder if there's a way
to
achieve this without a text box.