I am trying to create a situation where a user selects one of three options
from a validated drop-down list ("Improving", "Constant", "Declining"). This
bit is easy :-)
What I want the cell to display is an arrow representing the value selected

In previous versions I was able to delete non-adjacent columns, but
this version seems not to allow it... When I choose non-adjacent
columns, the option for deleteing them is greyed out. I looked it up
in help, which wasn't very helpful, checked Excel preferences, just in

How I can search 0a-m1 in column B to return the highest value in column C
of all rows that are returned from the search of 0A-M1.
The result should be 74898.
sort could be done by A, B or Row number

I have a formula that returns a blank when a zero is in place
=IF(A15>0,VLOOKUP(A15,'New Labour Standards'!$B$6:$C$990,2,FALSE)," ")
I want this also to return blank when a text entry is in place.
Please could you help.

Many times I will sort data and the sort command automatically recognizes the header.
I have a new sheet that Sort does not recognize the header so it mixes the header in with the dataset.
How do I identify or mark row 1 as my header for a data table?
Thanks,

I am studing the three ways of importing data, I got to the second method and
it says something about installing Excel to Word converter, how do I do that?

I've finsihed my spreadsheet and I'm able to lock the cells I don't
want people to mess with.
How do I hide the formulas?
Also, my workbook has more than one sheet.  Can I hide formulas in one

I have some vlookup formulas on looking at cells with a 0. I am
getting a return of #n/a in the cells. I would like these to be blank.
How do I do this please?
Thanks

I have a long text file from which I want to extract blocks of data.
As a text import all the text starts in Column A.  There are about
1000 lines in each file.
I want to:

Combine 2 rows if name is same in Column B & C on both
2 spreadsheets - Sheet 1 is bigger with extra names in column B & C
Lastname Firstname
Both - Column B & C Lastname Firstname - both sheets

i need to calculate hours and minutes between eks.  "clock"  18:30 and 03:30
into hh:mm
it does not take into account that it's 9 hours not 14,5
excel 2003

If I write a multi-line text in a cell (then go down with alt+enter)
and after copy the cell pasting on Notepad, it display before inverted
commas and after textual content.
Instead, if I select directly the content from the formula bar, it

Is there a way to run a VB Macro with out using the security level. If I have
to disable the security how do I do that?

i feel crazy asking this question (knowing as much as i do)
but i have a formula that adds the values of cells which contains the
results of other formulas when data is inserted. ineed a working sum
regardless of the other cells having a result.

I have a list of numbers which are written with a space between each set of
numbers. Example: In cell A1 is: 12 13 14 15, in cell A2 is  23 16 17 00 and
so on.
Is there an easy way to delete all the spaces so the end result is 12131415