Tips Ms. Excel

Excel, spreadsheets application made ​​by Microsoft is quite confusing for those who does not accustomed to use. But the little tips and tricks can help us use Excel, and it will be interesting..
Here it is some tips using excel :

• Insert Date and Time
  To insert the date in Cell, press [Ctrl] while pressing Colon / semicolon. Similarly, to add a time, press [Ctrl] + [Shift] while pressing Colon / semicolon
• Change the Tab Color
  We can change the color of the tabs in an Excel spreadsheet. Click the tab we want to change, then select the [Format] [Sheet] [Tab Color]. Specify color and click [OK]
  
• Hide the sheet
  We can hide an Excel worksheet to reduce the number of sheets on the screen. Highlight Sheet which will be hidden and select [Format] [Sheet] [Hide]. To show click [Unhide]
  
• Clear format
  To clear the formatting in an Excel spreadsheet, highlight the cells and select [Edit] [Clear] [Formats].
  
• Monitoring Cell
  Use the Watch window to monitor cells in other workbooks. To add the Cell to the Watch Window, right-click on the Cell and select [Add Watch]. You can adjust the position of Watch Window above or below the standard toolbar of Excel
  
• Add Quotes
  Excel can recognize stock symbols and fetch stock quotes using MSN MoneyCentral Investor. First, activate the Smart Tags by selecting [Tools] [AutoCorrect Options] [Smart Tags]. Be sure the "Label data with smart tags" is checked, and press [OK]. Open the Internet and enter the stock symbol into the Cell. A small green triangle will appear at the bottom right corner of the Cell. Hover your cursor over the cell, click the icon that appears and select "Insert refreshable stock price." Select "On a new sheet" to display the quote on another worksheet or "Starting at cell" to display the stock price at the current cell open.
  
• Change the cell at once
  To change the typeface or size of all cells in the spreadsheet at once, click the box in the upper left corner
  
• Sorting data
  we can rearrange the data in a spreadsheet by clicking the box in the upper left corner. Then select [Data] [Sort]. In the Sort window, select the column you want sorted from top to bottom or vice versa.