电子表格制作简易教程(可编辑修改word版)

thrift of excellent traditional and style lack deep of understanding, one-sided think in now of good situation Xia, economic smooth more fast development, and reform made major progress, and people living significantly improve, and social he career made new progress, no necessary always hard has, no awareness to China also has many poverty area, and also has many poverty population of exists, more living improve has, more need keep hard of style. Three is not strictly honest. otal thought units is a water sector, clean self-discipline away from himself too far, no real processing good living of improve and hard, and thrift excellent traditional of relationship, no effective do comply with Constitution and party of regulations must from I do up, no right mercy good bitter Le, and wealth of relationship, no right awareness to in comply with Constitution and party of regulations aspects everyone has accountability. Four, future direction and improvement measures 1, belief and faith, strengthen party spirit. One is to firmly establish the noble ideals of struggle for the ideals of communism, communist struggle for life, ready to sacrifice everything for the party and the people. Second is to continuously improve the quality and standard of political, conscientiously study Deng Xiaoping theory and \presents\hought and the scientific Outlook on development, implement the party's basic program for the primary stage of socialism, adhere to the correct political orientation, maintain highly consistent with the CPC Central Committee, is good at theories of socialism with Chinese characteristics to analyze and solve problems. Third, strengthening the party spirit and the world transformation, perseverance of the party Constitution, relive Party vows to establish correct world Outlook, Outlook on life and the world, practically embodies ideals and beliefs into action, combine lofty ideals and practical activities, transforming the objective world, activelyparticipate in the great practice of building socialism with Chinese characteristics. 2, keep the purpose in concept, changing the style of work. First, keep in mind that the purpose of serving, adhere to assuming power for the people, keep in mind the people and care about people, and the joys and sorrows of the masses, ...According to city discipline, and municipal organization Department requirements, today we held \ementation independent Commission against corruption guidelines effective strengthening led cadres style construction\c democratic life, main task is close contact thought, and work actual, control check district Standing Committee team and the personal in implementation independent Commission against corruption guidelines Shang exists of problem, in-depth carried out criticism and self-critical, further clear rectification direction and measures, effective enhanced clean politics of consciousness and initiative, firm set good of ruling image. Before the meeting, the way we take surveys solicited a views, combed, related to team building电子表格制作简易教程

考虑到咱们部门大多数人没有使用Excel的相关经验，我在此写一点基础性的做表方法和心得，做表老手就不用看了。

Excel其软件

现在的Excel软件分为微软旗下的“office Excel”和中国国产的“WPS表格”。两者大同小异，且在我看来，WPS系列软件是office系列软件的山寨版。不过，我们也不得不承认，WPS这个山寨货比office好用。由于本人使用的是WPS的版本，所以接下来的内容都是以WPS表格制作为例的。

秘书处所做表的类型

秘书处的电子表只是运用了Excel软件中非常基础的部分，因此个人认为是非常容易学习的。我们所做的电子表和常见的数据类电子表不同，我们的多是信息类的表，例如“秘书处联系表”这种。这样以来，电子表的整个“函数”部分我们都不需要接触了，即

基本概念

1.单元格：打开Excel软件，入眼的一个个格状物，便是一个一个的单元格。从一定的程度上来讲，每个单元格都是可以看作是一个迷你的文档。

2.先选定后操作：微软几乎所有的软件都是“先选定，后操作”，例如，你要先选择你要修改的文字，然后才能进行字体大小等等的调整。这一点看起来很傻很基础，但却非常非常重要，很多常做表的人都没有注意到这一点，使得操作更加复杂。

工具栏里的常用按键

①③ ⑦ ⑧ ② ④ ⑤ ⑥ ⑨ ①字体，不解释。 ②字号，即字的大小。

③字体加粗，多用在标题上。

④居中，为了表格的美观，我们会让单元格内的内容放在整个单元格的正中间。不过这个按键往往只能做到“水平居中”而不能“垂直居中”。垂直居中后面再讲。

⑤自动换行，如图1-1，右边的“性别”二字使用了“自动换行”。在一个单元格里，按“回车”键是没有换行效果的。很多新手会使用空格达到换行的

1-1 目的，这样会使表难以修改。

⑥合并单元格，这是秘书处的电子表中最最常用的按键。用法是拖黑多个单元格（即选定），然后点击此按钮（即操作）。如图1-2，左边的“副部长”使用了“合并单元格”。灵活运用合并单元格功能是使电子表排版美观的关键。

⑦边框，后面再着重讲。

1-2

⑧填充颜色，自行尝试。不太常用 ⑨字体颜色，不解释。

