Microsoft Office Tips, Tricks and Shortcuts for You

October 23, 2009

Help Wanted!

Filed under: File Operations — Tags: , , — msofficetipsforyou @ 9:23 pm

There are times that I need help to do something with a Microsoft Office application such as making a Table of Contents or an Index, but forgot how to do it. For those occasions, I need a little help from Microsoft Office, which gives me a couple of ways in Microsoft Office 2003:

  1. Help menu
  2. Ask a Question Box
  3. Office Assistant (animated paperclip known as ‘Clippy’)
  4. F1
  5. Help Toolbar ButtonHelp Button at the end of the Standard Toolbar

October 1, 2009

Quick Tip using ‘Save As’

Filed under: File Management — Tags: — msofficetipsforyou @ 6:00 am

I have many Microsoft Word and Excel files I’m working with at the same time, and often forget the folder I saved it to. To remind me where the file is, all I have to do is click File > Save As. The Save As dialog box opens to show the last place I saved an existing document.

September 27, 2009

The Difference between Microsoft Office 2003 vs. Microsoft Office 2007 files?

Filed under: File Management — Tags: , , — msofficetipsforyou @ 6:00 am

What is the difference between Microsoft Office 2003 vs. Microsoft Office 2007 files?

This article will give a brief explanation of Office 2003 vs. Office 2007 files.  The user interface differences will be discussed in another article.

Let’s use Word, Excel and PowerPoint as examples (sorry Outlook, OneNote, etc.)

Here are the following file extensions for Microsoft Office 2003 Word, Excel and PowerPoint:

  • Word document= .doc            Word templates = .dot
  • Excel workbook= .xls             Excel templates = .xlt
  • PowerPoint presentation = .ppt    PowerPoint template = .pot

Microsoft Office 2007 has the same extensions as Office 2003, with the addition of the letter ‘x’ to distinguish themselves as the Office 2007 XML documents.

  • Word document = .docx               Word templates = .dotx
  • Excel workbook = .xlsx                Excel templates = .xltx
  • PowerPoint presentation = .pptx  PowerPoint template = .potx

This means that Microsoft Office 2007 XML applications can read Office 2003 documents, but Microsoft Office 2003 cannot open or edit Office 2007 documents. It also means there may be problems when different users use the different Microsoft Office packages.

Example:

Computer A has Word 2007. Computer B has not been upgraded, and has Word 2003. Computer A sends B a copy of the Word 2007 document which will not be read by Computer B.

Computer B can send a copy of a Word 2003 file to Computer A which will be read by Computer A, but Computer A must make changes and be sure to send the document back as a Word 97-2003 document to be read by Computer B. The XML format of Microsoft Office 2007 files prevents Microsoft Office 2003 from reading those documents.

Be sure to pay close attention to the Microsoft Office version you are using. Many times I would save and send Office 2007 documents to people with the Microsoft Office 2003 applications who would complain that they could not open the document. Remember, both versions of Word use the term Word document as the file type, with different results if both users are not using the same versions, or same file types.

Hope this helped! See you in another lesson.

September 26, 2009

Understanding Microsoft Office 2003 / 2007

Filed under: File Operations — Tags: , — msofficetipsforyou @ 1:00 am

Microsoft Office 2003 Word and Excel have nine menus on the Menu Bar

  • File
  • Edit
  • View
  • Insert
  • Format
  • Tools
  • Table
  • Window
  • Help

Each menu contains commands to: open a file, save, print, cut, copy, spell check, etc.

There is no way that you will use all of the commands available in Word 2003.  You will probably use the File menu to Save and Print a document, or the Edit menu to cut, copy or parts of a document or worksheet, maybe once in a while, you may use headers and footers within a document.  But you may never use every command in Word or Excel.

The same thing applies to the Standard and Formatting Toolbar buttons.  You may use the Save toolbar button or the Copy, Cut or Paste toolbar buttons.  But you may not change the font colors or add columns to a document, but those features are there whenever you need them.

The point is, you may buy a computer that may have Microsoft Office 2007 Word and Excel.  The appearance is different, but is arranged according to surveys that said the most used commands such as Cut, Copy and Paste, are now grouped in a tab that is called Home.  You do not need to remember every command that is in Word or Excel 2007.  Just know how to get to the commands you use the most often.

There are seven tabs that contain several commands into groups.  These tabs are labeled:

  • Home
  • Insert
  • Page Layout
  • Formulas
  • Data
  • Review
  • View

Click through each one of these tabs and take a look at the command groups in each tab.  These are the tabs and commands you will use over and over, and you will remember more commands as you need to finish a Word or Excel 2007 document.

September 24, 2009

Dump Your Office Assistant

Filed under: File Operations — Tags: , — msofficetipsforyou @ 11:03 pm

One of the most annoying features of Microsoft Office 2003 is the Office Assistant icon and its character referred to as Clippy. It interferes with the work of a user by acting as a ‘pop up’, attempting to anticipate questions about punctuation, grammar, spelling, or other topics as you are working in the program.

When the time comes to get help in a Microsoft Office program, I have three, less annoying options available within Microsoft Office.

  1. Every Microsoft Office 2003 program has a Help menu that is the last menu on the Menu Bar. The first command in the Help menu is a Microsoft Office Help command. Click that link and the Microsoft Office Task Pane opens to allow you to search for help within Microsoft Office or on the Internet.
  2. There is also the ‘Type a question for help’ bar on the upper right corner of an application. Type your help request in that box, and press the Enter key to display help results.  Click Tools, click Customize.  Right-click the ‘Type a question for help’ box. Check or uncheck the Show Ask a Question Box.
  3. The last way to get help within Microsoft Office is to simply press the F1 key. The Help Task Pane appears, waiting for your question to be typed in the box.

