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...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back