http://www.flypicture.com/download/NDAwODQ=

Missing is information and Co. logo. All columns in report below header
should remain same size.

Here is one that is giving me a problem. I have 4 different types of
reports. 3 of which were fairly easy to make the header (those rows that have
the title of the document, Phase, System, Date Created) fit the width of the
report below. With this one, there is no way that I know of to get the Header
to fit the report. You'll notice that columns HIJK spill over the Report. The
only solution I can find to make it fit is to merge Row 9 (and below),
Columns G-K. Still, I'll have a couple hundred reports of this kind to
standardize and to do this for each one seems ridiculous.

What I don't understand is why there isn't a Split Cells function in Excel.
(Think MS Word). If I had a Split Cells function, this wouldn't be such a
mess!

"Gord Dibben" wrote:

Use either of the 2 free filehosts below to upload a sample of your actual
worksheet.
(Desensitize it first, if needed). Then copy & paste the generated link to
your sample file in response he

http://www.flypicture.com/
http://cjoint.com/index.php


Gord Dibben MS Excel MVP

On Fri, 5 Oct 2007 07:20:00 -0700, NS421
wrote:

My 'Header' structure is different than the body of the spreadsheet . It is a
formatted heading that has several bits of data that needs to comply to dept.
standards. If I could enter a whole table in one cell, then the
Format-Cells-Alignment would work.

Does that make my problem more clear? I wish I could post what this looks
like!

"Sasa Stankovic" wrote:

if you stop using merge and center button you'll be much happier person!
Start using : Format-Cells-Alignment-Horizontal alignment-Center across
selection

"NS421" wrote in message
...
I have a series of documents (system function lists) in Excel that vary in
column width. Above each of these, I have to insert a 'Header' that is 8
columns wide. When I insert this 'Header', it needs to fit across the
table
without changing the column widths (no matter how short (# of columns) or
wide). To make it fit, I've been playing merging and unmerging cells. This
takes FOREVER.

Is there an easier way? Is there a way to insert a table, or another
spreadsheet above the current information so that I can easily stretch the
columns to best fit the content without changing the list below?

The reason I say spreadsheet is because I feel like I've seen this before,
split so that there was a gray bar between -- was this a dream or
reality??

N