Mac Forum / Applications / Excel / November 2007

HI FOLK,
I'm a new user of MAC. I have a problem with LISTBOX. It seems to be limited
to a max 1024 elements.
If I'm right in a windows environment the listbox accept 32.000 elements.

I updated my Office software today with an Oct dated software upgrade.
I've using excel this afternoon, and I noticed the the correclation
coefficients for all fo my regressions are now negative?? I went back
to a speadsheet that I created yesterday and the r-squared were fine.

I would like to know whether it is possible to do something with the use of
a macro.
Could a macro be recorded (or written) that compares the data from a single
worksheet in one spreadsheet with the data in two worksheets on another

Is it possible to sort a list by font colour?
I am trying to find an easy way to synchronise the data between two
spreadsheets and am thinking that colour-coding the text in one of the
spreadsheets would make this process easier.

This is a minor thing , but annoying.
In Excel, when I open up worksheets, the bottom blue bar is always indented
a bit to the right, and I always have to drag it to the left to see the
first columns, anything I can do?

Hi all. I feel I am missing one step in my Data Merge process.
I have an Excel sheet which is going to be my source.
I made a new Word doc and put a blank table in.  I dragged and dropped
first name, last name, phone # etc. into the 2nd row of the table. I

I just switched to Mac and am going crazy trying to figure out how to
do the simplist stuff.  When I highlight a section and try to delete
it, it only deletes the cell that I started from.  I can't find
anything in the Help section.  Am I missing something here?

I have a worksheet with pictures inserted into the comments.  How is that
done and how can I extract the pictures from the comments and save them?

Does anyone know how to insert a line break within a cell on my mac?
The function Alt and Enter on windows inserts a line break, moving the
insertion point to a new line within the cell. This is not working on
my mac.  Thanks, Dionne