M.S. Excel Quick Tips
How to Change default font in Excel
>>>Excel Options >>Popular >> Use this font >> OK.
How to Automatically correct Capitalization
>>>Excel Options >> Proofing >> Auto Correct Options >> OK.
How to Show Days for Dates
>>> =TEXT(A1,"dddd") for day, TEXT(A1,"mmmm") for Month,
A1 is the cell data.
How to round the sum totals
=SUM(ROUND(B2:B6)) > CTRL + SHIFT + ENTER
Look at formula bar for the result
No comments:
Post a Comment