jump to navigation

Sorting in Word’s Table of Authorities January 26, 2012

Posted by computertrainer in Office 2003 Tips, Office 2007 Tips, Office 2010 Tips, Word Tips.
Tags: , , , ,
add a comment

A Table of Authorities always enters the items in each category alphabetically.  However, there are time that a chronological order is required.  

This can be accomplished manually after you convert the TOA field to text :

  1. Select the TOA fields
  2. Convert them to text  using Ctrl+Shift+F9
  3. Cut and paste the individual items in the TOA to the order desired

If the TOA must be updated, first remove the old TOA, then you can recreate it using the Insert Table of Authorities icon.  Lastly, repeat the above to change the sort order.

Adjust the Header/Footer Margins in Word January 25, 2012

Posted by computertrainer in Office 2007 Tips, Office 2010 Tips, Word Tips.
Tags: , ,
add a comment

These instructions are for Word 2007 or 2010 but can also be performed in earlier versions.

You can easily adjust the page margins in a Word document by click on the Page Layout tab and then click Margins in the Page Setup group.

What if you need to adjust the margins for the Header and or Footer of the document?

  1.  Click the Page Layout tab
  2. Click the marker to the right of Page Setup
     
  3. Click on the Layout tab of the resulting dialog box
  4. Adjust the header and/or footer distance From edge (that would be the distance from the top/bottom edge of the paper)
  5.  Click OK

Display Styles that are used in a Word Document January 25, 2012

Posted by computertrainer in Office 2007 Tips, Office 2010 Tips, Word Tips.
Tags: , ,
add a comment

Do you need an easy way to see which Styles are in use in your Word documents?

These instructions apply to Word 2007 and Word 2010:

  1. Click on the Office Button (2007)/File tab (2010)
  2. Click on Word Options (2007 – lower right of menu)/Options (2010 – bottom of list on left side of window)
  3. Click Advanced on the left side of the dialog box
  4. Scroll to the Display section 
  5. Change the 0” in the Style area pane width in Draft and Outline views: to 1”
  6. Click OK
  7. Change the Draft view

The styles that are being used will show in the 1” area on the left of the sheets.

Outlook 2010: Suggested Changes to Outlook’s Default Settings January 11, 2012

Posted by computertrainer in Office 2010 Tips, Outlook Tips.
Tags: , , ,
add a comment

Applies to Outlook 2010 (This post is an update from one for Outlook 2003 & 2007 – the only changes are where to find the options.  I hope it helps you.)

When Outlook is installed there are several defaults that I suggest that you change:

1.       When starting Outlook, do not start in the Inbox, start in Outlook Today

  • First, you will need to get to Outlook Today so you can customize its components. 
  • If you have Exchange, then you have “Mailbox – your name” at the top of the folder list in the mail group on the left of the screen.   Click “Mailbox – your name” and Outlook Today appears.
    If you do not have Exchange, then you have your e-mail address at the top of the list.  Click that and Outlook Today appears.
  • On the right side of the Outlook Today bar, click Customize Outlook Today.
  • The first items is a check box – put the check in the box:  When starting, go directly to Outlook Today
  • Show this number of days in my calendar   I suggest changing the default from 5 to “7″ … on Wednesday you would get a quick view of the appointments you have at the first of the week.
  • In my task list show me All Tasks (this is the default … do not change it to Today’s Tasks)
  • Sort by Importance (Descending) then by Due Date (Ascending).  The most important tasks will appear at the top of the list with the most current Due at the top and those Due in the future below.
  • Click Save Changes – the upper right on the Customize Outlook Today bar.

2.       Save replies with the original message   Click on the Files tab, then Options, then Mail.  Scroll down on the right to the Save messages section.  If you have rules that move mail to specific folders when the mail arrived, then you will want to check the box  When replying to a message that is not in the Inbox, save replies in the same folder.  Using this feature means that the mail in the folder will have the incoming mail and your replies to that e-mail.  Click OK

3.       File Contacts by Company the Last and First Name   Click on the Files tab, then Options, then Contacts.  Int the Names and filing section change the Default “File As” order: from Last name, first name  Company (Last, First).  Then click OK.

4.       Change the default font for messages and replies   Are you frequently changing the font of a new message?  Instead of changing each message, let’s change the default font for new messages and for replies/forwards:

  • Click on the Files tab, then Options, then Mail.  On the right side in the Compose messages section click on Stationery and Fonts … .
  • Do nothing at the Theme… no ivy, no dark background color … just leave it a plain old white sheet.
  • Select the font you want for New Messages, then for Replying or Forwarding.  You can also change the font for composing and reading plain text messages … it does not have to be Courier New if your prefer Arial!
  • When you are satisfied with your selections, click OK twice.

