Mac Forum / Applications / Excel / August 2007

How can we add or change the colors on the Fill Color pallet.

I have worked with Excel (97 through 2007) for years but brand new to the
Mac OSX and Excel 2004.
I was given a spreadsheet that has cells that will not wrap. There is TONS
of data though. This is a small example....One Cell has 174 Words and 1481

I have a problem printing several files from a directory in windows explorer.
In one directory I have nine excel files and want to print them all.
I mark them all and right-click, then press print.
Only three of the files are sent to my printer.

Can you set a password for the end user to safeguard opening an excel
file from several others users?
I know you can set a password for an excel file to OPEN or MODIFY, but
does the security hold the same when the user (via email or a company

I am using Excel 2000.
I have created an input worksheet that contains information on about 70
people.
I have created another worksheet that will print out the information in a nice

I have the following problem:
I have 2 columns, 1 containing a start date and 1 containing an end date.
The dates, both start and end, can be either in September or in October.
What I need is 2 more columns, 1 with the number of days between start and

I am trying to create a spreadsheet where I enter a letter value, in this
case grades (A, A-, B+, B, etc) and have the next cell over (adjacent to the
right) automatically enter the corresponding numerical value (4, 3.7, 3.3,
3.0, etc). I know how to get the average in the final ...

I find the proposed color schema for coloring text and backgrounds
rather unpleasant. Is there any way to add new colors or change the
schema completely?
Thanks for any advice!

I need to consolidate and analyse a set of spreadsheets with identical
structure ( 1 set of 26 sheets with 378 data cells, 1 set of 26 sheets with
954 data cells)
1. For the totalling, I use the Consolidation function of Excel.  However,

is there any way to make a "real" multisort in Excel? That is, sorting
not only within the columns in an ascending order, but sorting the
columns themselves, so that at the end the highest values will be at
the upper-left corner of the table, and the lowest at the lower-right?

To whom it may concern.
I am a very profficient Excel user. I have only used PCs in my life. I
just bought a Mac and I am kind of frustrated with the following:
a) To lock a cell in a PC environment, a user could just hit F4. Here

I'm trying to merge data in Excel. I have 2 datasets with one common
variable. I've tried several different approaches, and none works.  Is
it possible to merge in Excel?  Or is the program not that
sophisticated? If I had SAS or SPSS it would be snap.

I want to fill out a row of info and have a series of buttons that
sends it to the bottom (or the first blank row) of Worksheet 1,
Worksheet 2 or Worksheet 3.
Where do I start?

In the Windows version of Excel, the active cell is easy to visualize,
since it is highlighted with a dark border. This does not seem to be
the case with the Mac version, and I'm finding it hard to identify the
active cell.  Is there a way to increase the border outline of the

How do I keep Excel from coming up as a startup item when I start the
computer?  I have tried the startup items routine and looked at other
options.  But I'm not doing something right.