microsoft 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.

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...

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...

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...

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

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...

<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...

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...

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...

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...

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...