Welcome to欢迎光临 Office Tips办公室秘诀 and in this post we will learn about some of the features, tips and tricks of并在此后，我们将了解的一些特点，技巧和窍门的 Microsoft Office 2007微软Office 2007 Excel Sheets which we usually miss or don’t bother to use without even knowing how beneficial they can be. Excel的单，我们通常会错过或不打扰使用，甚至知道如何有利，他们可以。 Here are some useful points which definitely ads on to your excel skills.这里有一些实用的要点一定的广告到您的卓越技能。 Right from Choosing cell styles to grouping selected rows.从选择权细胞样式分组选定行。 Lets get started!!让我们开始！

#1 Wrapping Text quickly ＃ 1包装文字迅速

Writing long sentences in a cell just does not work with Excel.长句写作细胞中不只是工作与Excel 。 Possibly as it was not made for it.可能是因为它不是为它作出。 It either just over shadows the next cell or gets hidden by other.它要么刚刚超过阴影下一个单元格或得到其他隐藏的。 However we still need it from time to time.但是，我们仍然需要它不时。 The best option is to give a Wrap up to it so the cell expands in size and fits the text within it.最好的办法是给予总结，以便扩大细胞的大小和适合的文本内。 It avoids any confusion and keeps the thing clear.它避免任何混淆，并保持明确的事情。

• Select a text which has more text.选择一个文本已更多的文字。
• In the Home在主页 Ribbon丝带 , Find the Alignment section and look for icon which has 2 boxes. ，查找对齐节，并寻找图标有2个箱子。
• On hovering over it you will get a help tip for wrapping, just click it.在上空盘旋，你将获得帮助冰山的包装，只要按一下它。

Caution: Wrapping up text will make the size of the cell bigger and push underlying cells below.注意：总结全文将使大小的细胞更大，并推动以下的基本细胞。

#2 Using color bars to express value of numerical data ＃ 2用颜色表示，酒吧价值的数值数据

Text are boring if they cant express in different forms.文字是无聊，如果他们不能表达不同的形式。 We use charts and bar graphs to express our values why not use the same technique in individual cells.我们用图表和条形图表示，我们的价值观为什么不使用相同的技术在单个细胞。

Where you can use it ?如果您可以使用它？ Lets say for an example, You don’t want to use chart or putting a chart is not appropriate but still you want to give similar kind of effect like the one I gave in in the image .可以说，对于一个例子，你不想使用图表或将有一个图表，是不恰当的，但仍然要给予类似的效果就是这样我在的形象。 10 gets more colored area then 8 or 7. 10个获得了更多颜色的面积然后8或7 。 Pretty cool huh ?很酷吧？

• Select the cells选取细胞
• Now in Home , look for Styles现在在首页，寻找风格
• In that click on Conditional Formatting.在此点击格式化的条件。
• This gives you more options than above.这使您更多的选择比以上。 You can even add images, icon sets, color bars and much more.您甚至可以添加图像，图标集，色彩酒吧和更多的工作。

#3 Choosing cell styles to make things clear ＃ 3选择细胞样式搞清楚

Adding images express more right how about adding styles for things like comment, links, warning, links and other things!!!添加图像表示更多的权利如何添加风格类似的事情发表评论，链接，预警，链接和其他东西！ You might be thinking why make excel sheet more calculated and cluttered but let’s take a situation.您可能会想到，为什么让更多的优秀资产负债表计算和混乱，但我们来的情况。

You have an excel file where you have added lot of comments, there are lot of calculative columns and explanations.你有一个excel文件在您添加很多意见，有大量的计算列和解释。 Now If I had to analyze it without you being you being there, How much time I would take to find which is what ?现在如果让我来分析它没有你的你在那里，需要多少时间我要找到这是什么？ Probably a lot more if you were there or if something can tell me which is what Right!!!也许更多的如果你有或者如果东西可以告诉我这是什么权利！

A small example一个小例子

#4 Go to Redefined ＃ 4转到重新界定

Jumping from one part to another is difficult with so many elements in excel.跳跃从一个地方到另一个很难有这么多的优秀分子。 We just don’t want to move from one line to another but possibly from one comment to another.我们只是不想从一个到另一个线，但有可能从一个到另一个评论。

Excel has an Enhanced version of Go To. Excel中有一个增强版本的结局。

• Use the hot key CTRL + G or On Home , Click on last menu item, Find and Replace.使用热键按CTRL + G或在主页，点击菜单项上，查找和替换。 You will fine the Go To您将处以罚款转到
• This Go To gives use options to Comments, Constants, Formulas and more.这转到提供使用办法评论，常数，公式等。

#5 Tracing formulas and their source ＃ 5跟踪公式和其来源

Sometimes it becomes hard to find cells which are used to calculate the sum.有时它变得很难找到这些细胞用于计算的总和。 You know the cell where you calculate the output but if you find the source you need to click on it.你知道你手机的产量计算，但如果您发现源你需要点击它。

