EXCEL 上的問題

%3CLINGO-SUB%20id%3D%22lingo-sub-2848676%22%20slang%3D%22zh-CN%22%3EProblems%20on%20EXCEL%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2848676%22%20slang%3D%22zh-CN%22%3E%3CP%3EHello.%20The%20text%20data%20on%20the%20EXCEL%20table%20was%20originally%20arranged%20from%201-10000.%20But%20it%20will%20be%20long%20before%20the%20word%20is%20found.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%3A%201-1000%20.%20Of%20these%2C%20300-305%20will%20be%20456-460.%20But%20the%20next%20words%20will%20be%20306%20in%20sequence.%20This%20kind%20of%20information%20cannot%20be%20removed%20because%20of%20the%20large%20number%20of%20data%20in%20the%20EXCEL%20table.%20Is%20there%20a%20way%20to%20correct%20the%20problem%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2848676%22%20slang%3D%22zh-CN%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2848913%22%20slang%3D%22en-US%22%3ERe%3A%20EXCEL%20%E4%B8%8A%E7%9A%84%E5%95%8F%E9%A1%8C%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2848913%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1186226%22%20target%3D%22_blank%22%3E%40miazzz630%3C%2FA%3E%3C%2FP%3E%3CDIV%20class%3D%22%22%3E%3CDIV%20class%3D%22%22%3E%3CDIV%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3E%E4%B8%AD%E6%96%87%EF%BC%9A%E6%9C%AC%E6%96%87%E4%B8%BA%E6%9C%BA%E5%99%A8%E7%BF%BB%E8%AF%91%E3%80%82%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3E%3CSPAN%3E%E6%96%87%E6%9C%AC%E4%BD%9C%E8%80%85%E4%B8%8D%E4%BC%9A%E8%AF%B4%E8%BF%99%E7%A7%8D%E8%AF%AD%E8%A8%80%E3%80%82%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3E%3CSPAN%3E%E5%B0%BD%E5%8F%AF%E8%83%BD%E4%BB%8E%E5%B0%8A%E9%87%8D%E7%94%A8%E6%88%B7%E7%9A%84%E8%A7%92%E5%BA%A6%E8%BF%9B%E8%A1%8C%E7%BF%BB%E8%AF%91%E3%80%82%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3E%E5%9C%A8%E6%82%A8%E7%9A%84%E8%AE%B8%E5%8F%AF%E4%B8%8B%EF%BC%8C%E5%A6%82%E6%9E%9C%E6%88%91%E5%8F%AF%E4%BB%A5%E6%8E%A8%E8%8D%90%EF%BC%8C%E8%AF%B7%E5%8F%91%E9%80%81%E4%B8%80%E4%B8%AA%E6%96%87%E4%BB%B6%EF%BC%88%E4%B8%8D%E5%90%AB%E6%95%8F%E6%84%9F%E6%95%B0%E6%8D%AE%EF%BC%89%E5%B9%B6%E4%BD%BF%E7%94%A8%E8%AF%A5%E6%96%87%E4%BB%B6%E6%9D%A5%E6%8F%8F%E8%BF%B0%E6%82%A8%E7%9A%84%E9%97%AE%E9%A2%98%E3%80%82%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22%22%3E%3CSPAN%3E%E4%BA%86%E8%A7%A3%20Excel%20%E7%89%88%E6%9C%AC%E5%92%8C%E6%93%8D%E4%BD%9C%E7%B3%BB%E7%BB%9F%E5%B0%86%E6%98%AF%E4%B8%80%E4%B8%AA%E4%BC%98%E5%8A%BF%EF%BC%8C%E4%BB%A5%E4%BE%BF%E4%B8%BA%E6%82%A8%E6%8F%90%E4%BE%9B%E5%BF%AB%E9%80%9F%E5%87%86%E7%A1%AE%E7%9A%84%E8%A7%A3%E5%86%B3%E6%96%B9%E6%A1%88%E5%BB%BA%E8%AE%AE%E3%80%82%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22%22%3E%3CDIV%20class%3D%22%22%3E%3CDIV%20class%3D%22%22%3E%3CH1%20id%3D%22toc-hId-1472333808%22%20id%3D%22toc-hId-1472331139%22%3E%3CSPAN%20class%3D%22%22%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fwelcome-to-your-excel-discussion-space%2Fm-p%2F2204395%22%20target%3D%22_self%22%3E%E6%AC%A2%E8%BF%8E%E6%9D%A5%E5%88%B0%E6%82%A8%E7%9A%84Excel%E8%AE%A8%E8%AE%BA%E7%A9%BA%E9%97%B4%EF%BC%81%3C%2FA%3E%20%3C%2FSPAN%3E%3C%2FH1%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%3CDIV%20class%3D%22%22%3E%3CP%20class%3D%22%22%3E%E7%BF%BB%E8%AF%91%E8%87%AA%E8%8B%B1%E6%96%87%20(%E8%8B%B1%E6%96%87)%3C%2FP%3E%3CP%3E%E5%A6%82%E6%9E%9C%E4%BD%A0%E6%83%B3%E9%97%AE%E4%B8%80%E4%B8%AA%E9%97%AE%E9%A2%98%E6%88%96%E5%BC%80%E5%A7%8B%E5%85%B3%E4%BA%8EExcel%E7%9A%84%E5%AF%B9%E8%AF%9D%EF%BC%8C%E4%BD%A0%E6%98%AF%E5%9C%A8%E6%AD%A3%E7%A1%AE%E7%9A%84%E5%9C%B0%E6%96%B9%EF%BC%81%E8%B5%B0%E5%BC%80%E3%80%82%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CP%3E%E6%84%9F%E8%B0%A2%E6%82%A8%E7%9A%84%E7%90%86%E8%A7%A3%E5%92%8C%E8%80%90%E5%BF%83%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%E5%B0%BC%E7%A7%91%E5%88%A9%E8%AF%BADE%3C%2FP%3E%3CP%3E%E6%88%91%E7%9F%A5%E9%81%93%E6%88%91%E4%BB%80%E4%B9%88%E9%83%BD%E4%B8%8D%E7%9F%A5%E9%81%93%EF%BC%88%E8%8B%8F%E6%A0%BC%E6%8B%89%E5%BA%95%EF%BC%89%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EIn%20English%3A%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%20class%3D%22%22%3E%3CSPAN%3EWith%20your%20permission%2C%20if%20I%20may%20recommend%2C%20send%20a%20file%20(without%20sensitive%20data)%20and%20use%20this%20file%20to%20describe%20your%20problem.%20Knowledge%20of%20the%20Excel%20version%20and%20the%20operating%20system%20would%20be%20an%20advantage%20in%20order%20to%20provide%20you%20with%20a%20quick%20and%20precise%20solution%20proposal.%20%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CDIV%20class%3D%22%22%3E%3CDIV%20class%3D%22%22%3E%3CDIV%20class%3D%22%22%3E%3CH1%20id%3D%22toc-hId--335120655%22%20id%3D%22toc-hId--335123324%22%3E%3CU%3E%3CSPAN%20class%3D%22%22%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fwelcome-to-your-excel-discussion-space%2Fm-p%2F2204395%22%20target%3D%22_self%22%3E%3CFONT%20color%3D%22%230000FF%22%3EWelcome%20to%20your%20Excel%20discussion%20space!%3C%2FFONT%3E%20%3C%2FA%3E%3C%2FSPAN%3E%3C%2FU%3E%3C%2FH1%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FDIV%3E%3CDIV%20class%3D%22%22%3E%3CDIV%20class%3D%22%22%3E%3CP%3EIf%20you%E2%80%99re%20looking%20to%20ask%20a%20question%20or%20start%20a%20conversation%20about%20Excel%2C%20you%E2%80%99re%20in%20the%20right%20place!%26nbsp%3B%3C%2FP%3E%3CP%3EAsk%20away.%20Click%20on%20the%20upper%20Link%20fo%20rmore%20Informations.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolinoDE%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FDIV%3E%3C%2FDIV%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

