Mac Forum / Applications / Excel / April 2007

I'm looking for a way to use excel to take a lot of the headache out
of scheduling rehearsals for the theatre company I work for.
Basically, I have a list of variables that I would like to enter in,
and then let the computer sort it out for me- I'm not sure if Excel

Is it possible to generate Pivot Tables in HTML or XML?

Whenever I try to 'grab' a cell with the hand thingy to move it
somewhere else, it keeps jumping to the cell beside it. Sometimes I
can grab it on the very edge of the cell but this gets quite annoyin
when you're doing it over and over.

Ok, im not yet that used to Excel, however i want to create a
function, that corresponds with a cell that has a cummilative total.
So what i want is that if the total in this cell is less than 4000 i
get the result of 40, if it is more than 4000 but less than 20000 i

Hi folks,
I'm use Excel only occasionally for database purposes, but I find one of the
most time consuming, repetitive tasks I face is pasting the url path into an
images field.

I tried for first time web based forums with MCSE.
Did not work, got this:
you do not have permission to access this page. This could be due to one of
several reasons:

I have been emailing a .txt file to a number of contacts who use PC's. When
they open it they get the error message  (This file must be converted with
BinHex 4.0). To try to solve the problem I have saved the file as an Excel
workbook and emailed it again and had the same result.

I had a file with 800 rows, it now has 6000 blank rows. Is there easy way to
get rid of these? Thanks.
Also at bottom of file I see a tab at bottom says name of file copy.xls,
have no idea why this is there. I click on it and nothing happens.

I'm using a worksheet that has several tabs.  I need to pull select
information from all tabs into one Summary tab.  I've create the references I
need for the tabs I have now but there will be others.
Can I create a "template" tab so that it can be copied and renamed and the

I run a small research institute where we use Excel for the accounts
we present to our Board of Trustees. BUT - Excel shows negative
quantities with a minus sign, and apart from the fact that this sign
is usually too small to show up well, accounting practice in my

I want to enter dates (from 18th century to 21st century) as text, but
Excel insists on formatting dates after 19[04] as dates. Can anyone
help?

Most of the trouble I get into with Excel is when I paste.
So I want to start using paste special.
Only weird thing is it says paste, all, then 9 button (most of which I don't
know or understand)

I'm not sure if I have three related problems which are symptoms of
one problem, or three separate problems (see below). The first is the
most troublesome.
1. I have created an Excel workbook that involves complex macros and

When I resize an Excel worksheet, I notice that not all numbers/text
in the cells appear when I print. In print preview, everything looks
OK, but when I print, numbers or text are missing. Where should I look
to troubleshoot this? I use Office 2004 for Mac, Student/Teacher

I cannot seem to insert a row of blanks in the middle of a spread
sheet.  I am using Office 04 and it no longer support the "Option i"
But I cannot do as the Help suggests which is to click on a blank
space below where you want the inserted line to appear.