Skip to main content

Posts

Showing posts with the label Microsoft Excel Tricks

Type Multiple Lines in a Cell in Excel

Excel users often face a common problem. Normally you can't type two or three words in a cell in Microsoft Excel. You have to merge cells to type something. But if you have no option to merge cell horizontally then you may fall in trouble. Believe it or not, last week I had the same problem while working in a worksheet!  Today I am sharing the solution with you. Look at the image below -  By default, you can't type like the image above in MS Excel. Have you noticed - I haven't merge the rows or colums. And there are 3 lines in Column A and 4 lines in Column B. Try to type multiple lines in a row or cell. Simply you can't. You have to use the Wrap Text option to type multiple lines in a cell.  For Excel 2003 Sorry to say, I don't have Microsoft Office 2003. So I can't show you the path. Probably you have to follow this way-  Format Menu > Font > Format Cells > Alignment > Text Control > Wrap Tex (Check the ...

Age Calculator by Microsoft Excel !!

Often you may need to calculate your age. Or someone may ask you to calculate his/ her date. And sometimes you may need to calculate the difference between two dates. There are many third party tools (small software) to calculate the difference between the two days.  If you're using Windows 7/ 8 then you don't need any other tool to calculate the difference between two dates. Because Windows 7 and 8 has a nice calculator. It allows you to calculate age or date difference.  To calculate a date using Windows 7/8 calculator-  Press Start + R > type calc > hit Enter .  Now go to the View menu and choose Date Calculation .  Now enter the From date and To date and hit on Calculate button.  Read More Here . . .  But my today's discussion is not this one. Today I'm gonna show you how to calculate the age or the difference between two dates using Microsoft Excel! You just need to downlo...