Summary: I have a list (let say songs) in a spreadsheet in a single column in Excel 2007. Every time I turn around half the list and gridlines are gone. I ha...
Summary: Someone help me using Excel VBAProject to write a formula: Function mySum(firstCell As Range, interval As Integer, lastCell As Range) temp = 0 For i...
Summary: When I copy formulas, they are not updated as they are supposed to, ie. when copying a formula like =A1 from B1 to B2, the new formula in B2 becomes =...
Summary: Once the document is loaded, the links will not update. That's normal behavior. You could create a macro that updates when you run it, which in theo...
Summary: Hello, I had a heck of a time finding this and I wanted to post something in hopes that it will help someone else out: I recently had a customer with...
Summary: Your file could not be printed due to an error on HP Officejet Pro K5400 Series on Neo1.Can print successfully in Word 2007, Outlook 2007, and WinXP. ...
Summary: Excel 2007 was recently installed on this computer. Now, when I double-click an Excel spreadsheet, Excel 2007 launches but the file will not open. If ...
Summary: Please forgive me if this has already been answered, but I didn't find what I'm looking for. I'm trying to figure out why in excel 2007 when I record ...
Summary: Excel will not change the format of selected cells. I cut and pasted a table that I sorted on line. The problem after the import is that Excel will ...
Summary: I am applying a simple formula in Excel 2007 i.e. =A1*B1 and copying in the columns below by dragging the cursor. But the changes are not appearing th...
Summary: I am using Excel 2007 and would like to add a button that when clicked will add a numeric value of 1 in a seperate field. The idea is if my kids are g...
Summary: I'm a basic Excel user, but need help with a weird application. For Excel 2007, I want to build a cell with mult-colored dots (wingding character) ba...
Summary: When I paste numbers I've copied from the web into excel 2007, they are converted into date format. Is there a way to prevent this conversion & keep...
Summary: Similar to query from 'aphil48' on May 17, 2009. Excel will not change the format of selected cells. I am trying to change some cells to a Custom form...
Summary: How do I make it so if data is inputted into one cell then another cell produces the date. So... if A1 has any data B1 will show the current date. I ...
Summary: With Excel 2007 and Internet Explorer 8 (with Windows 7) is there any way to open a hyperlink in a new Tab rather than a different window. Sonehow I h...
Summary: Hi, As I mentioned an alternative and more specific approach is to use a Macro. The following code can be attached to a command button on your summary...
Summary: Hi, would anyone be able to shed some light on this issue I am having. I've goggle and tried all they suggested but still I'm having the same problem....
Summary: I want to use Text-to-Speech utility from Excel 2002. But, I could not find it in Excel 2007. Is this feature omitted in Excel 2007? Vishnu...
Summary: In Excel 2003, I was able to drag individual xy scatter point data to a new position on the actual graph. This was a great feature when one wanted to...
Summary: Silly me. Nowhere in the code was copy or paste. :) I see the "=" in the For Next loop. I just don't know the syntax to VB well at all. I can sort...
Summary: Hi, For some reason i cannot copy and paste in excel 2007. What i am trying to do is, copy a cell with numbers and paste it in another. The error i ...
Summary: Well, that's a bit clearer! I don't have 2007, but the concept is the same as in 2003. You need to base your formatting on the results of an IF statem...