Home
sapew tau nak wat default value in excel,,,
contohnye,,, dlam row A hya "SI" jer leh key in,,,xtau la!!!
contohnye,,, dlam row A hya "SI" jer leh key in,,,xtau la!!!
2 posters
defaulr value
sharina- Ahli Baharu
- Gender : Female Number of posts : 151
Age : 45
Location : Seri Kembangan
Job/hobbies : makan & tidow **tu pown klu rajin..
Registration date : 06/08/2009
mikicun- Ahli Baharu
- Gender : Male Number of posts : 199
Location : somewhere i belongs...
Registration date : 15/02/2009
"SI" tu apa?
huruf SI saja ka atau unit metrik?
huruf SI saja ka atau unit metrik?
sharina- Ahli Baharu
- Gender : Female Number of posts : 151
Age : 45
Location : Seri Kembangan
Job/hobbies : makan & tidow **tu pown klu rajin..
Registration date : 06/08/2009
mikicun wrote:"SI" tu apa?
huruf SI saja ka atau unit metrik?
"SI" sajer,,
not unit SI,, or another example like "ID"
Guest- Guest
1- choose which cell that you don't want to be protected (default is locked)
right click cell > format cells > protection tab > check or uncheck Locked
2- protect the sheet except for the uncheck locked cell
tools > protection > protect sheet
done.
right click cell > format cells > protection tab > check or uncheck Locked
2- protect the sheet except for the uncheck locked cell
tools > protection > protect sheet
done.
sharina- Ahli Baharu
- Gender : Female Number of posts : 151
Age : 45
Location : Seri Kembangan
Job/hobbies : makan & tidow **tu pown klu rajin..
Registration date : 06/08/2009
iluvkarim.selamat wrote:1- choose which cell that you don't want to be protected (default is locked)
right click cell > format cells > protection tab > check or uncheck Locked
2- protect the sheet except for the uncheck locked cell
tools > protection > protect sheet
done.
i think this is not the solution,,,
what i want to know is how to make a default value just for one cell???
if the user key in that more than 3 character in that cell,, the output msg will appear,,,
now,, i dun know how to make a default value only,,, huhu ,, help me plez
Guest- Guest
Owh that.
So the correct question is cell validation.
goto Data > Validation > Settings tab
here you can try the text length validation
Validation criteria:
Allow:
Text length
Data:
equal to
Length:
2
You can create your own Input Message and Error Alert in their tab.
So the correct question is cell validation.
goto Data > Validation > Settings tab
here you can try the text length validation
Validation criteria:
Allow:
Text length
Data:
equal to
Length:
2
You can create your own Input Message and Error Alert in their tab.
Last edited by iluvkarim.selamat on Fri Aug 07, 2009 11:38 am; edited 1 time in total
sharina- Ahli Baharu
- Gender : Female Number of posts : 151
Age : 45
Location : Seri Kembangan
Job/hobbies : makan & tidow **tu pown klu rajin..
Registration date : 06/08/2009
iluvkarim.selamat wrote:Owh that.
So the correct question is cell validation.
goto Data > Validation > Settings tab
here you can the text length validation
Validation criteria:
Allow:
Text length
Data:
equal to
Length:
2
You can create your own Input Message and Error Alert in their tab.
thnx a lot,, can i set just "s" and "i" character only in that cell?
Guest- Guest
In that case, try this
Validation criteria:
Allow:
List
Data:
between (excel fixed for you)
Length:
s, i
The cell should become a drop-down list.
If you want to add more option just do this:
example: s, i, x, x, x
Validation criteria:
Allow:
List
Data:
between (excel fixed for you)
Length:
s, i
The cell should become a drop-down list.
If you want to add more option just do this:
example: s, i, x, x, x
sharina- Ahli Baharu
- Gender : Female Number of posts : 151
Age : 45
Location : Seri Kembangan
Job/hobbies : makan & tidow **tu pown klu rajin..
Registration date : 06/08/2009
iluvkarim.selamat wrote:In that case, try this
Validation criteria:
Allow:
List
Data:
between (excel fixed for you)
Length:
s, i
The cell should become a drop-down list.
If you want to add more option just do this:
example: s, i, x, x, x
xbole jgk,,
cuz if i choost List,
the data "between" xbole
Guest- Guest
Sorry I don't get it.
If you use List, the Data: will be fixed to between. So you can't choose other option.
in Length:, you can either have a multiple value such as: s, i, g, h
or you can just put 1 value such as: s
By using List, user can only choose between those pre-fixed value you entered.
example: s, i
So user can only choose either s or i, or there will be a popup error.
Takpala kalau tak paham gak, japgi saya terang dalam Malay
If you use List, the Data: will be fixed to between. So you can't choose other option.
in Length:, you can either have a multiple value such as: s, i, g, h
or you can just put 1 value such as: s
By using List, user can only choose between those pre-fixed value you entered.
example: s, i
So user can only choose either s or i, or there will be a popup error.
Takpala kalau tak paham gak, japgi saya terang dalam Malay
sharina- Ahli Baharu
- Gender : Female Number of posts : 151
Age : 45
Location : Seri Kembangan
Job/hobbies : makan & tidow **tu pown klu rajin..
Registration date : 06/08/2009
iluvkarim.selamat wrote:Sorry I don't get it.
If you use List, the Data: will be fixed to between. So you can't choose other option.
in Length:, you can either have a multiple value such as: s, i, g, h
or you can just put 1 value such as: s
By using List, user can only choose between those pre-fixed value you entered.
example: s, i
So user can only choose either s or i, or there will be a popup error.
Takpala kalau tak paham gak, japgi saya terang dalam Malay
huhu,,
thnks a lot,,
da siap da,,