5.       Add a signature for inside the company and one for outside   Click on the Files tab, then Options, then Mail.  On the right side in the Compose messages section click on the Signatures … and add the following signatures (at a minimum):

  • signature for a new e-mail going outside your company (more formal with more information)
  • signature for a new e-mail going inside your company
  • signature for replies and forwards

6.       Spell check every message automatically when you send it   Click on the Files tab, then Options, then Mail.  On the right side in the Compose messages section by the “spell check” icon click Always check spelling before sending. 

  • Then click on Spelling and Autocorrect…
  • I suggest you remove the check in Ignore words in UPPERCASE and Ignore words that contain numbers.
  • Click OK twice.

7.       Empty you “trash” at the end of the day   Click on the Files tab, then Options, then Advanced.  In the Outlook start and exit section click to add a check mark in Empty the Deleted Items folder when exiting Outlook.  The Deleted Items folder should not be a HOLD folder.  You can create a folder to HOLD things in and then when you delete an item, you mean for it to be deleted.

  • If you are on Exchange Server, you can undelete something once you delete the Deleted Items.  Instructions are on my blog: http://computertrainer.wordpress.com/2009/06/11/recover-deleted-items-after-emptying-outlooks-deleted-items-folder/.

8.       Using Reading Pane?  Keep envelopes from opening without reading the message   Click on the Files tab, then Options, then Advanced.  In the Outlook panes section, click Reading Pane…

  • Notice that the default is to Mark item as read with selection changes.  This means that when you leave one e-mail message and simply click on another – perhaps to view it in the reading pane – then the last message is marked as having been opened and read (the closed envelope icon changes to an opened envelope).
  • Remove the check mark in this item.

9.       Use Archive so YOU know when you store the archive files!   Click on the Files tab, then Options, then Advanced.  In the AutoArchive section, click AutoArchive Settings… and remove the check mark in Run AutoArchive every xx days.

  • Using the Manual Archive, you are in control of what you are archiving and where you are archiving the files.  Contact me if you need help.  I will send instructions or talk you through it.

It does not matter if you are new to Outlook or have been using it for a while, these changes will make Outlook easier to work with!

Add New Data to an Excel Chart – THE EASIEST WAY December 10, 2011

Posted by computertrainer in Excel Tips, Office 2007 Tips, Office 2010 Tips.
Tags: , ,
add a comment

Before you create a chart that will be based on data that will continue to increase, you need to do the following:

  1. Excel 2007/2010 – Format the data as a Table:  Home Ribbon, Styles group, Format as Table
  2. Now create your chart  – REMINDER:  F11 will create the default chart on a sheet of its own.

As you add to the data, i.e., new columns or new rows of data, the Table will grow to incorporate the new data and the chart will automatically include that data.

Now, this was easy … the easiest!

Add New Data to an Excel Chart – THE EASY WAY December 10, 2011

Posted by computertrainer in Excel Tips, Office 2003 Tips, Office 2007 Tips, Office 2010 Tips.
Tags:
add a comment

Problem:  You created a chart in Excel and now you have added more data to the source, i.e., the chart was based on 3 months of figures and now you have added a 4th month.

How can you get the chart to show the new information?

Solution:

  1. Select the new data, including the title
  2. Copy the selection
  3. Go to the chart (make certain that the chart is selected)
  4. Paste using CTRL + v

That’s all there is to it!

Delete Named Ranges in Excel 2007 / 2010 August 22, 2011

Posted by computertrainer in Excel Tips, Office 2007 Tips, Office 2010 Tips.
Tags: , , ,
add a comment

If you have created a number of range names in an Excel 2007 worksheet, you might decide that some names are no longer useful.

To delete named ranges Excel 2007/2010:

  1. On the Formulas Ribbon, click Name Manager in the Defined Names group.  The Name Manager dialog box appears (pictured at the bottom of this post).
  2. Click an existing range name and then click the Delete button.  A confirmation message appears, making sure you want to delete the range name.
  3. Click OK to confirmation that the range will be deleted.  Cancel cancels the deletion.
  4. Click the Closebutton to close the Name Manager dialog box.

    Name Manager Dialog Box

 

Follow

Get every new post delivered to your Inbox.

Join 116 other followers