As we all know, the max characters that Excel can store in a cell is
32,767.  As we all THINK we know (because Microsoft tells us so), the
max characters that Excel will display or print is 1024.  However, this
is just wrong.  I have a spreadsheet that includes cells with some very

I am creating and addin that when opened will copy itself into an
existing workbook.  From there the copied worksheet is supposed to pull
data from another worksheet and allow the user to manipulate it.  I
created the worksheet in the same workbook that it will be used in.

How can I sort a list of 200 numbers and print on 1 page. I can't find
anywhere how to make a table with 3 or 4 columns that will sort all at once
and that I can print on a 1/4 page.

I am using Excel 2000 with Windows XP.
I am having a problem. I am on Sheet 2 of my workbook.
I have SSN on a sheet named Employees in the same workbook.
I need to take the numbers on the Employees Sheet and transfer it to the

I have a spreadsheet that has customer info including email addresses.
Is there a way to make a email (Outlook) distribution list using the
email column or just be able to send emails to all the addresses listed
in that column?

I just cannot quite crack conditional counting.
My database spans A5:Z300.
Four columns, W, X, Y, Z have dates in some of the cells.  The others
are blank.

I wonder, if this is possible.
I have three diff formulas in three cells, like below.
B1: =formula 1
B2: =formula 2

Want to print report with alternating lines with gray background....  can this be done in excel??
EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com

Is it possible to select a rectangular range of cells and then generate
a copied range of cells that is a rotation of the first range, where
the columns are the rows, and vice versa?

When I open Excel I want it to display the last worksheet I worked on when I
previously closed it.  How do I do that?
Don

In column A i have numbers 1 to 50,  (i.e. A1 =1, A2=2 etc thes
represent product boxes) in column B I have a "random" list of product
(i.e. B1=Walnuts, B2 = oranges, b3 = walnuts).
I need a formula to be able to summarize (in a seperate cell) whic

I have a sheet, which contains a metrics score card and a chart based
on this metrics. this metrics is created on every modays of a month.
i have created a list which shows all dates for monday in the month. I
want to put the data related to all the mondays in one single sheet and

When I view my worksheet in the "Page Break Preview", I can see the Page
Number shown on the worksheet as watermark. Eventhough it doesn't print, it
is quite annoyance to be in the center of the screen.
Is there any way I can get rid of it ...?

What do I do to have a result appear automatically in F68 which is the
result of F67+C68+E68-D68. Currently I Copy and Paste on F67 & F68.

how to format cell that allow "zero leading" values.
i.e "abc/"general.  cell value = 012, but only appear abc/12 instead of
abc/012?