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包裝紙