Here are the steps to get rid of Clippy:

  • Click Tools, click Customize.
  • Right-click the ‘Type a question for help’ box in the upper-right corner of the program window
  • Check the Show Ask a Question Box to display the box
  • Uncheck the Show Ask a Question Box to remove the box

Hope this helps. See you in the next lesson.

September 21, 2009

Mouse Techniques

Filed under: Keyboard and Mouse — Tags: , , — msofficetipsforyou @ 2:02 pm

The mouse is one of the commonly used devices to enter information into a computer. As small as it is, with either 2 or 3 buttons, it can be a nightmare to use if it is the first time you have used it. This brief explanation of techniques and terms is not meant to replace actual hands-on lessons. It’s just another way to drive home specific points on how to use a mouse and the results of using the buttons of the mouse.

  1. Click
    tap (or press and release quickly)
  2. Example: tap your finger on: a desk/tabletop, top of the computer, keyboard edge

  3. Double-click
    2 quick taps.
  4. A click, waiting 1 second, and another click is not a double-click. It is two separate clicks.

    Example: Repeat the Click examples

  5. Right-click
    click the right mouse button to display a small context (shortcut) menu
  6. Example: Right-click anywhere in any document

  7. Cursor
    the blinking bar (vertical line) that displays the location of the insertion point
  8. Mouse Pointer is the display that shows the mouse location on the screen

  9. The Cursor and Mouse Pointer are not the same

September 16, 2009

Keyboard shortcuts for routine Microsoft Office 2003 and 2007 tasks

Filed under: File Operations — Tags: , , , , , , — msofficetipsforyou @ 9:09 am

At some point in your use of Microsoft Office applications, it may help to learn these few keyboard shortcuts instead of going through several layers of menus just to save, print, copy, etc. Here are a few of the common, not every, tasks with their keyboard shortcut equivalents:

Ctrl + O = Open
Ctrl + S = Save
Ctrl + X = Cut
Ctrl + C = Copy
Ctrl + X = Paste
Ctrl + P = Print
Alt + F4 = Close/Exit

September 13, 2009

Cut, Copy and Paste without the Microsoft Office 2003 Menu Bar / Edit menu

Filed under: Editing Microsoft Office files — Tags: , , — msofficetipsforyou @ 9:11 pm

Copying or moving text, numbers or objects with earlier desktop applications meant surrounding a block of information with cryptic codes, and the appearance of ‘on-screen’ menus. The problem with a novice user was remembering the correct edit screen to use, which frustrates the user to hand-write or use a typewriter to create a letter, memo or report. Now you have Microsoft Office programs that allow to you point and click drop-down menus for editing commands to move or copy text anywhere in a document.

As you become more skillful with Microsoft Office applications, you will discover other methods than the Edit menu for the cut, copy and paste operations. Two of these methods are the right-click shortcut menus and the drag and drop techniques that work with any Microsoft Office 2003 application.

Right-Click Shortcut Menus

As an example, select a Microsoft Word line, sentence or paragraph. Right-click on that selected block of text. A short menu appears with the Cut, Copy and Paste commands. Select either the Cut or Copy command. Go to another area within the document, right-click again, then select the Paste command.

Do the same thing with a Microsoft Excel spreadsheet. Select a cell, row or column of numbers. Right-click the border of the selected cells, and then choose the Cut or Copy command. Find another place in the spreadsheet, then right-click that target cell and click the Paste command.

Drag and Drop

Again, select a Microsoft Word line, sentence or paragraph. Hover the mouse over the selected text. Hold the mouse button down. While holding the mouse button down, move the selected text to another part of the document, then release the mouse button. Now you understand why this technique is called drag and drop.

Do the same thing with a Microsoft Excel spreadsheet. Select a cell, row or column of numbers. Move the mouse over the cell borders until the mouse pointer changes into a four-arrowhead pointer. Hold the mouse button down and move the mouse to another spot on the spreadsheet. Release the mouse button and the cells are placed on that spot in the spreadsheet.

Drag and drop also applies to copying blocks of cells. Instead of holding down the left mouse button, hold down the right mouse button. A short menu appears with the first two choices: Move Here, or Copy Here.

Hope this helps. See you in the next lesson.

September 8, 2009

Resize a program window

Filed under: Arranging Microsoft Office windows — Tags: , — msofficetipsforyou @ 10:37 pm

@Aleen “Do you turn off or shutdown a PC?” What is ‘word wrap’”? How do you ‘drag and drop’? Resize a program window.

Make sure a program window is not ‘Maximized’, because you cannot maximize a screen that is already maximized. To verify that a window is not maximized, hold the mouse pointer over the middle of the 3 buttons on the top-right corner of a window. A yellow rectangular message will appear that says ‘Restore Down’. Now, move the mouse to any one of the window borders: top or bottom, left or right side, or one of the corners (P.S.: stay away from the corner with the red-X. It is too easy to accidentally click that box by which will close the application, accident or not!). The mouse pointer will change to a double-arrow head pointer. Hold the mouse button down and move the mouse left or right, up or down. Release the mouse button when you get the window size you want.

September 7, 2009

Quick Access Toolbar Buttons

Filed under: Toolbars — Tags: — msofficetipsforyou @ 11:45 pm

Quick Access Toolbar default buttons:

  • Save, Undo, and Redo

Make life easier and add the following buttons:

  • Open, Print (not Quick Print), and Print Preview
Older Posts »

Blog at WordPress.com.