How can I turn it off? I do not have a button on my QAT so I am not sure how I turned it on.

Hi, In a table with subtotals we can see a formula like =SUBTOTAL(9,B4:B10) irrespective of the number of rows. What is the importance of this "9"? Can...

Hi, Here's an easy one, but I hate to admit it, I just can't find it: In the normal excel worksheet page (not a chart view), how does one change the spacing...

Hi, Good day, can anybody help me, actually I dont know how to describe the problem, I will just give the things that I've done. SCENARIO 1: I'm making a...

I have a WB created in Excel 2003. When I open and save the file in 2007 in the same mode it was opened, I get the following error: This workbook contains...

Hi All, I need to use the rank function for the below example A Column B Column C Column Total Formula Rank Desired...

Can excel be set so that the active cell is highlighted while data is entered?

All of the sudden when I access excel files on my company's intranet, the files open in Internet Explorer, not Excel. Is this a setting in Excel that can be...

I am able to run 2000 and 2007 on the same machine ok except for the following The File Type associations are messed up. I have a bunch of files that were...

I want to copy a formula down a column but not change the first value. Example =SUMIF(AV4:BU4,"child",AV7:BU7) I don;t want the AV4:BU4 to change. Thanks

Hi I have 8 columns with various information I'm trying to get the following: search if the name in A1 is anywhere in column F2:F700 (and say it is in F600)...

The colour does not show on spread sheet when i hit review it will show then what am i doing wrong

I have a row of cells that are counting contacts, but I only need to count that there was a contact made from that row. A B C D E F 1...

Why do you not include a Mean Separation Test, like Duncans or Fishers? Your analysis is incomplete if after I perform an ANOVA I can't do a mean seperation...

I created a pivot table in a worksheet. The data for the pivot table comes from another worksheet (same book). When I update the worksheet for the data the...

On Oct 25, 7:51*pm, fluff wrote: Hi, I have a tricky question: I am comparing time interval data between two groups. To simplify...

Hi, I have a tricky question: I am comparing time interval data between two groups. To simplify things, I'll use leaves for my example. Okay. There is a...

MS Word 2003. Characters and or whole words mixed when entered. A word being typed onto the end of a sentence will appear somewhere else in paragraph....

hi, i have data in the below format in excel A 1 B 2 C 3 D 4 (empty row) (empty row)