M
majid
hi
I have a problem I want to fix a column's value please
help me
I have a problem I want to fix a column's value please
help me
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Anon
majid said:hi
I have a problem I want to fix a column's value please
help me
You will have to provide more information about what you want.
A column does not have a value. A cell may have a value, but as a column
contains many cells it may contain many values.
A column has a width - is this what you are talking about?
What do you mean by 'fix'?
N
Norman Harker
Hi Majid!
If you mean fix the maximum value that can be put in any cell in a
column:
Select the Column
Data > Validation
Select either "Decimal" or "Whole number"
Put in the allowable minimum
Put in the allowable maximum
"Follow you nose" with Input Message and Error Alert Tabs
OK
Rather than apply to every cell in a column, I think that applying to
the range of actual or potential data entry would be better.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Holidays and Observances Monday 21st July: Belgium (National Day),
Bolivia (Martyrs' Day), Guadeloupe (Victor Schoelcher Day), Guam
(Liberation Day), Japan (Marine Day), Malta (St. George Festa), Peru
(Feria Local Fronteriza Peruano Ecuatoriana), St. Martin (Schoelcher
Day).
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
If you mean fix the maximum value that can be put in any cell in a
column:
Select the Column
Data > Validation
Select either "Decimal" or "Whole number"
Put in the allowable minimum
Put in the allowable maximum
"Follow you nose" with Input Message and Error Alert Tabs
OK
Rather than apply to every cell in a column, I think that applying to
the range of actual or potential data entry would be better.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Holidays and Observances Monday 21st July: Belgium (National Day),
Bolivia (Martyrs' Day), Guadeloupe (Victor Schoelcher Day), Guam
(Liberation Day), Japan (Marine Day), Malta (St. George Festa), Peru
(Feria Local Fronteriza Peruano Ecuatoriana), St. Martin (Schoelcher
Day).
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
S
Stephen Dunn
Or, possibly you mean that you wish to replace calculated values with
constant values. Select the column, copy it, and use
Edit>Paste_Special>Values.
constant values. Select the column, copy it, and use
Edit>Paste_Special>Values.