Tuesday, 13 March 2012

photoshop photography

this pics are edited by me...

Sunday, 7 June 2009

Useful Excel tips

Using AutoCorrect for shorthand data entry:
You can use Microsoft Office’s AutoCorrect feature to create shortcuts for commonly used words or phrases. For example, if you work for a company named Chainsaw Duck Production Corporation, you can create an AutoCorrect entry for an abbreviation, such as cdp. Then, whenever you type cdp, MS office automatically changes it to Chainsaw Duck Production Corporation.

To set up your custom AutoCorrect entries in MS Office 2010,
  1. click on the "File" tab.
  2. click on Options
  3. click the Proofing tab.
  4. Then click the AutoCorrect Options button to display the AutoCorrect dialog box.
  5. In the dialog box, click the AutoCorrect tab, check the option labeled Replace Text As You Type, and then enter your custom entries. 
  6. Click add.
  7. Click ok

Exceptionally long text

If you type an exceptionally long text entry into a cell, the Formula bar may not show all the text. To display more of the text in the Formula bar, click the bottom of the Formula bar and drag down to increase the height.

What happens when you enter text that’s longer than its column’s current width? If the cells to the immediate right are blank, Excel displays the text in its entirety, appearing to spill the entry into adjacent cells. If an adjacent cell isn’t blank, Excel displays as much of the text as possible. (The full text is contained in the cell; it’s just not displayed.) If you need to display a long text string in a cell that’s adjacent to a nonblank cell, you can take one of several actions:

  • Edit your text to make it shorter.
  • Increase the width of the column.
  • Use a smaller font.
  • Wrap the text within the cell so that it occupies more than one line. Choose Home> Alignment Wrap Text to toggle wrapping on and off for the selected cell or range.