Excel Help Please

  • Thread starter Thread starter abulkiewicz
  • Start date Start date
A

abulkiewicz

I was just wondering whether or not you can change the size of the
columns part way down the page without changing the ones at the top?
Do you have any ideas?

Also, I am hoping to be able to validate the numbers that can be
entered into certain cells from allowing decimals between 2.5 and 10,
to actually specifying each number, which wouldn't allow 2.7 from being
entered. Unfortunately with my current validation, you would be able
to add 2.7 which isn't a choice.

I would apprecaite any insight.

Thanks.
 
The column width is exactly that ... the column width. If you want to cheat
you can merge cells but I tend to find that more trouble than it's worth

With regard to validation, Data | Validation A | Allow: List | Source:
2.5,2.8,3.0,7.0 (etc)

Regards

Trevor
 
For display or report purposes, you can take a picture of another portion of
your sheet with different column widths and paste it over the top or bottom
of the portion of the sheet you're viewing......this will give the
"appearance" of what you're looking for and the cells can be dynamic to
follow the values written in the base range......

hth
Vaya con Dios,
Chuck, CABGx3
 
Back
Top