When I create a drop down list for a cell the font is too small. How can I
increase the size so I can read it better?

Is there any way to convert a column of numbers that are positive to be
negative?  We create a text file from our general ledger program that has all
the transactions for the past year, then import that file into Excel.  We use
the text to columns to convert the text file to a ...

As I copy web page content then paste them directly to excel
worksheet, those url links will be copied automatically. I want to
remove them by simple step instead of going cell by cell to remove
them. Can I do that with excel commands ? So far I still couldn't find

Wondering if anyone can help with a slight anomaly that popped up in the
office the other day:
Every month we take a download from our stores system of all items that have
been overdue from contractors for one month or more and put it into a shared

I have MS office 2003 installed on my Drive C.  I would like to have it
installed on drive E with MS Office being the only thing on that drive.
The installation doesn't appear to give me the option of which drive to
install it.  Am I doing something wrong?

Is it possible to "pad" the text in a cell with added space before and/or
after the text?  I have Wrapping turned on.  With AutoFit, the top and
bottom cell edges come right up to the text; I'd like a little white space
between the text and the top and bottom edges, but without ...

Does anyone know how to stop the cell background color from printing. I use
cell background color to facilitate data entry in the sheet but I don't want
them to be printed in the hard copy. Thanks
Wally

Is there a way in VBA to scan a range of cells and pick up the references of
any cells that have a particular format applied? The range may have more
than one cell with the format applied and I want to be able to use the
references elsewhere in the workbook.

I am trying to multiple columns J x I if Column J = 0.135. I've used the
following but I'm getting a #Value! error - any ideas
Thanks
=SUMPRODUCT(--(J16:J28=0.135),(I16:I28,J16:J28))

I tried this...
Sub Button8_Click()
   Sheets("Sheet1").Select
       Range("C10").Select

How do you exchange all the columns and rows in an Excel spreadsheet?
The column labels are across the top of the spreadsheet, with the data
(vertically) below.
We want to change it so the column labels on the left, with the data

I have the strangest problem...  somehow, right clicking a cell doesn't
bring up a menu anymore.  It happens only when I'm in Excel only... it still
works even if I bring up macro editor within Excel... it only doesn't work
when I'm in Excel.  I've tried Options and Customize... ...

Ladies & Gentlemen,
A small problem which is either me being stupid or Excel.
I have borrowed some code from David McRichie's site which I have then
pasted into a Module in the VBA Editor window. When I click on the Run

If put "=MIN({0,2,-5})" in cell,
that result is "-5".
but put this take wrong.
=MIN(F4:H4-F3:H3) => =MIN({0,2,-5})

Is there anyway I can prevent pivot tables entering borders around cells?
Any help most appreciated