• How do I associate an employee # to a name in Excel 2007?

    I work in a restaurant and created a tip out spreadsheet. I need to insert employee names constantly. It would be much easier to just type in their employee# and have their name appear in another cell. Ex: Column A=Employee#, Column B=Employee's name. I want to type in the employee's # in cell A1...

    Weazel5830 pointsBadges:
  • Excel 2007 – How do I ignore zero’s and #DIV/0! for a graph?

    Excel 2007 - How do I ignore zero's and #DIV/0! for a graph? example: you have data that looks something like this: week # 1 2 3 4 5 6 PTP% 10% 13% 0% 0% #DIV/0! 0 % Then graph the PTP% across from week 1 which is 10% to week 6 which is 0% On the graph all u will see is the plots from week 1 & 2....

    Jreifenstein001185 pointsBadges:
  • How to I create a Chart in Excel 2007 from Non Numerical Data?

    We have several projects going at work and my boss is tired of sorting through Spreadsheets and told me to graph everything. I need to figure out how to make a chart register how many of word/phrase A, B, C etc. there are in a column and stick that in a graph. If anyone could help I would really...

    Kuroia5 pointsBadges:
  • How do I run Excel Reports?

    Is is possible to run reports similar to how you run reports in Access in Excel 2007? If so, how?

    Lysprice5 pointsBadges:
  • How to collapse data in a Pivot Table in Excel 2007?

    I created a Pivot Table and its giving me a description with the different codes that fall under each I want to collapse all the descriptions so that the codes under each disappear and are summed up within each description I can do them one at a time but I have some many lines to collapse.

    Babyphat5 pointsBadges:
  • Excel 2007-There was a problem sending the command to the program.

    No existing Excel document will open. I can create a new document & save it but it will not open. Excel diagnostics doesn't detect any problems. Un-installed Excel and the existing documents opened. Installed SP3 & updates & now existing documents won't open.

    TLeemoneyman10 pointsBadges:
  • Exchange 2007

    How can I take an e-mail with 450 zipcodes and put it an Excel format?

    Pduvall25 pointsBadges:
  • Excel cleanup

    I have multiple values that bleed over into multiple cells. How can I clean it up to be one value, once cell?

    Pduvall25 pointsBadges:
  • Pivot table changing into values on save

    I have created a pivot table in which one field is calculated field. I saved and closed this pivot table. Next time when I open it is changing into normal Excel table with values. But I want this to open as pivot as is. How can I rectify this problem? Please help someone. Application using: Excel...

    individually5 pointsBadges:
  • How do I save as XLAM Excel add-in

    I have some code that I want to use in Excel as an add-in. I have Excel 2007 and VB Express 2008 installed on XP Pro SP3. I see everyone saying to "save as XLAM Excel add-in" on forums and sties, but can't find that option anywhere on my apps. What am I missing?

    swinehart68031,050 pointsBadges:
  • Custom formats

    How do I delete a volume of custom formats associated with an Excel 2007 file?

    EMEL5 pointsBadges:
  • Cell formula

    I have a simple 2 column balance spreadsheet. I have my starting balance in column E Cell E4. I want to have a running balance in Column E. Column D has deduction amounts from balance in Column E. I have entered formula =(E4-D5) in cell E5 but this automatically enters the same starting balance...

    Schwenky5 pointsBadges:
  • How to change shade color for selected cells

    How do I change the shade color for selected cells?

    woge495 pointsBadges:
  • Excel formula program

    Hi, I'm trying to do a table where I need to calculate how much commission I'm paying for a company. Before 35,000, I pay 35% commission after 35000 I pay 10%. The formula I have right now is =(IF(F9>=35,F2:F8*0.1,(IF($F$9<=35,F2:F8*0.35)))) and it works, but... I don't want the whole column...

    natmail10 pointsBadges:
  • Excel

    All of a sudden when I open a number of Excel docs, I don't see the list on the bottom of the page to click and retrieve. I have to go back up to open and then open them from there.

    Mrboop10 pointsBadges:
  • How do you calculate formulas in Excel 2007?

    I am new to Excel and have a project to do tomorrow at my new position. We have contracts that start on a certain date in 2010 and will bill for various time periods. For example, we received a  240,000contract and will bill for the remainder of 2010 at $10,000 per month. The total for 2010 will...

    Cathraff5 pointsBadges:
  • Excel Help!

    Hi, I need to create a tool that gives users a question, they select an answer and depending on the answer it will give a question.

    DaveInwood30 pointsBadges:
  • Are user subs and functions in the microsoft office object model hierarchy?

    I'm an experienced Excel VBA programmer, who is trying to write a macro in Excel that uses functions and subs in Outlook.  I've done some searching and found that the standard answer looks something like: <code>     objApp = CreateObject("Outlook.Application")     call...

    Jwolter5 pointsBadges:
  • Problem With Microsoft Excel 2007

    Unable to copy or paste  and use format painter in excel 2007 cell is not getting highlighted , sometimes it works fine and sometime it doesn't. sytem configuration is very good using windows 7.

    raj2275 pointsBadges:
  • Excel 2007 – allocating non-repeatable values in a set

    I am creating a questionnaire. There is a set of 4 words and users are asked to rate each word with a value from 1 to 4. The user can not repeat any of the values between the 4 words in one set. There are many sets of 4 words and as a result, this process has to be repeated many times. I am...

    Ubilkhu5 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following