How to Animate a Cell in Excel 2007

Written by sharon platz
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Animate a Cell in Excel 2007
Make images pop off your screen by animating in Excel. (atmosphericreflections in a discarded computer monitor image by Steve Johnson from Fotolia.com)

Microsoft Excel 2007 comes with a new feature that allows you to animate objects in cells within your workbook. This feature can be very useful to draw a reader's attention to specific data, or to simply jazz up your spreadsheets which, as we all know, can be very boring. Impress your boss or win that proposal by animating cells within your Microsoft Excel workbook to create a visually stunning masterpiece sure to get the right message across to your clients.

Skill level:
Moderately Challenging

Other People Are Reading

Things you need

  • Microsoft 3-D Animation Engine

Show MoreHide

Instructions

    Download and Install the 3-D Animation Engine

  1. 1

    Download the 3-D Animation Engine for Excel---you cannot animate your cells without it (see References).

  2. 2

    Select your correct Internet connection from the drop-down menu next to "Estimated Download Time:" and click the "Download" button in the upper left-hand corner of the Quick Details information box.

  3. 3

    Save the download file to your computer's desktop and double-click on the saved file to activate the installation.

  4. 4

    Install the 3-D Animation Engine, following the prompts provided by the installation wizard.

    Animate

  1. 1

    Open the Excel Binary Workbook that was downloaded when you installed the 3-D Animation Engine.

  2. 2

    Insert the object you wish to animate by clicking on the "Insert" tab from the Microsoft Office Fluent Ribbon on the Binary Workbook. Select "Illustrations," and click "Shapes."

  3. 3

    Pick your shape and click "Animate!"

  4. 4

    View the animation by placing a check in the "Step Run?" check box and clicking "Animate!" again.

  5. 5

    Change the shape's direction by clicking "Reverse" if you wish. You may also change other parameters of the object by using the Parameter Table in the upper left-hand corner of your worksheet.

  6. 6

    Click "Export to Light" once you are satisfied with the animation of your shape.

    Create Lighting Effects

  1. 1

    Open the Lights worksheet to apply lighting and shadow effects to your shape. Your object will automatically appear when you open the Lights worksheet.

  2. 2

    Click "Shed Light."

  3. 3

    Adjust the light's reflection on your object by using the sun controls on the left-hand side of the worksheet.

  4. 4

    Apply different textures to your object using the controls on the top of your worksheet.

  5. 5

    Colour your object with the colour controls, and click on the shadow controls at the bottom of your worksheet to create mysterious shadow effects.

  6. 6

    Click "Snap" and name your object when you are finished adjusting the lighting effects.

    Generate Visual Basic Code

  1. 1

    Open the Recorded Tracks worksheet and your newly-named object.

  2. 2

    Open your Visual Basic Editor by pressing on "Alt" and "F11" at the same time.

  3. 3

    Select the Microsoft Office Button in the upper left-hand corner of your screen and click on "Excel Options."

  4. 4

    Ensure that the "Show Developer tab in the Ribbon" button is selected from the Popular submenu and click "OK."

  5. 5

    Click on the "Developer" tab and select "Module2."

  6. 6

    Press "F5" to run the code after placing your cursor at the beginning of the Immediate window where the Visual Basic code is shown.

  7. 7

    Copy and paste your Visual Basic code results, after they have run, into the cell in your Excel spreadsheet to run your animated object.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.