| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Creating a form with different size lines
I know this has to be relatively easy but I am having the hardest time trying
to create a form for my boss with words and then lines next to them. Then when I scroll down to the middle of the page I want to make new columns with various headings and these columns have various widths. How do I fix this so I can make the columns various sizes to fit the words that need to go in them? HELP! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Creating a form with different size lines
You can not set column widths different depending on the row you are on. So
for example if cell A1 has a width of 15 then A10 can not have a width of 20 becuase both cells are in the same column. When you set the width of a column you are setting it for all of the cells in that column. Same with Row heights. There is only one height for all cells in that row. You can merge cells allowing one cell to span multiple rows or columns. -- HTH... Jim Thomlinson "PurseGirl24" wrote: I know this has to be relatively easy but I am having the hardest time trying to create a form for my boss with words and then lines next to them. Then when I scroll down to the middle of the page I want to make new columns with various headings and these columns have various widths. How do I fix this so I can make the columns various sizes to fit the words that need to go in them? HELP! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Creating a form with different size lines
If you are working on a basic form without formulas, consider using Word with
mutliple tables to accomplisg your needs. HTH "PurseGirl24" wrote: I know this has to be relatively easy but I am having the hardest time trying to create a form for my boss with words and then lines next to them. Then when I scroll down to the middle of the page I want to make new columns with various headings and these columns have various widths. How do I fix this so I can make the columns various sizes to fit the words that need to go in them? HELP! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Creating a form with different size lines
Not easy at all.
Row heights and column widths are properties of the entire row and column. If for presentation only use merged cells as Jim suggests. If you will need to copy, paste, sort, filter or otherwise manipulate your data then merged cells will pose many problems. Gord Dibben MS Excel MVP On Tue, 26 Jan 2010 07:21:01 -0800, PurseGirl24 wrote: I know this has to be relatively easy but I am having the hardest time trying to create a form for my boss with words and then lines next to them. Then when I scroll down to the middle of the page I want to make new columns with various headings and these columns have various widths. How do I fix this so I can make the columns various sizes to fit the words that need to go in them? HELP! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do you insert lines in a quote form | Excel Discussion (Misc queries) | |||
| creating lines with a cell | Excel Discussion (Misc queries) | |||
| how do i form 2 lines in 1 row? | New Users to Excel | |||
| Help with automated size in cells and two lines | Excel Discussion (Misc queries) | |||
| creating 2 lines within one cell | Excel Discussion (Misc queries) | |||
Linear Mode
