是否可以在Excel 2007中看到超过65536行？ [英] Is it possible to see more than 65536 rows in Excel 2007?

问题描述

我有一个excel文件，其中有65536个行。但是，我只能看到第65536个。是否可以在Excel 2007中看到所有这些？

解决方案

这是一个有趣的关于Excel 2007数字/限制的博客条目。根据作者的说法，新的限制是大约<100万行。

听起来像你有一个 pre-Excel 2007工作簿在Excel 2007兼容模式（查看标题栏，看是否说兼容模式​​）。如果是这样，该工作簿有65,536行，而不是1,048,576。您可以将该工作簿另存为Excel 2007的Excel工作簿，关闭工作簿并重新打开。

I have an excel file which has more than 65536 rows. However, I can see only first 65536 of them. Is it possible to see all of them in Excel 2007?

解决方案

Here is an interesting blog entry about numbers / limitations of Excel 2007. According to the author the new limit is approximately one million rows.

Sounds like you have a pre-Excel 2007 workbook open in Excel 2007 in compatibility mode (look in the title bar and see if it says compatibility mode). If so, the workbook has 65,536 rows, not 1,048,576. You can save the workbook as an Excel workbook which will be in Excel 2007 format, close the workbook and re-open it.

这篇关于是否可以在Excel 2007中看到超过65536行？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！