How to remove all formula references but keep values in cells in Excel?

Select the cells you need to remove all references, then press Ctrl + C keys, keep these cells selected, right click and select Values under Paste Options section. Then you can see all formula references of selected cells are removed immediately, and only kept the cell values as below screenshot shown. https://www.extendoffice.com/documents/excel/4228-excel-remove-reference-keep-value.html […]

Read More…

如何提高Office 2013在Windows8或者8.1下的启动速度?

如何提高Office 2013在Windows8或者8.1下的启动速度?我试了很多办法,比如取消GPU加速拉,注册表的人为修改什么的,都没有用。 经过几个小时的试验,终于找到一个办法:就是: 对Office文件(Excel,Word等文件)在打开(Open With)里直接指定执行文件: “C:\Program Files\Microsoft Office 15\root\office15\EXCEL.EXE” 原来打开隐含用的是Excel(Desktop)),我估计是因为Windows 8.1里先看Windows Store里有没有程序可用,然后再去找Desktop里的程序,所以比较慢。 […]

Read More…