I have a pivot table that uses a calculated field in the data items section.
This is just a simple calculated field that divides one column by the other
from the data list.
The calculated field works fine, except that I need the data averaged and

How do I enter multi-line text (such as a 3 line address) in a cell without
having to use the space bar to move the cursor to the right of the cell so
that the next line will be below the previous line?

Hi all..
i have a question regarading graph.
i have my data plotted inside graph now, but the problem is
how can i adjust both x & y axis value 0 to set togther?

Could excel chart or worksheet be mail merge? Thanks

Everytime I bold a word, print preview, save the spreadsheet etc... the hour
glass appears and my network LAN Connection Status begins to transmitt and I
can see my network equipment flashing indicating it's passing data.  I can't
figure out what is going on, I tried a blank ...

I am downloading a CSV file into Excel from a web page that automatically
creates the CSV file.  Before my update to Office XP, the file would
automatically download into an Excel spreadsheet using the Actual Excel
program now it uses a Internet Explorer Window that looks like ...

If I click the last row and use "insert row" function, it will insert the row
before the last row.  If I click the first row below the table and use
"insert row" the row will insert below but not in the table.  If I just type
in the first row below the table, the row doesn't get ...

When I try to go to the beginning of the page using Ctrl+home it does not
work, it just takes me to the first cell of the row.

I am trying to set up an automatic re-order system where the re-order column
shows the re-order amount in Red only when the End Balance column is less
than the Minimum Stock column. How do I do that?

I've inherited a workbook with some 100 or so defiined names, each of them
tailored to refer to vertical single-column ranges in different sheets in the
workbook.  At some point I'll just recreate the whole thing to eliminate many
of the names, but for now I need to change the ...

is it possible??
e.g.
i have a list of times
01:05:28    round to 01:05:30

We have a excel file that charges out our services. Up to 4 people can use
this file and we are making changes weekly, adding new customers, changing
addresses etc. We would like to have an icon on our desktop that points to
the folder on our server this file resides and get the ...

I'd like to use the "go to" command where the cursor goes to the last row
with data.  When I use the "Special" command and select "last" it goes to the
last formatted cell, not the last cell with data in it.  
Can I go to the last cell with data entered in it without going to the ...

how can i make a cell unlimited.
so that i can enter upto 3000 characters into it.
for e.g so i can put in a long formula)
thank you, i hope someone can reply fast.

I'm trying to setup a spreadsheet so that when someone enters a date in the
first field, it exports the month and year to another field containing a path
to data from another spreadsheet.
For example, if the path is  C:/excel/09_2006/filename.xls, how can I set