When I select my row, copy, special paste, and transpose a message that reads:
The information cannot be pasted because the Copy area and the paste area
are not the same size and shape. Try one of the following:
Click a single cell, and then paste

I'm creating a spreadsheet for some coworkers of mine, some of whom may
not be very familiar with Excel but would need to update the file. I
want to include general notes/tips within the spreadsheet, mostly to do
with editing (for instance, how to wrap text, how to insert line ...

I want to create a master workbook with data entered for multiple divisions
and create a summary page that will auto update when the master is updated.  
I have tried a simple =, but it will only bring 1 cell at a time.  When I
drag from the right corner it just repeats that first ...

I have a customer who manually maintains a catalog of products in an Excel
file, one item per row, with a picture of the item embedded into the first
cell on each row.  They want to webify this catalog, so I need to pull out
the images.  Is there a utility or method (using VBA, ...

I insert a formula into my spreadsheet and i end up with the above
message. However my formula does not divide by zero. Any ideas?
Chris

I have read through the explantion of SUMPRODUCT here........
http://www.xldynamic.com/source/xld.SUMPRODUCT.html
I can understand the reasoning behind the tables 3 4 5 and 6......but when
it comes to actually using SUMPRODUCT for conditional calculations I just

Ok, I have a simple excel spreadsheet, where I keep track of my
spending on one tab, my income in another and my summary in a thrid.
My problem happens when I try to dynamically calc. avg's for months in
the summary page.  For instance, if I want to see how much money I

I'm trying to create a spreadsheet that A) enters the number of projects
worked on per day for several different kinds of projects, B) multiplies
that number by a point value which differs for each different project,
and C) sums the resulting values for the day.  The goal is to be ...

Hi all. I have an issue where i have several lines on a spreadsheet
where i want to consolidate it onto one line.
Sounds simple i know, please see the attached file as it explains my
situation far more clearly. (example.jpg).

I am running Win2000 with Excel 2000. I would like to be able to have a
macro button that takes me to a specific cell base on a certain criteria.
Example
If I type the number 1 in cell A1 the macro button (when pressed) would take

Every  month I have to change the sales amount in my worksheet.  I would
like this amount to be added automatically to the total for the year sales
amount in the next cell.  Is this possible?

Looking for a way to have a master worksheet that has approximately 10
colums by 400 rows.  We constantly add rows to the sheet and then need to
view it sorted in various ways.  Is there a way to have the data from the
master sheet displayed on other tabs in various sorts without ...

I'm sure this question has been asked a million times...
What are the "file size" limits for different versions of Excel?
In particular I'm interested in what it is for 2000.
Thanks

Is there a way to take the results of a formula and simply paste the
result as a numeric value in a new spreadsheet? I have pricing that is
the result of a formula, but need to start a new spreadsheet with new
pricing that is calculated from the previous pricing. HELP!

Dear,
in my office i m using office xp. Problem is that i want to insert a xl file
in another xl file. but it is not working.
At my home computer i have office 2003 and it is working. I m unable to