你好. 請問EXCEL 表上的數字資料原本由1-10000排列. 但發現了會久不久數字就會亂了. 

 

比如: 1-1000 . 其中300-305會變了456-460.但其後的數字又會由306順序下去. 這種 由於EXCEL表內資料眾多,不能刪除. 請問有辦法改正嗎?

1 Reply

@miazzz630

中文:本文为机器翻译。 文本作者不会说这种语言。 尽可能从尊重用户的角度进行翻译。

 

在您的许可下,如果我可以推荐,请发送一个文件(不含敏感数据)并使用该文件来描述您的问题。 了解 Excel 版本和操作系统将是一个优势,以便为您提供快速准确的解决方案建议。

 

翻译自英文 (英文)

如果你想问一个问题或开始关于Excel的对话,你是在正确的地方!走开。

感谢您的理解和耐心

 

尼科利诺DE

我知道我什么都不知道(苏格拉底)

 

In English:

With your permission, if I may recommend, send a file (without sensitive data) and use this file to describe your problem. Knowledge of the Excel version and the operating system would be an advantage in order to provide you with a quick and precise solution proposal.

If you’re looking to ask a question or start a conversation about Excel, you’re in the right place! 

Ask away. Click on the upper Link fo rmore Informations.

 

Thank you for your understanding and patience

 

NikolinoDE

I know I don't know anything (Socrates)