Sunday, February 8, 2015

Translate Selected Text In Excel!

If you are working on a worksheet for a client based in another country that they speaks another language like mine, you might have difficulty understanding what you are working with.

To translate this, you can utilize Excel’s Translate feature.

Select the cell with the text you wish to translate, click the Review tab and then click Translate.

tran-1

In the Research pane, select Translation to Language as I selected URDU , click again Translate in Review Tab.

tran-2
 
Your selected text translated in Research Pane Click on Insert drop down list Click Insert to insert translated word in selected cell or Click Copy to copy translated text in clipboard and then paste in your selected cell.
 
tran-3
 
 
Following image is my finally translated copied text.
 
tran-4

Awesome Translation Feature In Excel Try Yourself!

BE AWESOME IN EXCEL!!!

Wednesday, December 10, 2014

Quick Current Date and Time in Excel

Excel-Quick-Date-Time
  • To enter Current Date in a cell Press Ctrl+; (semicolon ) it will inserts Current Date in your current Cell.
  • To enter Current Time  in a cell Press Ctrl+Shift+: (colon ) it will inserts Current Time in your current Cell.
Know you know, how to insert Current Date and Time Microsoft Excel, next time when need to insert Current Date and Time in any cell of worksheet and format the cell for Date and Time as like try these Keyboard Shortcuts.

This works in almost all the Excel versions.

Enjoy Microsoft Excel.