In Excel cell use small keyboards to quickly enter the addition,

03/09/2011 17:49

 

 subtraction, multiplication, division, such as calculated every time you want to input equals to display operation result, appear very complicated. If no input equals to display text format Microsoft Office 2007 is welcomed by the whole world.  

publication

Content, whether every time without having to enter equals?

Method one:

In the small keyboard direct input "+ 61-82," carriage return or just like F9 can be calculated results, including "+" sign can represent "=" number. Many people like Microsoft Office.

Method 2:

In Excel2003 in click menu "tool - options - 1-2-3 help", "in the worksheet options" under the ticker "convert" Lotus 1-2-3 formula, and then click "ok". Microsoft Office 2010 is so great!

In Excel2007 in click "Office button - Excel options - advanced", "Lotus 1-2-3 micro-guidewire conversion formula" click "ok". Windows 7 make life wonderful!

After that the cell when they don't lose input formula "=" number, pay attention to this option only about a job table effective without affecting to other worksheet.

This article from the office software, the original address: learn net https://www.officestudy.cn Office 2007 makes life great!

If in the work often need to simultaneously to certain work book of editing, every time I will discuss workbook slightly open these trival. Then all work book window current layout save as workspace file

(*. XLW), next time can also quickly open these workbook continue last work. The method is as follows:

1. Open and maintain all work books.

2. In Excel 2003 click menu "guide-explore-design-grasp save workspace file". In 2007 / Excel in 2010 choose "view" TAB, in "the window" group click "save workspace" button. Office 2007 download is helpful!