project work, cadres, cadres selection and other aspects of a total of 19, further defined the direction of rectification, enhancing the pertinence and effectiveness of democratic life. Good for this meeting, we requested the Standing Committee of the municipal party Committee, municipal Secretary General Tang Wenjin, the City Commission for discipline inspection Standing Committee Yng Xu, Jiang Jixue, Deputy Director of the personnel office, and other leading comrades present guidance allows us to warm applause for their welcome and thanks! Below, I first District Committee member of the 20XX team annual democratic meeting implementation of the corrective measures, as well as member of the team and of my own report guidelines for the implementation of the independent Commission against corruption statement invited leaders and comrades criticism. First, annual party on the 20XX team, Member of democratic life action plan implementation year 20XX, district democratic meeting a member of the team on \and practice the scientific Outlook on development\oject supporting strong enough, the industry well enough, urban construction management level needs to be improved, livelihood improvementneeds to be strengthened, district team itself, such as the five aspects. ear of 20XX, we find out the problems mentioned above, based on actual Shunqing construction and development, conscientiously sum up improvements, achieving significant development results and effectiveness of their work. (A) highlight the project handle, maintain high growth of investment. Adhere to the strategy as a Foundation, carrying out projects to promote increased stamina important. One is to increase the intensity of projects towards. Actively seek national and provincial policy support, superior special transfer payments, a variety of additional income will top 700 million Yuan, a number of key infrastructure projects, livelihood projects, industrial projects into the cage. Second, increasing the project attracts. This year a total of 23 signed a major project, of which 14 billion project, China Metallurgical group, vanke group, Guangdong hengda group, Taiwan Ruentex group, on the RI group, Shenzhen Kaisa, jifeng agricultural machinery, Mercedes-Benz, Audi 4S store and other large enterprises and projects have settled in Shunqing. Third, strengthen project construction. Annual implementation focus project 39 a, fixed assets investment total will breakthrough 12 billion yuan, created district yilai history high, South door dam, and five in shop old city transformation, and Ying China industrial concentrated district construction, and city main road construction, and Northeast steam Trade Center, and modern farmers industry Park, and vocational education city, and low rental, and also room construction, and features blocks build, and farmers market transformation, and \l version\engineering speed up implementation, effectiveness obviously. Expected to be achieved this year, area-wide GDP 17 billion thrift of excellent traditional and style lack deep of understanding, one-sided think in now of good situation Xia, economic smooth more fast development, and reform made major progress, and people living significantly improve, and social the career made new progress, no necessary always hard has, no awareness to China also has many poverty area, and also has many poverty population of exists, more living improve has, more need keep hard of style. Three is not strictly honest. otal thought units is a water sector, clean self-discipline away from himself too far, no real processing good living of improve and hard, and thrift excellent traditional of relationship, no effective do comply with Constitution and party of regulations must from I do up, no right mercy good bitter Le, and wealth of relationship, no right awareness to in comply with Constitution and party of regulations aspects everyone has accountability. Four, future direction and improvement measures 1, belief and faith, strengthen party spirit. One is to firmly establish the noble ideals of struggle for the ideals of communism, communist struggle for life, ready to sacrifice everything for the party and the people. Second is to continuously improve the quality and standard of political, conscientiously study Deng Xiaoping theory and \presents\hought and the scientific Outlook on development, implement the party's basic program for the primary stage of socialism, adhere to the correct political orientation, maintain highly consistent with the CPC Central Committee, is good at theories of socialism with Chinese characteristics to analyze and solve problems. Third, strengthening the party spirit and the world transformation, perseverance of the party Constitution, relive Party vows to establish correct world Outlook, Outlook on life and the world, practically embodies ideals and beliefs into action, combine lofty ideals and practical activities, transforming the objective world, activelyparticipate in the great practice of building socialism with Chinese characteristics. 2, keep the purpose in concept, changing the style of work. First, keep in mind that the purpose of serving, adhere to assuming power for the people, keep in mind the people and care about people, and the joys and sorrows of the masses, ... According to city discipline, and municipal organization Department requirements, today we held \ementation independent Commission against corruption guidelines effective strengthening led cadres style construction\c democratic life, main task is close contact thought, and work actual, control check district Standing Committee team and the personal in implementation independent Commission against corruption guidelines Shang exists of problem, in-depth carried out criticism and self-critical, further clear rectification direction and measures, effective enhanced clean politics of consciousness and initiative, firm set good of ruling image. Before the meeting, the way we take surveys solicited a views, combed, related to team building鼠标右键里的内容

①

②

③

④

⑤

⑥

