Hiya,
I have to analyse some survey results that have been stored as .csv files,
and I've only ever used very basic Excel functions before.
Where a question allowed multiple results, I need a way to count and sort

I have a column that has percentages in it; some have #'s great than zero
while others show a zero percentage.  I would like my formula to say if the
cell = 0% then don't include in average calculation.  Is this possible?
Thank you,

Trying to hide some columns I get the above message.   The objects concerned
are Comments which have been very widely separated from their cells (due to
inserting rows etc).   If I find the offending comment and move it back close
to its cell the problem is temporarily solved, ...

I can't seem to use an acronym in the cell. FOr example "HSA" will
automaticall go to "HAS". Please let me know a way around this.

I created a graph with a dual axis. I want the first three data sets
to go off of the first axis and the fourth to go of the second axis. I
was able to do this but I also want the first three to be bars and the
fourth to be a line. The graph is austomatically making the first two

I have so many sheet tabs at the bottom of my work book that I would like to
make multiple rows. Is this possible?

I forgot how to highlight individual cells to use in a chart.

A have a simple formula:
K40 * D59 * B310
B310= 28   (Days in February)
I have cells that = year (2008, 2009 etc) that are not used in this formula.

Every time I auto fit one column width, other widths in the worksheets
change.  How do I lock the formatting of cells, but not the data, especially
the column widths?  I'm using Excel 2003.

I have several timesheets that I would like to use for each employee.
I would also like a summary sheet that has all of the employees in a drop
down menu. However, how do I do this,so that when I update an individuals
timesheet, the new sheet is also updated?

I have a need to hi-light a set of two columns per set, every other set.  In
other words, columns a and b would be colored, c and d would not, then e and
f would be colored in and so on.
I am using this conditional format formula, which is close, it does every

Is there a way to create a formula or macro that when I enter a number in a
cell it will automatically divide 5.7?

I want to require the user to enter his/her name in a specific cell (E59)
before the user can save the file.
I tried using Data Validation where I specified Text Length between 1 and
40, and left blank the check-box for "Ignore Blank". Nope.  I never

I have two values: C11 is total disk size. C12 is unused. I'd like C13 to
show a Data Bar that displays amount of used space. Every way I try it, I get
a bar that looks like 50%. So . . .  can Data Bars be used for this, and if
so, how?  Thanks

i am in a GIS class and in one of the task it says to save a file that i have
uploaded into a *.dbf file. but the excel 2007 version does not give me this
option. is it possible to do so or is this option only available to the
previous excel versions?