Do you know how set the validatin in the worksheet? I have the database worksheet which includes name, address, tel, fax,... I want to set the 'validation' bar on the top. It can easy to sort by type.
Please advise if you know.
Not quite understand your question. If you want Excel to validate the data you input into a certain cell of one column against some pre-defined format , then highlight that column, goto "DATA", then click "VALIDATE.....".
If you want to auto-sort, then goto "DATA", click "Filter", click "Auto-Filter".
If you want to sort the whole worksheet, then go to "DATA", click "SORT".
發表於 
返回列表
