Any Iidea how to simply take rows (1st, last name, address, town, state, zip)
and convert them into individual labels for printing?  Maybe import to other
MS Office programs? thanks, al

Thanks.  I now have 40%-95% across the top and 100-520 down the side.  Now
does anyone know the formula for percentage.  I want to be able to see what
ex. 85% of 320.

How can I edit the conditional format so null (when the cell contains
nothing) values have no shading in my spreadsheet?
For example, I selected column E and applied conditional formating in order
to highlight all faculty hired before 1985, however, I have null values and

I'm looking for a way to prevent users from both adjusting pivot
filters or refreshing the pivot.  Does anyone know a way to lock these
features, but still alllow users to move/add/remove fields from the
table or select data within the fields?

I do not want to show my formula in formula bar.
can anybody help????

I need to install the solver add in , excel 2003. I do not have the disk.  
How do I download from Microsoft or??
Thanks,

Hi Allen,
Thanks for your initiative and solution :) Really appreciate everyone's
support and contribution ot the forum/community.
I'm back again with the qruery on the same topic/challenge for me :)

Question:
In cell A1 I have a name "John Smith".  How can I move "Smith" to cell A2 so
that I can sort by first or last name.
Thanks.

My excel's top rows are numbers now, how to set it back to letters?

I am using the trend function to trend utilization rate.   My known x's are
the utilization rate, and my know y's are the years.  I have data on an
annual basis for 2000-2015, and then it jumps to 5-yr increments for 2015 to
2030.  Can I just trend this out despite the increment ...

Hi! Hope someone can help,
I am trying to create a Pivot Table from a spreadsheet as below:
Employee  Training Title - 1    2    3   4   5   6  
Ben                                 Y                    Y

I have a spreadsheet with multiple worksheets.  
The worksheets relevant to my SUMPRODUCT problem are as follows:-
Daily Report 2006 - this holds all the core data
NW Customer Summary - this holds a weekly summary of issues occurring during

I have 2 columns of data.  The first column has rows with either "b", "bhs",
"g" or "ghs".   The second column has rows with age #'s (like 1, 2, 3, 5, 8,
etc).  I can't figure out how to count for example the number of "b"'s and
"bhs"'s that are a particular age (say 5).

Does Excel have a formula that will automatically return the value of
the next cell with data?  What I mean is I have a spreadsheet with a
row for each day of the month (1-31) and a few times a week someone
will go in and put data in for that day, leaving blank lines inbetween

When I open a XLS file, how can I know if this file is using some custom
addin (eg. MyAddin.xla)?
Rodrigo Ferreira