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)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"NS421" wrote:
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