Hi, I am using Excel 2007. Headers on my first page (in Columns A3, B3, C3, and D3) are as follows: Date Test 1 Test 2 Daily Average I would like...

I want a cell should to accept =0 or =30 or Y or N Regards Brijesh

Folks, I am learning how to use the Advanced Filter (Menus: Data, Filter, Advanced Filter). I can’t use Autofilter because in some cases I have to look for...

I have created a workbook to track all my bank deposits, automatic deposits, and credit card receipts. Each worksheet has a cell that contains the total...

Title tells all. This is probably so basis Old Hands will laff selves silly but I'm roadkill alongside the on-ramp to the Infobahn. I've bludgeoned Excel...

I am not good at this at all, novice at best. This is my current formula, are you able to tell me how to alter my formula to yield a - or 0? I appreciate...

One of my excil files are damaged from installing another system. How do I restore this file?

How to select a block of cells and make appear as a single cell ? ( but is still multiple cells under the covers )

is it possible to choose an item from a dropdown list which will enter a different value other than that chosen. Why I want to do this is as follows: We have...

I am trying to find a function to solve my problem. I'm not really sure if there even is one. Pretty much what I need is if G3 10, then I need H3 to =G3xB3....

Could you please elaborate what is the function of Control Find and Replace. Especially when using it to replace a formula to a new coloum

I have a two sheet workbook. If 'sheet 1 B7' contains a certain word I want "Sheet2 B2' to return the value in 'Sheet 1 B8". Can I do this? How? Thanx

I am trying to open a 2003 worksheet in 2007. I am able to open it, but all I get is a blue screen, with the ribbon on top and 'Ready' on the bottom. I tried...

I have two spreadsheets and want to link info from one sheet to another. I have totals at the bottom of columns and I want to be able to put those totals...

Hello, Have installed and am running now Office 2007 Using its WORD and EXCEL mainly. All works fine. Now, when I'm in a site (via Firefox), and there is an...

How do I get rid of 2 extra pages at the end of my document?

Hello, Using Excel 2007. In Column A I have a list of names: A1 Bob A2 Harry A3 Dave etc.

Would like to calculate cost of time. Eg. Cost for production down time per minute is $100. Says production doen for 3.5 hrs, what is formula shall I apply...

How can I change a cells contents based on a specific date (date is referenced in a different cell (i.e E2) and changes daily). I want to record and maintain...

Is there a way to count days (with a date enter in Start Column) until "Completed" or "Cancel" is entered in my Status Column? Right now, it is calculating...