Spreadsheet within a spreadsheet

[Guest]

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

 

[Guest]

Some thoughts ..

1. Use a new sheet for each new doc,
or use empty adjacent cols per doc
(if you would have it on one sheet)

2. Avoid using merge - it causes probs
To centre col headers across cols w/o merging
use Text alignment > Centre across selection
in Format > Cells > Alignment tab

3. > .. split so that there was a gray bar between ..
Think that's creatable under Window >Split
(but this is just a "sheet" viewing facility)

 

[Guest]

hi.
no dream. reality.
in the upper right of the sheet, move your mouse over the upper scroll bar
arrow. the mouse should change to to horizontal lines with small arrow
pointing up and down. click and drag down. you now have split screen.
not sure if this is what you're after but try it and if not repost.

Regards
FSt1

 

[Gord Dibben]

Enter your "Header" in A1 and select A1:H1

Format>Cells>Alignment>Horizontal>Center across selection may work for you.

A split window from Window>Split won't allow separate column widths above and
below the split line.


Gord Dibben MS Excel MVP

 

[Sasa Stankovic]

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

 

[Guest]

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!

 

[Gord Dibben]

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 here:

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


Gord Dibben MS Excel MVP

 

[Guest]

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!