Hello. I have column of data that is both date and time. However when I create the pivot table I only want it to summarize the date. I've formatted both...

I'm trying to copy 171 document names only into an excel spread sheet so that I can then talk about the status of each document I don't seem to be able to...

Hello, I'm a bit stuck as I have to find a formula to apply more than one rule into the smae formula that i am unsure of a would appreaciate some assistance,...

Hi, I'm hoping you can help me with a problem. At work I work with a database of information ( the database is locked, so I can't just add a report for the...

I have recently reinstalled MS Office 2003. All appears to be working except MS Excel. The file command seems to be the only command working on the menu. ...

I am using Excel 2007. I have a spreadsheet that has about 20 columns of data for each day of the week in a calendar year. I create a pivot table that...

My MS Office is Office 2003. While open a new workbook in Excel, the sheet tabs are not shown, I need to set by tools - option and check the sheet tab every...

I have two files. One is monthly vacation schedule and other one is weekly schedule. What I want to do is if I enter a name in monthly vacation I want that...

Whenever I open a .csv file that is ; delimited by doubleclicking it in windows explorer, excel automatically interprets it as comma delimited. I'd like to...

I am using a Pivot Table and when I group the field date for more than one criteria, for example Months and Days, Excel automatically adds a new field called...

With the help of the online Microsoft team they have provided me with the following Macro which is transferring data from Sheet 1 to Sheet 3. All I need to...

I have a series of cells containing the defining limits of a range, i.e.: -sheet name -top row number -top column number -bottom row number -bottom column...

We recently completed an online Excel test that people can take then post the results to Facebook so if you're an Excel expert and have 5 min to spare, we'd...

I have built a flight planning program for aviation using Excel 2003. I am trying to find a function to import winds aloft from NavCanada's aviation weather...

I have two worksheets (let's call them a & b). They are identical with around 1000 rows. I want to link the cells in worksheet 'b' to worksheet 'a' so data...

I am getting a result that I beleive is incorrect using the AVEDEV formula. My data is .492, .580, .589, .735, .803, .819, 1.084, 1.413, 1.423 & 1.613. ...

I have Office 2007 and everytime I hide a column of cells or two the graph that is overlapping those columns shrinks. How can I avoid this?

Appologize in advance if this question has been asked... but I want to use Microsoft Excel to take a list of 25 names and create some random teams. See we...

In Excel 2003 you can move points in a chart by clicking and dragging points directly in a scattered chart. It seems that you can not do this in excel 2007