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

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

How do I make the Microsoft mouse stop the zoom effect when I have it on the spreadsheet. I want to scroll up or down not zoom in or zoom out. Thx

I have a workbook that tracks inventory, but I would like to update it with a formula to help me track the materials used to create my inventory. Example: ...

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

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

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

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

Hi all, I am using office2007. I have an excel sheet with the following colimn invoicedate amount period. How I can give a formula i n period...

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

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 rows of data on a worksheed which represents proposals of all my reps. Each Month is represented by a separate worksheet. Each row contains the name...

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

how to calculate the grading for staffs

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

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

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

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