Mac Forum / Applications / Excel / December 2007

I would like to create a chart with three items: date, time, and
average hr. The problem I am having is getting the time and av hr on
the same graph because of the large difference in numbers (time is
around 15min and av hr is about 160. How can I get the date on the x

I use a form written in MS XL that has a cell with a date formula of
=TODAY().  Every time I open this blank form (I have one for each
customer with that customers billing information on it) to enter a new
order for that customer, the date is automatically entered.  Very

In win Excel, when creating a vlookup formula, I could hit F3 and a
list of defined names would appear so that I could select the right
one for the table_array.  What's the equivalent in Mac Excel?
Thanks.

I have a heck of a time sorting, when there are swathes of space in my
workbooks. (I mean intermittent rows with nothing there)
For example I often want to sort by e mail so I can delete anyone without an
e mail.

Is there a way to imbed a small database with, say, 50 listed words,
that can be used as passwords... and then saved within the document
(encrypted), and then have a timer that accesses the list, say, once
each week, as a new password?

OK Molly - I'm suspecting either of 2 things as I have no problem of the
sort here - PDFs or other hyperlinks open fine in Acrobat 8.1.1 or Preview.
First thought: Are you *typing* the path ( HD/Documents/Tape Log
Info/GIGs/07-15-94 cl gig.pdf) as you stated it in your message? If ...

Whenever I unclick the shading box for excel charts (by selecting the
color in the legend)  and save it, close the document, close Excel and
come back to it later, all the formatting has gone back to the
original (shading). How do I  get rid of the shaded bars in the charts

I've created a spreadsheet that I want to show to others to test it
out and troubleshoot it, but I don't want these users to be able to
actually print  the sheets.  Is there a way to do this?  Can I create
a macro that runs when the documents opens, then selects the Print