I have the following issue which I am not able to solve. I want to limit the
value possibilities of a cell to #,0 and #,5 For example: 8,5 or 7,0 but not
6,2 and so on. I tried to do it with validation but it doesn't work. Hope
anyone can solve this out for me.

Hi newbie here,
Excel 2007
I have a very large worksheet with hundreds of random empty rows.
How do I "automate" the deletion all of these rows?

Can a formula in a cell be protected, even if the contents that the forula
has looked is deleted.
Thanks in advance
Jason

I have a workbook with 5 pages ( I apologize if those are not the right
terms )
1 for "Reference tables"
1 for "Invoice data Entry"

Is it possible and most of all, easy to do?  If so, can you please leave
instructions?
Thanks in advance.

My excel data contains three digit combination on each cell. To find selected
two digit on a three digit cell data, I need to color font or shade due to my
thousands cell datas. Can this be possible? Please provide detailed info.

I have a macro that I recorded which works great. It does a copy and special
paste to another work sheet. The only problem is that after it has run, if I
made some kind of mistake and it copied the wrong stuff (or whatever), I
cannot click on undo or alt-backspace.  Is there ...

I would like to open two spereadsheets. I want to read one and edit the
other. At the moment, when I open the second spreadsheet, it replaces the
first one that I opened. I can see all the different spreadsheets on the task
bar, but they all appear to be sharing the same window.

I'm new to pivot tables, and most of the help files I've seen are completely
uncomprehensible. Is there a source of help/tutorials out there for the
absolute beginner?

Hi, I'm new to this and have a very simple question.
I have values, simple numbers representing weight in kg, that I wish to
automatically convert to US pounds.
The 'kg' numbers are in fields B5 - to B77 for example.  I want the

I have cell I13 which calculates the tax amount of an item. I have now set up
a check box, when it is clicked it will display a user form asking to user to
enter an alternative tax amount and press “OK” button. I have linked the “Ok”
button’s result to O13.

Is there a way that I can set up a spreadsheet row that would print
automatically row headings on every new sheet, regardless if cells move up or
down?
Secondly, how can I get cell B1 in sheet 2 to look at column A in sheet 1

I'd like to be able to add custom properties to an excel workbook using
vba...
Same stuff I already do by hand using the custom tab of the property window...
Thanks for giving ideas

Every single time I try to use the = sign in Excel 2003 to enter  a formula
the save as box appears. It is super annoying and I have no idea why this is
happening. I even removed Excel and reinstalled it and it still does the same
thing. If anyone has any suggestions it would be ...

I pay an employee a base salary of $800 (based on sales of 0-15,000)
plus:
I want to pay 7% commission on the excess of the amount greater than
15,000 or less than 20,000;