Pages

Tuesday, December 6, 2011

MONTHLY MICROSOFT OFFICE HINTS


 EXCEL
WORD
OUTLOOK
Easy way to get a spreadsheet to print on a single page.  It used to be quite an ordeal to get all the columns of a worksheet to print on a single page.  Although the location of print options might take some getting used to in Office 2007 and Office 2010, you can find them on the appropriately named tab, Page Layout.  In the Scale to Fit group, you will find three fields that can help you lay out your page.  To get all the columns on a page, select the 1 page option from the drop-down button next to the Width field.
Change multiple line spacing in Word 2007 and 2010, for good!  Some people aren’t comfortable with the 1.15 line spacing, which Microsoft instituted to improve readability.  To change line spacing, right-click on a paragraph formatted in the Normal style and choose Paragraph.  Change the line spacing field from Multiple to Single.  You may want to keep some spacing After in the Line Spacing section to delineate between paragraphs.  Now, instead of clicking OK, click Set as Default and confirm that you want this change for all documents created with the Normal.dotx template.
Click and drag.  One of the great features of Outlook is that any item can become another just by clicking and dragging it to a different navigation button (Calendar, Tasks, Notes).  When you make an email into a calendar appointment, it defaults to today’s date.  If you have your To Do Bar showing (Outlook 2007/2010), you can click and drag an email right on top of the date you want to schedule the meeting.  It will open a single appointment for that date.  You will need to adjust the start and end times.