I have a cell A1 with a drop down to select month. In another cell on another sheet I want to compare the current month to the value in A1. If (current month...

Hi, I know I can number sequentially by just entering 1 in the first row and hitting ctrl+draging it down. But what if there are headings inbetween that I...

I have text controls that are word wrapped and a 250 size. Can enter the text, and it does wrap, but the size of the control won't expand to see all the text...

I use Excel 2003 on Vista. A couple of days ago, I was getting this response to many helps such as F1; Search VLOOKUP; Click VLOOKUP. The problem went when I...

I want to know how can I set the default for the classic Pivottable layout in version 2007. I've tried the pivottable options display tab and checked the...

how to calculate the grading for staffs

Hi Everyone, Excel 2003. I have a list of numbers. I use the Insert/Function then drag the cells I want to create my formula for averaging this column. I...

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...

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...

I am trying to link a Word document content (inside the .doc) to my spreadsheet. I need help with this as the on-line help shows how to hyperlink between...

need major help with excel. I can't remember how to calculate the numbers and means etc for chart useage

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

Hi This may not be the correct place to post this question but I cannot find any other access to appropriate 'help'. Is anyone able to tell me whether my...

Is there any way to make cell editing work like it does when you hit F2 by default? If you just start typing in a cell and then want to use the standard...

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...

OK, I have a spreadsheet-packing list thats gets populated from 3 differrent list's depending on what kind of slip I'm preparing via a drop down menu. Is...

To take it a step further, I also need the formats to remain the same. ie...the left column data is Left-text-justified, and the right column is...

I am new to SQL and using MS Query in Excel to extract data from SQL Server. The query retrives result from a number of tables and the result is in the...

Hello, Using Excel 2007 Have a column of numbers that I entered as Text. Wish to change the entire column, now, to "Numbers," so that I can apply a formula...