
Microsoft office 工具
envykok
这个作者很懒,什么都没留下…
展开
-
How to fix the header row in excel ?
<br />select the entire second row and Freeze panes. The first row will then stay fixed.<br /> <br />原创 2010-06-29 11:29:00 · 231 阅读 · 0 评论 -
用Excel和DOS命令批量修改文件名
用Excel和DOS命令批量修改文件名文章来源: 文章作者: 发布时间:2009-08-20http://school.zzit.com.cn/OfficeSoft/Excel/20090820/211808.html在你的Windows电脑上批量修改文件名是非常简单的。选择所有的文件,按F2,然后输入一下描述性的文本。Windows将会在每个文件名中加上一个唯一的序列数字。这是一个相当快捷的解决方案,但是并不是很灵活,因为你不能自定义修改的方式。例如,你如何将当前的日期加在文件名中?或者你想转载 2010-07-14 21:33:00 · 242 阅读 · 0 评论 -
word表格跨页的问题解决方法
<br /> <br />选择表格的第一行,打开表格属性<br /> <br /><br /> <br />note : issue resolution<br /> <br />当上面办法失效的时候,可能是因为:<br /> <br />选择了多行作为header, 所以可以:<br /> <br />1)全选表格->表格属性->unchecked 'repeat as header row at the top of each page'<br /> <br />2) 选择第一行->表格属性->chec原创 2010-05-31 12:26:00 · 1046 阅读 · 0 评论 -
Changing Single Pages to Portrait and Landscape in Word 2007.
<br />· First you’ll need to select the text on the page which lay-out you want to change<br />· Then go to the tab Page Layout <br />· Then select Margins<br />· And select Custom Margins<br /> <br /> <br /> <br /><br />原创 2010-05-31 18:05:00 · 220 阅读 · 0 评论 -
How to Autofit column Width in Excel in Excel 2007
<br />原创 2010-06-03 14:06:00 · 207 阅读 · 0 评论 -
how can you reverse the order of a set of column data in excel?
Solution 1:In the next column enter numbers 1 thru XXXXX (one per row), select both columns and sort descending by the second columnSolution 2:原创 2010-06-04 16:43:00 · 191 阅读 · 0 评论 -
Change Popup Email Notifications in Outlook
Change Popup Email Notifications in Outlook<br />http://computerservices.royalroads.ca/email-notifications-outlook<br /> <br /> <br />Doyou wish that pop up email notification would go away faster? Orperhaps you want it to linger longer so you can cli转载 2010-08-02 15:03:00 · 208 阅读 · 0 评论 -
Create a table of contents in word 2007
You create a table of contents by choosing the heading styles — forexample, Heading 1, Heading 2, and Heading 3 — that you want to includein the table of contents. Microsoft Office Word searches for headingsthat match the style that you chose, format转载 2010-08-16 17:40:00 · 666 阅读 · 0 评论 -
如何在excel里画双坐标
<br />1. 准备数据<br /> <br /><br /> <br />2. 选中数据,插入图表<br /> <br /><br /> <br /> <br />3. 选中两条线的其中一条(蓝色),右键单击属性<br /> <br /><br /><br /> <br /> <br />4. 在弹出窗口选中:次坐标<br /> <br /><br /> <br /> <br />5.完成<br /> <br /><br />原创 2010-09-12 21:56:00 · 1235 阅读 · 0 评论