Mac Forum / Applications / Excel / October 2007

Years ago, I converted an old Excel 97 template (an invoice, I
believe) into a form for Purchase Orders. This was a 'pre-canned'
template that came with that version of Office. The template referred
to a text file to fill in the PO number. Each time I created a new PO,

If I click the little down-arrow to the right of the paint bucket icon (cell
fill color button), Excel immediately crashes and offers to send the
diagnostics file to Microsoft (which I have done many times).  That file says
that thread 0 crashed.  This used to work, but I haven't ...

I often work with a spreadsheet in which two of the columns are labelled
Start Date and End Date respectively.  The spreadsheet has about 3000 rows
of data and is replaced with a new spreadsheet every fortnight.
My problem is that when I try to sort the rows by one of these "date" ...

Here's something I never expected:
I have a spreadsheet which, for some reason in the past (before I got
it), had a number of "Names" applied to cells.  Each name refers to a
single cell.  That's fine.  The first problem I found: When I'm writing

In every Mac application I've ever used (and I've been using Macs since
1984), it has always been that, once you copy something to the Clipboard, it
stays there until you copy something else to replace it. You can paste it an
endless number of times regardless of whatever else ...

I have created a XL spreadsheet in excel on winxp where i copy in some text
data and the spreadsheet then extracts certain data from the text and I then
use a macro to Organise it.
It turn out I now have to use the spreadsheet on a mac. Spreadsheet opens and

Hi, this is more of a query than a problem. I want to create a list of
people and send them out an email as though sending it to them
personally. I don't want them to see a whole list of other recipients.
I'm not sure what this is called whether it is a type of mail merge or

I have a user who is running into a problem when pasting copied
selections from web pages.
The information is displayed on the web page in multiple columns
(actually formatted into tables with multiple rows and colums, not

I would like to add an up or down arrow symbol while typing in a cell.
I would like to be able to use the 'option key' to insert an arrow
symbol.
1.  I can add an up or down arrow symbol using 'add objects', but this

Is there a way to format how the pivot tables results on displayed?  My pivot
table will list invoices for a certain time period.  I'd like the results to
be sorted by invoice number.  I'd also love to format certain columns and
possible display a sum for a column.  Can that be ...

I’m trying to use the CONTATENATE formula to create a mailing address from a
database.  The problem I’m having is that I need to put the name on one line
and the address and a separate line within the same cell.  What is the best
way to accomplish this?  Can ALT ENTER be used in ...