excel保存时崩溃
This week, I've been working in an Excel 2007 file that has several named Excel Tables. After adding a column in one table, I copied the entire worksheet column.
本周,我正在研究一个包含多个名为Excel Tables的Excel 2007文件。 在一个表中添加一列后,我复制了整个工作表列。
![ExcelTableCrash01 ExcelTableCrash01](https://i-blog.csdnimg.cn/blog_migrate/57c7bbc73099c2fe788633767f7285fa.png)
Next, I tried to paste it into another worksheet, where there was a similar table.
接下来,我尝试将其粘贴到另一个有类似表格的工作表中。
![ExcelTableCrash02 ExcelTableCrash02](https://i-blog.csdnimg.cn/blog_migrate/7914b4fea1c22cba85a2287aea62ad05.png)
That didn't go too well. After a few minutes of staring at the hourglass, I gave up, and closed Excel in the Task Manager.
那不是很好。 盯着沙漏几分钟后,我放弃了,在任务管理器中关闭了Excel。
![ExcelTableCrash03 ExcelTableCrash03](https://i-blog.csdnimg.cn/blog_migrate/d66af75d435f8b07195a28ec41ac7bb0.png)
Today, I tried to repeat the column copy and paste, forgetting about the previous problem.
今天,我尝试重复列复制和粘贴操作,而忘记了先前的问题。
Sure enough, Excel crashed again. Well, technically, I guess it's a hang, rather than a crash, but it's still annoying.
果然,Excel再次崩溃了。 好吧,从技术上讲,我认为这是死机,而不是崩溃,但这仍然很烦人。
较小名称的Excel表 (A Smaller Named Excel Table)
In a smaller workbook, with smaller tables, the copy eventually completed, but with strange results. There was a strange message in the Status Bar.
在具有较小表的较小工作簿中,该副本最终完成了,但是结果很奇怪。 状态栏中有一条奇怪的消息。
![ExcelTableCrash04 ExcelTableCrash04](https://i-blog.csdnimg.cn/blog_migrate/111f7e7825e5b7068124c0103dc2eeff.png)
Eventually, the copy completed, but instead of the ten rows from the original table, the paste filled the entire column, so the named Excel Table ended in the last row.
最终,复制完成了,但是粘贴代替了原始表的十行,而填充了整个列,因此命名为Excel的表在最后一行结束。
![ExcelTableCrash05 ExcelTableCrash05](https://i-blog.csdnimg.cn/blog_migrate/2abb4bbe2c9bacd1f107ad143b19317f.png)
成功复制和粘贴 (Successful Copy and Paste)
Instead of copying and pasting the entire column, you can copy and paste the named Excel table column.
您可以复制并粘贴命名的Excel表列,而不是复制和粘贴整个列。
- To select the table column, click, the top of the table heading cell, instead of the column heading button. 若要选择表列,请单击表标题单元格的顶部,而不是列标题按钮。
-
- Then, to paste into the other table, right-click the heading cell, and paste. 然后,要粘贴到另一个表中,请右键单击标题单元格,然后粘贴。
-
Or you can copy the cells, and paste them, instead of copying and pasting the column.
或者,您可以复制单元格并粘贴它们,而不是复制并粘贴列。
您如何使Excel崩溃? (How Do You Crash Excel?)
Enough about my problems! What's your favourite way to crash/hang Excel? ________________
我的问题够了! 您最喜欢的使Excel崩溃/挂起的方法是什么? ________________
翻译自: https://contexturesblog.com/archives/2011/02/11/how-to-crash-excel/
excel保存时崩溃