Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Spreadsheet within a spreadsheet
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Spreadsheet within a spreadsheet
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 "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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Spreadsheet within a spreadsheet
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Spreadsheet within a spreadsheet
Enter your "Header" in A1 and select A1:H1
FormatCellsAlignmentHorizontalCenter across selection may work for you. A split window from WindowSplit won't allow separate column widths above and below the split line. Gord Dibben MS Excel MVP On Thu, 4 Oct 2007 13:25:01 -0700, 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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Spreadsheet within a spreadsheet
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Spreadsheet within a spreadsheet
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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Spreadsheet within a spreadsheet
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 |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Spreadsheet within a spreadsheet
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula to get the spreadsheet address to print on the spreadsheet | Excel Discussion (Misc queries) | |||
How do I copy spreadsheet data as shown to another spreadsheet? | Excel Discussion (Misc queries) | |||
conversion of MS Works Spreadsheet to Excel 2002 Spreadsheet | Excel Discussion (Misc queries) | |||
Is there a way to insert a formula, password or macro in an excel spreadsheet that will automatically delete the spreadsheet? | Excel Discussion (Misc queries) | |||
How do I convert exel spreadsheet to works spreadsheet? | Excel Discussion (Misc queries) |