View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
OssieMac OssieMac is offline
external usenet poster
 
Posts: 2,510
Default how to add a legend in a footer?

Hi Kyla,

Open Footer and place cursor in required position (left, centre or right
footer.)
Select Font button and set font type to Wingdings. At same time set required
color for the symbol and close font dialog box.
Hold Alt key down and type 0110 on the keypad at right of keyboard.
(Displays solid rectangle)
Move cursor off the character and reset font to required character set for
normal characters and also re-set font to required color for normal
characters.

You can experiment on a worksheet to get your character of choice from the
wingdings symbols.

Select a Cell and set font to wingdings.

Select and insert the character of choice.

Assuming that your character is in cell A1
In an adjacent cell enter =CODE(A1).
This will give you the code to use with the Alt key.

--
Regards,

OssieMac


"kyla" wrote:

I have an excel spreedsheet with is showing a project plan timeline and I
would like to add a legend in the footer. I would like to have a red square
and beside that the definition, orange square-definition and
yellow-defintion......