Upon protecting a worksheet I find I am unable to collapse or expand grouped
rows in a worksheet.
Is there a way to accomplish this without unprotecting the worksheet?  It is
used by 44 people and we need to have the cells with formulas protected?

if    (condA=true,"Ï")
How to use function in cells to "print" webdings characters?

Is it possible to show the high and low values in column b based on the
grouping in column a? I have a customer list with the prices each customer
paid for the products. I want to know what the highest and lowest price each
customer paid for their products. Is this possible using ...

I have a spreadsheet (didn't develop it).  It is very basic - you enter
in information (col's A through J).  One col contains the usersname.
You can have multiple col's with the same username but different events
and dates.  At the top of the row (username) there is an down arrow.

How do you folks write this function if cell A1=B1, then cell D1=C1?
I created a list for 50 states, but I don't want to use the drop down arrow
to select the state I want, I want to select Texas by just type in Te, then
the rest letters (axas) will appear.  The same way for ...

I want to add 2 checkboxes in one cell, similar to a yes/no checkbox but name
one contract and one permanent so that the person entering the data chooses
either or in that cell in order to identify if an employee is a permanent
employee or not.  Can this be done in excel?

I need to enter data in about 10 columns from hard copies I get daily.  One
of these columns will be a key (alphanumeric) that defines a job.  I may
receive other hard copies on other days of that same job.  I don't want to
enter the data a second time.   How can I have the sheet ...

I am a very casual user of Excel. Most of my work is with Access.
I have a set of data where values range between 90 and 120 units.
If I make a chart most of it is the rang zero to 90 and has no use in
the display. I would prefer to show only the scale 90 to 120 and have

In Excel I select a range, which includes numbers and a small picture (a gif
file).
I click on File, Send To.
I select Mail Recipient

I need to figure out how to multiply a number by a percentage based on
the table below:
0-10 = 5%
11-20 = 6%

I'm having a really weird problem with Excel.  I'm hoping someone has
seen this before.  Here are some of the problems.  It appears like
Excel is stuck in some loop.  Maybe a bad system file?
1.  Excel CPU usage is around 75% even when I'm not doing anything in

I understand how to use STDEV to get Standard Deviation of a list of
numbers. Is there a way to do this from data which shows numbers and
their frequency?
e.g.

I am not doing this properly, I have one sheet split into 5 page breaks.
I am going to the row below the page break chighlighting the row and then
Insert/page break and done this for the 5 sections.
When I print it only prints one section.

Sorry for the Newbie question but.......
How do I create a macro to clear the contents of cells in one worksheet
based on the value of a cell in another worksheet?
For example: on SHEET 1 the value of cell A1 can be Yes or No.  If A1 =