Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do I combine two forms with different size columns to make on.
I built two forms to make one as I cannot control the difference in columns
sizes. Now I cannot merge the two forms to make one. Is this possible or have I wasted hours. I am fairly new to forms. Thank you |
#2
|
|||
|
|||
Hi
not sure what you mean by "forms", if you're talking about laying information out in a worksheet, then you can not change column sizes within the same column ... ie the size of column A is applicable to all 65536 rows. However, a "workaround" is to merge adjacent cells (format / cells - alignment tab, merge cells) ... however, merging cells can cause problems if you wish to sort (or filter) the data later. -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "Morningside" wrote in message ... I built two forms to make one as I cannot control the difference in columns sizes. Now I cannot merge the two forms to make one. Is this possible or have I wasted hours. I am fairly new to forms. Thank you |
#3
|
|||
|
|||
Hi
not sure what you mean by "forms", if you're talking about laying information out in a worksheet, then you can not change column sizes within the same column ... ie the size of column A is applicable to all 65536 rows. However, a "workaround" is to merge adjacent cells (format / cells - alignment tab, merge cells) ... however, merging cells can cause problems if you wish to sort (or filter) the data later. -- Cheers JulieD check out www.hcts.net.au/tipsandtricks.htm ....well i'm working on it anyway "Morningside" wrote in message ... I built two forms to make one as I cannot control the difference in columns sizes. Now I cannot merge the two forms to make one. Is this possible or have I wasted hours. I am fairly new to forms. Thank you |
#4
|
|||
|
|||
Don't quite understand exactly what your question is, but if it's relating
to the creation of XL sheets to use for presentation purposes, this old post may help to get you started: http://tinyurl.com/52hwo -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Morningside" wrote in message ... I built two forms to make one as I cannot control the difference in columns sizes. Now I cannot merge the two forms to make one. Is this possible or have I wasted hours. I am fairly new to forms. Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Font Size for Forms ComboBox in Excel | Excel Worksheet Functions | |||
Large Excel file size caused by a bug ? I really tried everything | Excel Discussion (Misc queries) | |||
Customize page size | Setting up and Configuration of Excel | |||
Forms Check Box Font Size | Excel Discussion (Misc queries) | |||
SPECIFY REQUIRED PAPER SIZE IN EXCEL 2000 | Excel Discussion (Misc queries) |