Saturday, March 21, 2009

SHORT TIPS

Display numbers as fractions in Excel 2007
 
Sometimes, you may want to display numbers as fractions, instead of decimals. To do this, select the cells that contain or will contain these numbers. Go the Home tab and click the Dialog Box Launcher next to Number. In the Category list, click Fraction; and in the Type list, click the fraction format that you want to use.
 
Display numbers as percentages in Excel 2007
 
Select the cells in your worksheet where you want to enter percentages. Go the Home tab and click the Dialog Box Launcher next to Number. In the Category list, click Percentage; and in the Decimal Places box, click the number of decimal places you’d like to display.
 
Print a table in Excel 2007
 
If you want to print a single table within an Excel worksheet, click a cell within the table, click the Microsoft Office button, and click Print. Click Table under Print What.
 
Add people to the Safe Senders list in Outlook 2007
 
If e-mail from a trustworthy source has mistakenly been sent to the Junk E-Mail folder in Outlook 2007, you can prevent recurrence. Go to the Tools menu and click Options. Go the Preferences tab and click Junk E-Mail under E-Mail. Click the Safe Senders tab, click the check box against Automatically add people I e-mail to the Safe Senders list.
 
Display numbers as fractions in Excel 2007
 
Sometimes, you may want to display numbers as fractions, instead of decimals. To do this, select the cells that contain or will contain these numbers. Go the Home tab and click the Dialog Box Launcher next to Number. In the Category list, click Fraction; and in the Type list, click the fraction format that you want to use.
 
Display numbers as percentages in Excel 2007
 
Select the cells in your worksheet where you want to enter percentages. Go the Home tab and click the Dialog Box Launcher next to Number. In the Category list, click Percentage; and in the Decimal Places box, click the number of decimal places you’d like to display.
 
Print a table in Excel 2007
 
If you want to print a single table within an Excel worksheet, click a cell within the table, click the Microsoft Office button, and click Print. Click Table under Print What.
 
Add people to the Safe Senders list in Outlook 2007
 
If e-mail from a trustworthy source has mistakenly been sent to the Junk E-Mail folder in Outlook 2007, you can prevent recurrence. Go to the Tools menu and click Options. Go the Preferences tab and click Junk E-Mail under E-Mail. Click the Safe Senders tab, click the check box against Automatically add people I e-mail to the Safe Senders list.
 
Create desktop shortcuts to Office 2007 programs
 
You can do this for all Office programs, or only for those that you use frequently. Click Start, go to All Programs > Microsoft Office, and then right-click the name of the program that you’d like to create a shortcut for. In the menu that appears, go to Send To and click Desktop (Create shortcut).
 
Change the color scheme of Office 2007
 
You can move from the default blue to other colors for your Office programs. Click the Microsoft Office button and then Access Options. Click Popular and then the Color Scheme that you’d like to use.
 
Change the date format in Windows Vista
 
To change the format in which the date appears on your computer, click Start, then Control Panel, then, Clock, Language, and Region. Under Regional and Language Options, click Change the date, time, or number format. Go to the Formats tab, click Customize this format. Go to the Date tab, and make the necessary changes in Short Date and Long Date. 

No comments: