![](https://i.aoweibang.com/img/RMQFXR6pIDx9AQZRy8-9eRIyHk64O4yWy7u4WdnaBz5EYClu_byAocXSDwMEIrpmvxJXPvX3doMQIeSr_lm9abjvnHUo1CLbEtdkRN-k8OH_ImsmENMheZuidb7SaDWWl3FhoTY9T3EW_NVpC0c2ZjnAkdsCTEVh0NjwdHN6Xd4o0uwLppS8dMqkvnuz0QBdqmUVTzaeqnqMksydwXfnig/awb.jpg)
![](https://i.aoweibang.com/img/RMQFXR6pIDx9AQZRy8-9eRIyHk64O4yWy7u4WdnaBz5h_2uQcpCagaXzKBkr0zulWuCE4RAgIIBv0waOroVJP7rajiBxH5D1mMUU9ZfX0ia2PvV78n9vGZn6494OdbZi-HVJMXYX8LJo-wIiYaHG7kojkPHJjihvE_trpAx6XTDtzTyQ2ixI2ufVAQe9UngiL1lRTHe1xWigpfd8mxIP-A/awb.jpg)
![](https://i.aoweibang.com/img/RMQFXR6pIDx9AQZRy8-9eRIyHk64O4yWy7u4WdnaBz4ym0AY-oQK6zl6TiQx3HoyIqVTp5V-4bJFv04arNjcR6TOn6Suw2hC6gkfsgUTSJWHKuHTO2RiMPndmeT1DemfJLuLW-hEIuwmdM6i-6LkPqOhsStvKud_Ow2hTaF2nn0o0uwLppS8dMqkvnuz0QBdqmUVTzaeqnqMksydwXfnig/awb.jpg)
然后在[HOME]工具栏最右侧的[Fill]选项中,选择[Justify]选项。
![](https://i.aoweibang.com/img/RMQFXR6pIDx9AQZRy8-9eRIyHk64O4yWy7u4WdnaBz5jKth56ckyLxiFy8c7ocUPmcD5pma5TzU8onGOGtKCS7yolVmh3b530RvlJuMrDZovXTEAQMMsOPP-09oyt4wXQsDU5DprpembGWwkPjT5rAx8CQ12_ANOQjLiVJk1CB4o0uwLppS8dMqkvnuz0QBdqmUVTzaeqnqMksydwXfnig/awb.jpg)
就得到了像这样的效果。
![](https://i.aoweibang.com/img/RMQFXR6pIDx9AQZRy8-9eRIyHk64O4yWy7u4WdnaBz7MdpjmgRSPKv_jOPVxU4uE4RLSAdD_hSu0yLpkss0R0a0maOhlRHP5F2f9IAckG0YQEdIVblsUrJKuwtyX0uQFIZJ3yUaYaM1xJdS5NgYYkC8GIaw1-y2OiJULYfDbGDZiDGb5vzlCSobUwEK3rtBdsUkZ3OEHdZGYpeGnzstuZA/awb.jpg)
![](https://i.aoweibang.com/img/RMQFXR6pIDx9AQZRy8-9eRIyHk64O4yWy7u4WdnaBz5KJhIm-al_D69BbAkeCSrMk-fl0rGbIpN-36TkUg_-fCPn03b_DdWC5CyZjhgz7wlRb_u9vIMkzsPKQD1kkrWS8t_ITYDROp8MZnX118HLpHcgs5A3CO6VptwGaTkbHKC_6V_P79n3MwLRkqppaqppRyHZiI-WUH7g-6UOT1MePg/awb.jpg)
然后,我们在叹号标志的下拉菜单里面选择[Convert to Number],就可以把所有数据转换成数据模式而不是文本模式。这就是最后的效果。
![](https://i.aoweibang.com/img/RMQFXR6pIDx9AQZRy8-9eRIyHk64O4yWy7u4WdnaBz5fylQW3g91C7h1UVcOnvJrgsWaFZ7v5GLJtCLHswAW4CB-KG6wEZZSxjy70MDJ-3DtLokS-F6FPGVzCj89oimvaY7G4b--wUEv2j7M7sbW-CSKSdwvY6lhawSDcQK8S13tzTyQ2ixI2ufVAQe9UngiL1lRTHe1xWigpfd8mxIP-A/awb.jpg)
微软Excel在数据处理领域一直是企业的不二选择。但是真正能够充分利用其中功能的人却很少。我们有时会怀疑Excel的能力,其实是因为我们对Excel还不够了解。
![](https://i.aoweibang.com/img/RMQFXR6pIDx9AQZRy8-9eRIyHk64O4yWy7u4WdnaBz7wZlE0yAy_KsV7Cti2q3jWYUfZnf0y2EL9dif5sNJQu01D5WIOpC2tKVAfU15rn-DgiHAWqfFNzedh4hpb7FjkbmDqcDNiq5uxSTwgORipZQdfQKEdsrg3jc_iZdjbPRu_6V_P79n3MwLRkqppaqppRyHZiI-WUH7g-6UOT1MePg/awb.jpg)
![](https://i.aoweibang.com/img/RMQFXR6pIDx9AQZRy8-9eRIyHk64O4yWy7u4WdnaBz6tiEj7cGhPlxffsiV4X-y0AzapTK0aEx4amuR6eVgTNLlzhP73sQur6AA0flLh4jtCLt1Ca2TH1ljDtbtOSTYbTPekyUa5rxb9IIrT84DMh5WhW6eXLYA6LosdzVR4VluE_lo7AjovTDimDpgbGcq-DZCy6dRdQG9UP97jtyRPBQ/awb.jpg)
![](https://i.aoweibang.com/img/RMQFXR6pIDx9AQZRy8-9eRIyHk64O4yWy7u4WdnaBz6zjZvu4J2sb0WKr2VCFdbu37oQE9eJOASjdh6Dy5FW2Vl7F_5jsnW0FE7no6fW4i0-SufeqqC0qp5KEJyLOBcfvcu5rgr_KMYOYTUkquUsTuKP7SA9-ASned5-nkLwiRQo0uwLppS8dMqkvnuz0QBdqmUVTzaeqnqMksydwXfnig/awb.jpg)
![](https://i.aoweibang.com/img/RMQFXR6pIDx9AQZRy8-9eRIyHk64O4yWy7u4WdnaBz7mUyYuH8fWM8YUDbqR_e-t5aOLviUBkKwMyGOO7EVt0H7B0Ma4O1y6lD4EMo0ESAdDOegKTciynrKzN_7gQwDa4r90UsV3n2cxlaNlqmHaqIVpsMUPPOHWBFmK4CVuEoO_6V_P79n3MwLRkqppaqppRyHZiI-WUH7g-6UOT1MePg/awb.jpg)
![](https://i.aoweibang.com/img/RMQFXR6pIDx9AQZRy8-9eRIyHk64O4yWy7u4WdnaBz6zjZvu4J2sb0WKr2VCFdbu37oQE9eJOASjdh6Dy5FW2Vl7F_5jsnW0FE7no6fW4i0-SufeqqC0qp5KEJyLOBcfvcu5rgr_KMYOYTUkquUsTuKP7SA9-ASned5-nkLwiRQo0uwLppS8dMqkvnuz0QBdqmUVTzaeqnqMksydwXfnig/awb.jpg)
![](https://i.aoweibang.com/img/RMQFXR6pIDx9AQZRy8-9eRIyHk64O4yWy7u4WdnaBz7mUyYuH8fWM8YUDbqR_e-t5aOLviUBkKwMyGOO7EVt0H7B0Ma4O1y6lD4EMo0ESAdDOegKTciynrKzN_7gQwDa4r90UsV3n2cxlaNlqmHaqIVpsMUPPOHWBFmK4CVuEoO_6V_P79n3MwLRkqppaqppRyHZiI-WUH7g-6UOT1MePg/awb.jpg)
微软Excel在数据处理领域一直是企业的不二选择。但是真正能够充分利用其中功能的人却很少。我们有时会怀疑Excel的能力,其实是因为我们对Excel还不够了解。