microsoft excel 2007

  1. B

    Alternative to Microsoft Date and Time Picker in Excel 2007

    Hi there, my work environment unfortunately has excel 2007 sp3 and I'm trying add a drop down calendar to a spreadsheet we all use. I'm wondering if there is an alternative to the Microsoft date and time picker control that is only available in sp4 which we aren't allowed to download.
  2. E

    Multiple Sheets Data in One Sheet

    Hello Admin & Team, First Thread! I am exited to be a part of this this Forum. Need help team, i know this is stupid question which i am asking but i need you help on this. 1) I have created small dashboard which has almost 12 sheets and each has there own monthly data. 2) Now i have created...
  3. S

    Need help creating a Macro.

    Hi, I have 2 sheets in excel. (Say "Data" and "Source") and I do the following task on regular basis. 1) Double click the cell C3 in "Data" sheet . (It takes me to the "source" sheet). 2) Press Cltr + A (To select entire details from "source" sheet ). 3) Press Cltr + C (To copy entire...
  4. S

    How to mail merge in excel from excel and save all files individually in excel format ?

    Hi, I have two excel files. (Say A & B). "A" excel file contains data of 100 Names, Addresses, Zip Codes Etc. "B" excel file contains template letter format. What i want to do is export data from "A" excel file to "B" excel file and save all 100 files individually. Is there any excel...
  5. E

    Highlight Negative Values on Graph

    Hi there, I want to be able to highlight any values less than zero on my graph.. So, when the value goes below zero, it automatically changes color to red. The graph I am trying to do this to is a line graph by month. Is this possible? Cheers, Eoin
  6. T

    Adding a Z Axis to a 3D Chart

    I would like to know how to add a z-axis to a 3D chart in Excel 2007, Excel 2007 enables addition of a z-axis to a 3D chart but how does one do this and what would a sample data set for this kind of chart look like. I've tried searching and all I've found is how to add a secondary y-axis to a...
  7. W

    Looking for help on creating a search...

    <table border="0" cellpadding="0" cellspacing="0" height="695" width="2947"><colgroup><col style="mso-width-source:userset;mso-width-alt:3584;width:74pt" width="98"> <col style="mso-width-source:userset;mso-width-alt:12507;width:257pt" width="342"> <col...
  8. E

    Printing to PDF - JPG Printing wrong

    Hi, I was wondering if anyone can help me out. A little bit of background: I have a workbook of about 10 worksheets in Excel 2007. I will save different numbers of these worksheets to PDF every month. i.e. there may be no data on one of the worksheets in a specific month, so I will not save...
  9. E

    Using SQL with VBA

    Hi, I was wondering if anyone out there can help me! Currently, when I want to pull data from my Oracle database, I use Microsoft Query. I click on Data -> From Other sources -> From Microsoft Query. I choose my data source (Microsoft ODBC for Oracle Connect) and then enter they SQL query...
  10. J

    Pivot Table and Chart

    I've created a pivot table and then a line graph chart that points to it. When I filter the pivot, my line graph adjusts on command in a very responsive way. However, the grid lines and totals on the left do not coincide with the graph bars unless I'm viewing all data as assigned in the pivot...
  11. P

    are online excel classes a good idea?

    Hey everyone, I'm a decent user of excel but i'm trying to get better and I was wondering what anyone thought about taking some online classes in excel? I recently upgraded from excel 2003 to microsoft excel 2007 and just basically need to learn the new features and layout and stuff. So I...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top