在Excel中输入数据的几种方法

Several Methods for Data Input in Microsoft Excel

探讨了使用MicrosoftExcel进行表格处理时所采用的几种数据输入方法 ,通过实例详细介绍了利用公式、函数或Macro (宏 )向Worksheet (工作表 )输入数据的操作过程 ,并提供了Macro源程序 .在不同的场合下应用文中介绍的方法 ,不仅可以快速且准确地进行数据输入 ,而且可以实现数据的自动输入 ,得到事半功倍的效果 .

The methods used for data input when working under Microsoft Excel are discussed in this paper. The operation sequence of inputting data to worksheet by means of formula, function or Macro is introduced through examples and the Macro source program are presented in detail. With the help of the methods as stated, data can be inputted not only quickly and accurately, but also automatically in different occasions. The methods are actually of high efficiency.