Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
jlr
 
Posts: n/a
Default 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   Report Post  
Ragdyer
 
Posts: n/a
Default

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   Report Post  
jlr
 
Posts: n/a
Default

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   Report Post  
Ragdyer
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I change an excel template into a "workbook" joyce Excel Discussion (Misc queries) 5 April 14th 05 04:38 PM
Excel Template fails to open??? Rob Smith Excel Discussion (Misc queries) 2 April 11th 05 06:42 PM
How do I auto number cells in an Excel template? Natalie Excel Discussion (Misc queries) 3 March 30th 05 03:42 AM
How do I assign sequential numbers in an Excel 2003 PO template? skiusa Excel Worksheet Functions 1 March 28th 05 10:57 PM
How do I use Template wizard add in for 2002 Excel in 2003 excel?. TCIrish Excel Worksheet Functions 0 November 23rd 04 04:43 PM


All times are GMT +1. The time now is 05:29 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"