Office Tips and Hints Blog

Use your pdf converter to make your pdf files easy! You can now buy software that makes converting pdf to doc possible! Did you know you can even convert pdf to word?

Home Page

Bloglines

1906
CelebrateStadium
2006

OfficeZealot

Scobleizer

TechRepublic

AskWoody

SpyJournal

Host your Web site with PureHost!

Tuesday, December 06, 2005 – Permalink –

EXCEL

Dynamic AutoShape Link

Show the star

Here's a hint that I had forgotten about.

You can tie the result of a cell to an AutoShape.

This displays the value in a more dramatic manner.
Create an AutoShape on the Worksheet
With the shape selected, type an equal sign in the formula bar.
Enter the address of the linking cell (or click the cell)
Hit Enter

Thanks to AutomateExcel.com for the reminder.

See all Topics

<Doug Klippert@ 7:16 AM

Comments: Post a Comment

Links to this post:

<$BlogBacklinkTitle$>

<$BlogBacklinkSnippet$>
posted by <$BlogBacklinkAuthor$> @ <$BlogBacklinkDateTime$>

Create a Link