TIP #1:  SHORTCUT TO QUICKLY SHOW THE CONTEXTUAL TAB RIBBONS

If you want to quickly show the 'contextual tab' ribbons to select options after inserting clipart, tables, pictures, etc, simply doubleclick on the object or the border of the object.  This saves you from clicking to select the object, then clicking the Contextual tab that appears above the ribbon.

TIP #2 - TURN ON THE DATA FORM FEATURE

You will not find the FORM feature on the new Ribbon, in Excel 2007.  You need to add the command to use the FORM feature to the Quick Access toolbar.

• From the Microsoft OFFICE button, select (Excel Options)
• In the Excel Options window, select Customize
• From the dropdown in 'Choose Commands From' area at the top of window, select ALL Commands
• From the list, select/highlight FORM
• Click ADD, then click [OK]
• This will ADD the Form command to the Quick Access Toolbar above the ribbon Toolbar

[To use the Form command, from the Quick Access toolbar, click the FORM button. The form appears on the screen as it did in previous versions of Excel]

TIP #3 - ADD TEXT TO ANY SHAPE

When you draw shapes, you can add text within the shape(s) by doing the following:

• To insert your shape, from the Insert tab, select Shapes, then select the desired shape - using the mouse crosshair, draw it on the screen.
• When you have your shaped created, simply begin to type the text
                                                   OR
          <you can right click on the shape and then select Edit Text>
• Type the text that you would like to add to the shape, then click anywhere outside the shape

TIP #4 - Shortcut to Insert a New Worksheet

You can quickly insert a new worksheet in Excel 2007 – simply touch SHIFT/F11 and a new sheet tab will appear.  You can then drag the new sheet tab to a different tab location within your worksheet.     (Tip:  CTRL/drag will ‘copy’ the sheet)

TIP #5 - Search and Replace Cells Formatted with a Specific Color

You can use Excel's 'find and replace' feature to find formatting (such as color) within cells and replace the formatting with something else. Here's how:

• From the Home tab, select Find & Select, then select Replace (or to bring up the Find and Replace dialog box quickly, you can touch CTRL/f and click Replace tab).   The dialog box appears.

Note:  The ‘Find What’ area and the ‘Replace With’ area should be left blank.  

• On the ‘Find What’ line, select Format.   (Note:  If you don’t see Format, select Options to view the Format button)  

The Find Format dialog box appears.

• Click the Fill tab (if finding/replacing color)
• Choose the color you want to find.     Click [OK] to close.
• On the ‘Replace With’ line, select Format.   

The Find Format dialog box appears.

• Click the Fill tab (if finding/replacing color)
• Choose the color you want to replace the original color with.     Click [OK] to close.
• If you want to replace ALL the cells, you can click Replace All.   
• It will automatically replace the original color in the cells with the new replacement color!

NOTE:  If you don’t want to replace ALL the cells formatting at once, you can click [Find All] instead and randomly replace cell formatting

Tip #1 - SHORTCUT TO QUICKLY SHOW THE CONTEXTUAL TAB RIBBONS.

Tip #2 - TURN ON THE DATA FORM FEATURE

Tip #3 - ADD TEXT TO ANY SHAPE
 

Tip #4 - SHORTCUT TO INSERT A NEW WORKSHEET

Tip #5 - SEARCH AND REPLACE CELLS FORMATTED WITH A SPECIFIC COLOR