①、②、③是整个计算机里的基本操作，不会的同学可以自行查阅资料，或者单独来问我。在此就不多解释了。

④插入，即在当前选定行（或列）的上面（或左面）插入一行（或一列）单元格，通常插入单元格的方式是，把鼠标放到左边的数字（或上面的字母）上，单击右键，点插入即可。

⑤删除，即将当前选定内容删除。这与键盘上的“退格键”和“Delete”键是不太一样的。退格键个删除光标前（即闪动的那个竖线）的内容，Delete是删除光标后的内容，而这里的删除是将这个单元格的内容及其格式（如边框）完全删掉。

⑥设置单元格格式是整个电子表里最最重要的部分，是区分老手和新手的一个重要标志。因此接下来我特设一个分标题来讲。

设置单元格格式

1、数字

大家尝试一下，在一个单元格里输入18位身份证号会发生什么。

我们只需要将该单元格选定，然后打开“设置单元格格式”，在“数字”选项卡中，将“常规”改为“文本”即可。

在输入电话号码和身份证时会用到这种做法。

至于其他的分类，咱们的表里不多用，有兴趣的同学可以自行尝试。

project work, cadres, cadres selection and other aspects of a total of 19, further defined the direction of rectification, enhancing the pertinence and effectiveness of democratic life. Good for this meeting, we requested the Standing Committee of the municipal party Committee, municipal Secretary General Tang Wenjin, the City Commission for discipline inspection Standing Committee Yng Xu, Jiang Jixue, Deputy Director of the personnel office, and other leading comrades present guidance allows us to warm applause for their welcome and thanks! Below, I first District Committee member of the 20XX team annual democratic meeting implementation of the corrective measures, as well as member of the team and of my own report guidelines for the implementation of the independent Commission against corruption statement invited leaders and comrades criticism. First, annual party on the 20XX team, Member of democratic life action plan implementation year 20XX, district democratic meeting a member of the team on \and practice the scientific Outlook on development\oject supporting strong enough, the industry well enough, urban construction management level needs to be improved, livelihood improvement needs to be strengthened, district team itself, such as the five aspects. ear of 20XX, we find out the problems mentioned above, based on actual Shunqing construction and development, conscientiously sum up improvements, achieving significant development results and effectiveness of their work. (A) highlight the project handle, maintain high growth of investment. Adhere to the strategy as a Foundation, carrying out projects to promote increased stamina important. One is to increase the intensity of projects towards. Actively seek national and provincial policy support, superior special transfer payments, a variety of additional income will top 700 million Yuan, a number of key infrastructure projects, livelihood projects, industrial projects into the cage. Second, increasing the project attracts. This year a total of 23 signed a major project, of which 14 billion project, China Metallurgical group, vanke group, Guangdong hengda group, Taiwan Ruentex group, on the RI group, Shenzhen Kaisa, jifeng agricultural machinery, Mercedes-Benz, Audi 4S store and other large enterprises and projects have settled in Shunqing. Third, strengthen project construction. Annual implementation focus project 39 a, fixed assets investment total will breakthrough 12 billion yuan, created district yilai history high, South door dam, and five in shop old city transformation, and Ying China industrial concentrated district construction, and city main road construction, and Northeast steam Trade Center, and modern farmers industry Park, and vocational education city, and low rental, and also room construction, and features blocks build, and farmers market transformation, and \on\ Street transformation, focus engineering speed up implementation, effectiveness obviously. Expected to be achieved this year, area-wide GDP 17 billion thrift of excellent traditional and style lack deep of understanding, one-sided think in now of good situation Xia, economic smooth more fast development, and reform made major progress, and people living significantly improve, and social the career made new progress, no necessary always hard has, no awareness to China also has many poverty area, and also has many poverty population of exists, more living improve has, more need keep hard of style. Three is not strictly honest. otal thought units is a water sector, clean self-discipline away from himself too far, no real processing good living of improve and hard, and thrift excellent traditional of relationship, no effective do comply with Constitution and party of regulations must from I do up, no right mercy good bitter Le, and wealth of relationship, no right awareness to in comply with Constitution and party of regulations aspects everyone has accountability. Four, future direction and improvement measures 1, belief and faith, strengthen party spirit. One is to firmly establish the noble ideals of struggle for the ideals of communism, communist struggle for life, ready to sacrifice everything for the party and the people. Second is to continuously improve the quality and standard of political, conscientiously study Deng Xiaoping theory and \presents\hought and the scientific Outlook on development, implement the party's basic program for the primary stage of socialism, adhere to the correct political orientation, maintain highly consistent with the CPC Central Committee, is good at theories of socialism with Chinese characteristics to analyze and solve problems. Third, strengthening the party spirit and the world transformation, perseverance of the party Constitution, relive Party vows to establish correct world Outlook, Outlook on life and the world, practically embodies ideals and beliefs into action, combine lofty ideals and practical activities, transforming the objective world, activelyparticipate in the great practice of building socialism with Chinese characteristics. 2, keep the purpose in concept, changing the style of work. First, keep in mind that the purpose of serving, adhere to assuming power for the people, keep in mind the people and care about people, and the joys and sorrows of the masses, ...According to city discipline, and municipal organization Department requirements, today we held \ementation independent Commission against corruption guidelines effective strengthening led cadres style construction\c democratic life, main task is close contact thought, and work actual, control check district Standing Committee team and the personal in implementation independent Commission against corruption guidelines Shang exists of problem, in-depth carried out criticism and self-critical, further clear rectification direction and measures, effective enhanced clean politics of consciousness and initiative, firm set good of ruling image. Before the meeting, the way we take surveys solicited a views, combed, related to team building2、对齐

