Mac Forum / Applications / Excel / July 2006

I have lost my formatting toolbar and do not want to pay Microsoft $35
to tell me how to reinstall it.
What do I do?

I am using Excel 2004 with OS X 10.4.7 on a Powerbook G4.
I noticed some unexpectedly small and large standard deviations coming
from a pivot table. I calculated these standard deviations with the
STDEV function and compared this with the pivot table. They are

This query is as much about mathematical method as it is Excel.
A day-to-day task is to review sales data against expected values. So,
let's say I have 2 columns i.e.
Sold Price    Expected Value

Arrghh!
This happened after a re install before and I cant remember how it was
fixed.
OSX 10.3.9 Excel vX

I am trying to conditionally format a range of cells - simply filling them
in grey if they are empty. However, they contain the following:
=If(A1>0,A1/B1,"")
What condition can I use to fill this cell if indeed it contains "" ?

Today I was trying to do something - I had a range which contained some
cells containing the text string 'Manufacturer:'  (my inverted commas)
and wanted to format only those cells.
Now, I couldn't autofilter, advanced filter or sort because of the sheet

I am trying to have a cell calculate the time elapsed between visits by
a patient for post-op surgical visits.  Using the DATEDIF function is
easy enough, but I would like the output to be clear about what this
is. Ideally, it would display X days if < 7 days since surgery, X weeks

Am pretty new to this macro stuff and have no VBA knowledge. I have
created a macro that will run from one file dedicated to a set of
macros to pull out some data from a master file, run an autofilter,
create a new workbook and then paste the new data into the new

I had a column with mostly blanks except for the word 'yes' (no quotes)
In this instance I sorted, first ascending then descending but all the 'yes'
cells stayed at the top of the column after the first sort and wouldn't change.
Why?   and How to fix it.

I use spreadsheets to provide product descriptions, etc for clients. To
create a spreadsheet that is easy on the eyes, I would like to leave
one blank line of space at the top of each cell and another blank line
of space at the bottom of each cell.

Some of my users are having issues printing from excel 2004.  When they
choose print and tell it to print the entire workbook, only some of the
pages print.  Usually the first page doesn't get printed and sometimes
the last page doesn't either.  One thing I did notice is when excel

I'm creating a template that will be opened by users and saved to a new
name based on info provided by the user. I have macros triggered by
opening and closing the workbook. The before closing sub does some data
transfer between workseets. I'm running into a problem with the open

Friends,
I am using the lateste version of Excel in my iBook (vateste version of
Tigar), and in a simple worksheet, with few data and just one graph,
the file size easely reches more than 8Mb!

I'm having a recurring problem with a couple of the Names that I'm trying to
define.  
I have an excel Workbook that contains several different worksheets.  I'm
trying to create a hyperlink from a cell on one worksheet to a cell on

I just sent another post titled " Problem with Insert "Name-Define" and
remembered that I had another question related to hyperlinks.  I think that
I know the answer to this, but I could very easily be wrong.
When I hit the hyperlink to take me to the other worksheet, I would REALLY