Double click the handle

F. David McRitchie:
Fill Handle

Microsoft Office Online:
Fill data in worksheet cells

If you don't see the Fill handle:
Click Options on the Tools menu and click the Edit tab.

(Use the Office button in the upper left corner in 2007)
Select or clear the Allow cell drag and drop check box.



See all Topics
excel

Labels: General, Shortcuts, Tutorials

Don't hide

• Stock quote from MSN MoneyCentral
  
  
• Company report from MSN MoneyCentral
  
  
• Recent news on MSN MoneyCentral
  
  
• Insert a refreshable stock price
  
  
• Remove the Smart Tag
  
  
• Smart Tag options (This brings up the Smart Tags tab on the AutoCorrect menu.)

Complete tasks quickly with Smart Tags




How to turn on smart tags.

Smart tag functionality is turned off by default. Before you can use smart tag functionality, you must turn on smart tag recognition. To do this, follow these steps, as appropriate for the version of Excel that you are running.

Microsoft Office Excel 2007

1. Click the Microsoft Office Button, and then click Excel Options.
   
   
2. Click Proofing.
   
   
3. Click AutoCorrect Options.
   
   
4. In the AutoCorrect dialog box, click the Smart Tags tab.
   
   
5. Click to select the Label data with smart tags check box.
   
   
6. In the Recognizers box, click to select the check boxes next to the specific smart tag recognizers that you want to turn on, and then click OK.
   
   
7. Click OK to close the Excel Options dialog box.

Microsoft Office Excel 2003 and earlier versions of Excel

1. On the Tools menu, click AutoCorrect Options.
   
   
2. In the AutoCorrect dialog box, click the Smart Tags tab.
   
   
3. Click to select the Label data with smart tags check box.
   
   
4. In the Recognizers box, click to select the check boxes next to the specific smart tag recognizers that you want to turn on, and then click OK.
   

Labels: General, Shortcuts, Tips

No cut, No Paste

1. Select the entire column or row you want to move
   The move will effect whatever is selected; cells, or columns, or rows
   
   
2. Move your mouse pointer to the edge of the selection until it changes from a normal pointer cross to an arrow (four headed arrow in 2007).
   (Put the pointer on the selected cells, not the Row or Column indicators.)
   
   
3. Hold down the shift key and click the left mouse button and drag the column/row to the new position.
   
   
4. Release the mouse button before releasing the shift key

Labels: Shortcuts, Tips

HEADING

From Microsoft

"After supporting Microsoft Excel for years, technical Support Professionals have found that some of the most powerful and useful features and functions in Microsoft Excel remain undiscovered by you, our users.

For example, you may create a new macro to perform a calculation when an existing formula or function can perform the task. Or, you may create a new macro to perform a task when you could use an existing feature that performs the task."

• Secret #1: Joining Text Together
  
  
• Secret #3: Excluding Duplicate Items in a List
  
  
• Secret #7: Using a Data Form
  
  
• Secret #11: Linking a Text Box to Data in a Cell
  
  
• Secret #12: Linking a Picture to a Cell Range
  
  
• Secret #17: Using OFFSET to Manipulate Data in Cells that are Inserted
  
  
• Secret #21: Using INDEX and MATCH to Look up Data
  
  
• Secret #25: Returning Every Nth Number
  
  
• Secret #29: Using One Keystroke to Create a new Chart or Worksheet
  
  
• Secret #30: Setting up Multiple Print Areas on the Same Worksheet

Labels: Shortcuts, Tips

Where'd they hide that thing?

Wondering where your favorite Word 2003 commands are located in the new Word 2007 interface? Or just want to explore the rich, new design with a little guidance?

... rest the mouse pointer over a Word 2003 menu or button to learn its new location in Word 2007. To see an animation of the location of the command or button in Word 2007, just click it.

Command reference guides for:

Word
Excel
PowerPoint

The versions above require an internet connection.
Below are the links to download the guides to your machine.

PowerPoint
Excel
Word



See all Topics
excel

Labels: 2007, Addins, Shortcuts, Tips

Ribbon add-in tutorial portal

" This add-in adds a Get Started tab to the Excel 2007 Ribbon. Commands on this tab give you easy access to free content on Office Online, such as training courses, video demos, and other Office Online content designed to help you learn Excel 2007 quickly.

An Office Online interactive command mapping tool, also available on the Get Started tab, shows you where to find Excel 2003 buttons and commands in Excel 2007. Office Online Community discussions are also available directly from Excel with this add-in."

Labels: 2007, Addins, Shortcuts, Tips