General

How do I change my return to the next row so not always right?
-- George Iskandar "JLGWhiz" wrote: Are you thinking about the Home button? "Benedict9" <Benedict9(a)discussions.microsoft.com> wrote in message news:47D03D04-5858-441B-B67A-58485810CCA6(a)microsoft.com... I simply want the old fashioned editing feature from Excel 2003 where you hit ... 2 Feb 2010 17:28

cannot access directory in options
When I try to change anything in option I get the error "cannot access directory J:\\" I no longer have the flash drive that I used when I original set the default file location to "J". The Drive is still available but I don't have a flash drive. ... 2 Feb 2010 17:28

excel 2007
Hi all Is it possible for an excel work book created by microsoft office xp professional version 2002 to be compatable with office 2007? Thanks for looking ... 2 Feb 2010 17:28

How do I get Excel to print in page centre?
I am sure that, in previous versions, you could entre what you want to print without having to adjust margins and guess where the print might end up. Is this still possible with 2007? ... 2 Feb 2010 17:28

What is a "line print setting"?
When opening an Excel 2003 file (.xls) and attempting to save it as an Excel 2007 file (.xlsx) , I frequently get the error that a line print setting is not supported. What is it, anyhow? Tony ... 2 Feb 2010 17:28

how do i work i pints and gallons
i would like to have a column that works in pints and gallons that will add up at the bottom. so if i put in 1.4 (1 being a gallon & .4 being pints) + 2.7 (2 being a gallon & .7 being pints) the answer i need would be 4.3 as there are 8 pints in a gallon Using Excel 2007 ... 2 Feb 2010 17:28

i want excel to show the first tab upon opening, not the secon
Hmm, Actually no I intended to write sheets(2) but that's because I misread the post!! Thanks for the correction. -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "מיכאל (מיקי) אבידן" w... 2 Feb 2010 17:28

Help: Using CONCATENATE (and a COUNT?) for a total result
I am trying to get a formula to work but says invalid each time. I am at a loss. In Column C, I am using the formula =CONCATENATE((COUNTIF(A1:A10,"Item 1")+COUNTIF(A1:A10,"Item 2"))," = Total Items"). In Column B is the object (reward points for this example) I want to count against Column C. In Column A, ... 2 Feb 2010 17:28

Map one more column map within a single XSD element.
Map one more column map within a single XSD element. I have export the xml file from the excel file format, the data has in one more column a xml element data. How can I map one more column? In my XSD (problem is "sub-item" element) <xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema"> <xsd:element name="... 2 Feb 2010 17:28

Pivot Table Format Preservation
I am using Excel 2007. I have pivot tables that seem to have a mind of their own with regard to formating. I would like to get it formatted, and have it not change on refresh/update. I have chosen the option to "preserve formating on update" (box is checked), but that appears to be a placebo box. Any idea... 2 Feb 2010 17:28