Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Attempting Excel Template
Very new to Excel and having trouble with columns. Have searched Help
and Templates but can't seem to find what I want. I need 4 columns of various widths in the upper portion (row 1 - 19 for name, address and other info) and 6 columns of varying widths different from the 4 above from Line 19 down. The last of the 6 is to be totalled at the bottom. What I don't know how to do is add more rows from 19 down without changing 1-18. Can this be done? Thank you for your help. Joni |
#2
|
|||
|
|||
No it can't.
But, you can create an *appearance* of such a set-up, by combining some of the upper columns together. For example, select B1 to C19, then: <Format <Cells <Alignment tab, Expand the "Horizontal" window, and click on "Center Across Selection", then <OK Play with the column widths and the cell borders, where you eliminate the grid lines, and you can get some semblance of mixed columns in the upper and lower portion of your sheet. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "jlr" wrote in message ... Very new to Excel and having trouble with columns. Have searched Help and Templates but can't seem to find what I want. I need 4 columns of various widths in the upper portion (row 1 - 19 for name, address and other info) and 6 columns of varying widths different from the 4 above from Line 19 down. The last of the 6 is to be totalled at the bottom. What I don't know how to do is add more rows from 19 down without changing 1-18. Can this be done? Thank you for your help. Joni |
#3
|
|||
|
|||
Thank you, RD.
Yes, this does help as it gives me a starting point to start playing! Joni "Ragdyer" wrote in message ... No it can't. But, you can create an *appearance* of such a set-up, by combining some of the upper columns together. For example, select B1 to C19, then: <Format <Cells <Alignment tab, Expand the "Horizontal" window, and click on "Center Across Selection", then <OK Play with the column widths and the cell borders, where you eliminate the grid lines, and you can get some semblance of mixed columns in the upper and lower portion of your sheet. -- HTH, RD |
#4
|
|||
|
|||
Thanks for the feed-back.
-- Regards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "jlr" wrote in message ... Thank you, RD. Yes, this does help as it gives me a starting point to start playing! Joni "Ragdyer" wrote in message ... No it can't. But, you can create an *appearance* of such a set-up, by combining some of the upper columns together. For example, select B1 to C19, then: <Format <Cells <Alignment tab, Expand the "Horizontal" window, and click on "Center Across Selection", then <OK Play with the column widths and the cell borders, where you eliminate the grid lines, and you can get some semblance of mixed columns in the upper and lower portion of your sheet. -- HTH, RD |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I change an excel template into a "workbook" | Excel Discussion (Misc queries) | |||
Excel Template fails to open??? | Excel Discussion (Misc queries) | |||
How do I auto number cells in an Excel template? | Excel Discussion (Misc queries) | |||
How do I assign sequential numbers in an Excel 2003 PO template? | Excel Worksheet Functions | |||
How do I use Template wizard add in for 2002 Excel in 2003 excel?. | Excel Worksheet Functions |