General

How can I reactive the Hide option on the Format menu??
The Hide/Unhide option on the Format menu is unactive, I need to reactive it. Thanks ... 10 Mar 2010 15:21

when I open excel file,changes was undid-excel 2007, compatibility
I have a file that was made in excel 2007 working in compatibility mode and when I change format in some cell (for example font size), then I save changes and after reopen this fiel the changes was undid. Can some help me? Sorry for my english isn't very well -- thanks Pedro ... 10 Mar 2010 14:13

Microsoft Query is changing a negative number into a date
I am using Microsoft Query to pull a subset of a large excel file however two of my columns which are suppose to be numbers are not pulling in the negative numbers. If I look at the query in microsoft database the number shows up as a date/time string. I've tried formatting the original number as a number but... 10 Mar 2010 14:13

AverageIF
I have two questions. 1. When using AVERAGEIF... actual line =AVERAGEIF(A1:A5,">2") this works great unless all values = 0 then I get #DIV/0!. I would like to have the value remain 0 (The greater than 2 is because we have a +;- 2 standard error in our insequel pull of information. How would I correct the error... 10 Mar 2010 17:35

Counting data function
Hello, I am hoping someone can help me out. I have a large spreadsheet which records various data regarding rejected parts. I want to include a function/conditional formatting that will count if there is more than one rejected part number in the last 90 days. There is a date column where the date of rejec... 11 Mar 2010 02:24

Highlight a Cell if Data not Present
Is it possible to highlight a cell if that data has not been entered after so many times? For instance, if I have a column where I have entries of A,B,C, & D and say B hasn't been entered for 7 times since the last entry of B, is there a way to highlight that last B then? Hopefully my question is clear enough... 10 Mar 2010 11:57

XP (Excel 2003) vs Windows7 (Excel2007) Printing
I have Excel Files containing Macros created in WindowsXP Excel2003 ... which print fine ... Same Files opened & saved in Windows7 Excel2007 as Macro Enabled WorkBooks ... DO NOT print fine. In both cases (Excel2003 & Excel2007) Print Preview is perfect ... However, printing from Excel2007 does not print the b... 10 Mar 2010 11:57

adding a word to excel dictionary
I am creating a phone list for my workplace, and we have abbreviations that are not found in a normal dictionary. How can I add special words to the Excel dictionary? ... 10 Mar 2010 10:50

draw corners
I have seen people use excel for effectively drawing and highlighting text and data by coloring cells in a way that results in effect the cells looking like arrows...I have also seen where this is done in "corners" of these shadings looking "rounded". Now this isn't done - i don't think - using lines/borders e... 11 Mar 2010 04:34

Excel 2007 Pivot Tables - do not display zero values
How do I set my pivot table so that it does not display any sums of values that are equal to zero? Thanks, Barb Reinhardt ... 12 Mar 2010 10:33