Hello,
I use MS Excel 2002 (10.6809.6804) SP3
and have some troubles:
when I use Search function (Ctrl + F) in WorkSheet, Excel could not find

I wondered if there was a way to replace a value generated by a formul
in a cell with a symbol or an image, or even to automatically change th
color of the value in the cell.
To give you a better idea:

I'm a assistant who needs help setting up a simple format to keeping up with
the rent paid from my tenants.  Please help.

i have a formating question.  i have cells with number choices i
them.
for example the cell looks like this.
100, 105, 123, 041, 514, 455

I was wondering if anyone knew of a way to create a custom format for
names.  I use an ODBC import to obtain full names of people, and it
comes in as such:  "last_name ; first_name".  I can't change that order
in ODBC, thus I wind up with one column having both names, seperated by

When using text to columns to split a date / time formatted field which is
generated bya  formula I have preciously had no problems.  All of a sudden
the data preview pain in the wizrd now shows the formula rather than the
result so I cannot split.  Please help!!

I have survey data and each sheet holds the scores from a certain week
for each of the 11 questions. I want to make 11 line charts that will
show the answers over time for each question. For instance, chart 1
would be question 1. A week would be the x value of each point and the

I have a sheet that has the same formatting and same (relative) formulas for
each cell in each column.  When I insert a new row, I would like for the
formatting and formulas (relative) to automatically carry over.  Is this
possible, if so, how?  Thanks.

Would like to get help on this :
I have a worksheet looks like this:
Group ID    qnty
567    5

is it possible to print certain columns only?  example:  columns
A,B,C,D,E... but when click print, i only want columns B,D, and E to be
visible on paper.  i know i can highlight the columns to be printed but
that is not what i want.  just click print and wam!  

I am interested in getting a macro that will find specific text in
column A of a spreadsheet and then highlight that row and the three
rows following, for every occurrence of the specific text so that these
rows can be copied into a new sheet.Just to be clear if the particular

is it possible to a row to be highlighted automatically when the curso
lands on that row?
example:
if my cursor lands on A1, i would like the whole row to be highlighted

i would like to put a name or a number in "A1" but i want it so that i
can not be changed.  even when i clear the contents of the sheet
--
just1creatio

how can i make that you should not be able to scroll down a sheet
--
shlomo
-----------------------------------------------------------------------

All,
I have a 1.3 meg spreadsheet file in excel (office XP suite).  I used
the password protection feature to keep others who share my PC from
being able to open the file at will.  Worked fine for a few weeks.