I'm just trying to create a short pulldown list in a spreadsheet.  Instead
of having to retype repetitve selections for this spreadsheet that gets used
a lot, I'd like to create a pulldown list, but I'm not sure which kind of
list to choose and I'm not sure how to enter the list.

Is there a shortcut of any sort to convert a relative value to absolut
without having to individually edit the cell.
Many moons ago I used to be able to do it in Symphony with a functio
key, but have not been able to find if it is possible in Excel.

    Having a little difficulty here. Using Excel 2000/WinNT4.
    The macro below looks for a particular phrase on a worksheet,
when it finds it the second time, it selects that cell and the cell
below it.

How do I round numbers to millions e.g. £2,500,000 would
show £2.5m
Thanks for your help
Regards

I ran into a really bizarre problem today, and I'm wondering if anyone
else has experienced it.
I had a cell which was formatted as text (wrap text on). I filled it
up when typing, but there was still space left in the cell.

Hi All,
I have a spreadsheet that is full of info exported from a crm.  One of
my cells has characters indicating a carriage return.  The character
appears as two double bold bars in the row.  If I have the cell open,

I've searched the online help and elsewhere on the internet for
solution to my problem, but have had no luck so far.
I'm creating a report that is to be in one excel datasheet, then linke
across several powerpoint slides as one continuous table.

I am really, really new at this.
I am using Excel 97. I have a SAP application I use to export 2 column
of information to a table format in Excel. This information lands i
Columns A and B. Column A, rows 2 - 26 contains label information (e.g

Someone described to me a feature (add-on?) of Excel whereby a palette on
the desktop holds the arithmetic operators (+, -, *, /, etc).
This way, when you are doing formulas you can click on the operators on the
palette, instead of using the keyboard.

Good morning,
If anyone has any useful web links for information regarding protection/hide
information for 2000 & 2002 generally to broaden my knowledge that would be
great.

Good morning,
If anyone has any useful web links for information regarding protection/hide
information for 2000 & 2002 generally to broaden my knowledge that would be
great.

I am hoping that you may be able to help me.
I have been able to work out a formula that will count down the day
from when an employee attended his/ her biennial assessment.
How can I get excel to either print a report or alert me, say, xx day

I have ten random values (text) in Column A from A1 to A10. On column
B, there are 10 numbers (between 1 to 10) arranged in random squence,
so B1 may be 4, B2 may be 8 and so on. On column C, I want to get the
value of the cell indicated by the NUMBER, such that if B1 is 4, then

Hey guys-
You have all been soo wonderful about helping me out on the other issues- I
decided to throw this one at you...
I have searched newsgroups, this forum, etc, and see references to this, but

The cells with the expenses I want to exclude are formatted in
different color.  Is there any way to write a formula or macro so i
excludes based on the color of a cell?
Thanks