上面所提到的“居中”按键，只能做到水平居中，无法做到垂直居中。那么这里的“文本对齐方式”就可以解决这一问题了。选定单元格后，单击右键，在“设置单元格”里调试即可。

这里的自动换行和上面所提到的自动换行按键是一样的。不过自动换行按键只在国产WPS里有，微软的office里想自动换行就只能调试“单元格格式”了。

另外，“方向”里的“文本”按键，可以把横排的文字变成竖排，美观用的。

3.、边框

打开Excel软件，入眼所见的格子，在打印的时候是不会出现的。只有通过这里，把边框加进去以后才会有网格线。

大家多试试“边框”选项卡里的按键分别有什么用。

4、其它

“字体”和菜单栏里的字体设置是一样的，就不多加赘述了。“图案”和“保护”很少用到，略过不提。

其它常用按键和工具

1、行高（或列宽）

将鼠标移至左边数字处（或上面字母处），待鼠标变成一个箭头后，单击右键，会出现行高（或列宽）选项。这样一来可以手动输入所需要的数值。可以选定多行（或多列）后更改行高（或列宽），这样选定的行（或列）就一样高（或宽）了。

project work, cadres, cadres selection and other aspects of a total of 19, further defined the direction of rectification, enhancing the pertinence and effectiveness of democratic life. Good for this meeting, we requested the Standing Committee of the municipal party Committee, municipal Secretary General Tang Wenjin, the City Commission for discipline inspection Standing Committee Yng Xu, Jiang Jixue, Deputy Director of the personnel office, and other leading comrades present guidance allows us to warm applause for their welcome and thanks! Below, I first District Committee member of the 20XX team annual democratic meeting implementation of the corrective measures, as well as member of the team and of my own report guidelines for the implementation of the independent Commission against corruption statement invited leaders and comrades criticism. First, annual party on the 20XX team, Member of democratic life action plan implementation year 20XX, district democratic meeting a member of the team on \and practice the scientific Outlook on development\oject supporting strong enough, the industry well enough, urban construction management level needs to be improved, livelihood improvement needs to be strengthened, district team itself, such as the five aspects. ear of 20XX, we find out the problems mentioned above, based on actual Shunqing construction and development, conscientiously sum up improvements, achieving significant development results and effectiveness of their work. (A) highlight the project handle, maintain high growth of investment. Adhere to the strategy as a Foundation, carrying out projects to promote increased stamina important. One is to increase the intensity of projects towards. Actively seek national and provincial policy support, superior special transfer payments, a variety of additional income will top 700 million Yuan, a number of key infrastructure projects, livelihood projects, industrial projects into the cage. Second, increasing the project attracts. This year a total of 23 signed a major project, of which 14 billion project, China Metallurgical group, vanke group, Guangdong hengda group, Taiwan Ruentex group, on the RI group, Shenzhen Kaisa, jifeng agricultural machinery, Mercedes-Benz, Audi 4S store and other large enterprises and projects have settled in Shunqing. Third, strengthen project construction. Annual implementation focus project 39 a, fixed assets investment total will breakthrough 12 billion yuan, created district yilai history high, South door dam, and five in shop old city transformation, and Ying China industrial concentrated district construction, and city main road construction, and Northeast steam Trade Center, and modern farmers industry Park, and vocational education city, and low rental, and also room construction, and features blocks build, and farmers market transformation, and \on\engineering speed up implementation, effectiveness obviously. Expected to be achieved this year, area-wide GDP 17 billion