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