General

Pasting active links in excel
Previously i was able to paste active links and addresses in excel, or format brush, or double click to activate cells containing links and addresses, however now this option is not available. I cannot identify the setting that allows me to change the option back to the way it was. Thank you if you can help. ... 5 Mar 2010 19:38

Puzzled about javascript interfering with functions and formatting
Our company has a large intranet website setup with a bunch of data in it and it would really be nice to copy and paste from any of there sites into excel and do stuff to the data. Sort by hire date, remove those pesky spaces I don't want, etc. The problem (I guess) is javascript/java that was used to make th... 5 Mar 2010 18:30

Best method to populate cell based upon drop down list selecti
Thank you - I sorted the list for the drop down, but didn't change the order in the formula. "Mike H" wrote: Hi, They lookup vector has to be sorted =LOOKUP(A1,{"african grey","collie","palomino","parakeet","pointer","poodle","quarter","thoroughbread","toucan"},{"Bird","dog","horse","bird","... 5 Mar 2010 17:22

How do you turn on "view side by side"?
I need specific directions for how to turn on the View side by side feature. using Excel from Office 2007 ... 5 Mar 2010 16:15

Vlookup will not retrun value
I have a very simple formula =VLOOKUP(M3,Days!$A$5:$I$28,9,FALSE) When I change M3 to N3 and hit enter, I see =VLOOKUP(N3,Days!$A$5:$I$28,9,FALSE) displayed. How do I get this to retun the value and not the text string? ... 5 Mar 2010 16:15

Different First Page?
In Word I can set preferences so the first page is different. So far I have not discovered a way to do that in my Excel 2003? It would be helpful if I could put a header on the 2nd and 3rd pages that tie them back to the first page without giving up space on the first page for the same header. Granted, it would... 6 Mar 2010 17:24

Using VLookup and format the #N/A result
I would like to format an #N/A result to a blank cell or with a 0 when instead of the #N/A. Can anyone assist in how to accomplish that? Thanks! Linda ... 5 Mar 2010 16:14

excel 2007
a file created in excel 2000 then converted to excel 2007 has one sheet that responds very slowly and is driving me crazy. It does have a lot of formulae but the same sheet works fine in both 2000 and 2003. Please help -- izzy ... 5 Mar 2010 17:22

Can't open my 2003 excel files on 2007
I can open my word documents just fine, but can't open my excel files from my 2003. ... 5 Mar 2010 16:14

Regarding Xcel
HI there, i plotted xy scatter graph for Amplitude Vs Depth and now i need to draw a curve/line using maximum points. How can i do that? ... 5 Mar 2010 12:50