Now when its time to现在，当其时 presentations介绍 its really not a good idea to find by clicking on every cell and then finding where things are.它真的不是一个好主意找到按一下每一个细胞，然后找到事情的。 Excel gives you a quick button which highlights the cells used and with arrows pointing towards it.!!! Excel中为您提供了一种快速按钮，其中突出的细胞用于与箭头指向态度。 ！

• Go to Formula Tab on the ribbon转到一级方程式标签上剪彩
• Select Formula Editing which is second from last选择公式编辑这是从去年第二
• Look for Trace Precedents and Trace Dependents.寻找微量的先例和微量元素家属。
• Select any formula cell and click on this and It will point to correct cells.选取任何公式细胞，然后按一下就这个问题和它指向正确的细胞。

#6 Reveal all formulas in one click ＃ 6显示所有的公式，在一个点击

This is a quick tip, If you want to see all the formulas used any where in the excel .这是一个快速小费，如果你想看到所有的公式，任何地点使用中出类拔萃。

• Select the sheets first in case you have formulas in different sheets.选择第一张如果您有公式，在不同的工作表。
• Now go to Formula Section and Under Formula现在转到一级方程式科和下一级方程式 auditing审计
• Click on Show Formulas点击查看公式

That’s all , It will unscramble all the formulas exactly it was at the time of editing it.这一切，这将解读所有的公式，完全是当时的编辑。

#7 Watching Cell changes live ＃ 7看着活细胞的变化

Now lets take an example you are summing up some of the things and You need to know At Run how much is the value changed in summing up cells to when you increment or decrement values.现在可以采取的一个例子你是总结了一些事情，您需要知道在运行多少价值的变化总结细胞当您递增或递减的价值观。 If you are a programmer probably you know what is a Watch.如果你是一个程序员也许你知道什么是观察。

You can do it in very simple way.你可以做到这一点非常简单的方法。 Excel provides you with facility to watch the value of anything at run time but adding it to Watch Box. Excel中为您提供设施，观看价值的东西在运行时，但添加到手表盒。

• In the formula section under Formula auditing look for Watch Window公式中的下一级方程式节审计寻找观察窗
• Click on it and add watch by selecting individual or range of cells.按一下它并添加选择观看个人或单元格区域。

#8 Breaking Text into multiple cells ＃ 8打破文字分成多个细胞

Lets take a situation where you have long text in a cell which comprises of name ( both first and last ) and you want to split it into 2 columns.可以采取的情况下，只要你有文字在牢房其中包括名称（包括第一次和最后一次） ，并要分裂成2栏。 You can do it manually but that’s not feasible in case of huge data.您可以手动但是这并不可行的情况下巨大的数据。 Excel allows you to do through Text to Columns options it if you can tell it the separator. Excel中，您可以通过做文字专栏选项，如果你可以告诉它分隔。 easy容易的

• Go to Data Tab in the ribbon and look for Data Tools转到数据表中的剪彩，并寻找数据工具
• Select your cells and click on Text To Columns选择您的细胞，然后按一下文字专栏
• There are some steps where you need to tell the separator and others.也有一些步骤，您需要告诉分离器等。

#9 Grouping an Un-grouping rows : Stop Scrolling ＃ 9分组的取消分组行：停止滚动

In case you have huge amount of data and say you want to check on some data which is right at top of the sheet and another which is in middle.如果你有大量的数据和说你要检查的一些数据是正确的在顶部的资产负债表和另一个是在中间。 But you have lot of data in between which you have to scroll.但是，你有大量的数据，在这之间你必须滚动。

This is really a scenario where your valuable time is used up.这是真正的情况下您宝贵的时间用来了。 Now what if you can just select those not required cells and hide it in a click under a group and on other click you get them back.现在，如果你可以选择那些不需要细胞和隐藏在下点击一组和其他按一下您让他们回来。 This way you save the scrolling time and traverse fast.这样你保存的时间和滚动遍历快。 Moreover you get the advantage of grouping them in different sections too.此外你的优势，将它们在不同的部门太多。

• Go to Data Tab on Ribbon转到数据标签上丝带
• Check the last section named as Outline.检查的最后一节命名为大纲。

Have Your Say ?你说呢？

There are lot more which comes with experience and others.有更多的配备经验等。 If you use excel and you know some tips.如果您使用Excel和你知道的一些提示。 Do share with us all in comments.不要同我们分享所有的评论。

Don’t forget to check our Office tips on不要忘记检查我们的办公室秘诀

• 15 Tips to increase your productivity with Power Point 2007 15个窍门，以提高您的生产力， 2007年功率点
• Word 2007 : 15 Configuration tips before you start using it Word 2007中： 15配置的提示，然后再开始使用它

Tags:标签： conditional formatting条件格式 , ， excel 2007 tips Excel 2007中的提示 , ， microsoft office 2007微软Office 2007 , ， Office Tips办公室秘诀 , ， Ribbon丝带 , ， styles风格 , ， technique技术 , ， tips and tricks技巧和窍门 , ， Wrapping包装纸