hat
Nan Excel k ap travay, èske ou janm eseye sèlman anpeche nenpòt karaktè espesyal "$! @ # ..."Soti nan yo te tape nan yon seri de selil? Oswa anpeche kèk karaktè sèten tankou "ABCD"Sèlman? Petèt, ou ka aplike kèk fòmil konplèks ak Done Validasyon fonksyon yo rezoud li, sepandan, si ou genyen Kutools pou Excel, ou ka fasilman entèdi tape nan nenpòt karaktè espesyal oswa kèk karaktè sèten nan chenn espesifik pa li yo Anpeche sezisman karakteristik.
eng
In Excel working, have you ever tried to only prevent any special characters “$!@#...” from being typed in a range of cells? Or prevent some certain characters such as “abcd” only? Perhaps, you can apply some complex formulas with Data Validation function to solve it, however, if you have Kutools for Excel, you can easily forbid to type in any special characters or some certain characters in specified ranges by its Prevent Typing feature.