Variable-width cells

  • Thread starter Thread starter Sam Hobbs
  • Start date Start date
S

Sam Hobbs

Is it possible to have variable-width cells in a column?

I know that it is possible to do things like that using other UI, such as
HTML. Is it possible in a spreadsheet? I get the impression that it is not
possible, so if it is not, then I won't waste time trying to figure it out.
If it is possible then it helps to know that it is; any details will be
appreciated but I will read the documentation if it is in there somewhere.
 
Is it possible to have variable-width cells in a column?

I know that it is possible to do things like that using other UI, such as
HTML. Is it possible in a spreadsheet? I get the impression that it is not
possible, so if it is not, then I won't waste time trying to figure it out.
If it is possible then it helps to know that it is; any details will be
appreciated but I will read the documentation if it is in there somewhere..
Click to expand...

Sam,

Cells in the same column cant be different widths.
You can merge cells to achieve the effect but thats about all.


Regards

David
 
Not without using "merged cells" which come with their own set of problems
and should be avoided like the plague.

For headers and titles you can use the "Center across selection" function.


Gord Dibben MS Excel MVP
 
Gord Dibben said:
Not without using "merged cells" which come with their own set of problems
and should be avoided like the plague.

For headers and titles you can use the "Center across selection" function.


Gord Dibben MS Excel MVP
Click to expand...


Thank you both David and Gord.

So we probably need to use a macro to create a form for the presentation. A
HTML table is flexible and might work (in a WebBrowser control). This is for
someone else so I am not sure of the requirements but I am quite experienced
with building HTML using DHTML/DOM. I think there is at least one grid
control that is very flexible about cells and rows and we will look for that
if we need to.
 
Back
Top