I am trying to create a function that will allow a user to select from a drop down menu. Upon selecting an option, I want the other cells in this row to...

I need monthly data in a pivot table to be in fiscal year order (July to June). How can I do this? Thanks.

I need some help please can anyone tell me why i am not able to do the training, i do all the rest but when i get to the training page it takes me to...

-- Could you please help me with this formula. I am trying to use a nested IF and AND formula to calculate the vaction days for full time employess with...

how to add a redo button on my tool bar

I have created a sheet that lists 12 months of information and for each month I have to create a chart. After creating the first chart, I formatted...

Hello, I have a row of #'s, in the row below I would like to increase each cell's number by 3.5%, in the next row 4%, etc. What is the formula? Example of...

Hi I have searched the forums and Google w/ no luck. Please help this is such a basic question that I cannot find the answer. 1.) I only have 1 cell (say...

I cannot open multiple files from any folder for first trial unless I open a single file first and then hilite multiple files and open them. When I try to...

These version upgrades should be more user friendly and have improved features. I can't find a way to open an existing file or have cells with more than one...

How can I multiply from one cell or another cell to receive an answer in a third cell?

I have a worksheet that returns TRUE when comparing a blank or zero entry to the criteria. Other worksheets in the same workbook return correctly FALSE when...

Hi, Had to put a new hard drive in my notebook, and reinstall XP home and all my software. Reinstalled Office from original disks, and most of it works. Word...

How can I create multiple trendlines on one graph i.e I have a graph with 5 years data and I want to show a linear trendline for each year on the same line?

How do I create multiply trendlines on one graph. I have 5 years data on one graph and I want to show a linear trendline for each year on the one graph? Thanks

Hello, I want to have a main tab that I would select an employees name from a drop down list "The employee name would be the name of a tab" Then it would...

Hello, hope someone out there can help me out a bit. This is the problem. I have 2 sheets. One with a summary and calculations and one sheet with data. In...

I have projects wehre I need 30+ worksheets. I used to be able to click the new worksheet button, paste headings and start. With 2007 it seems I have to go...

either from a drop down list or otherwise, I would like to be able to select the beginning of my text entry (ex: reseach of ) and then be able to complete...

I currently have a list using validation and only so many line show up in the drop down box. Is there a way to increase the size of the drop down box? --...