I have 60 workbooks from where I need to gather information on a monthly basis. These are personell sheets for vacations, leave of absence and so on. From...

I have created a list of my DVD collection. I would like to be able to hover the mouse over movie titles and see a preview of the cover art, either stored...

I downloaded a Statistical Add-on for Excel. According to the help entry, I am to look for the Analysis Group under the Data Tab and then click on Data to...

I have Excel 2002 installed on a Windows 7 machine. While this version of Excel was installed on Win XP, it worked fine. However, since I installed it on Win...

Hi.. I have a few questions : 1. I have a sheet which has data in rows. How can I have the row highlighted in red if a particular cell A3 is blank for...

Hello, I know how to format a data series in a chart. I right-click on the data in the chart, select 'format data series, no problem. I want to format...

was used to excel 2003, but now cant figure out how to change pointer movement in excel 2007. want to stay on same cell after entry

Select multiple adjacent cells of multiple cells without selecting adjacent cells one by one. those cells looks like; |adjacent cells |cells| |some...

Hi I have a value of (A) 642 and a value of (B) 385.20. The difference is 256.80 what formula would I use to find the percentage of value 256.80 Thank...

Hello, My chart has an outer 'chart' area, and within it is a 'plot' area. I can resize the plot within the chart by dragging the corners. Am I able to...

I used an IF function to generate the cells in one column. E.g., IF(g3=25,"25,IF(g325,g3)). Now I want to use the results of that column in summing...

Hi, I tried my inquiry once but I did not get a reply. Maybe I was not clear and explicit with my question, therefor I will try again. Please anyone with...

Hello, I am trying to develop a complex chart & need help and advice please. I have 4 data series that I want to plot on the Y axis. The X axis is the same...

Hi helping hand; I have column"A" with numbers. I am required to add a column "B" showing a total amount with an addition of 35%. Now I have to add a...

I need to calculate different percentages for fixed numbers I have in column B. How do I make column C a percentage of B, column D a different percentage of...

A pretty simple question I guess. I am trying to make a template to do material take offs for a construction company. I am trying to add 10-15% to various...

Hi Everyone, Using Excel 2003. I am calculating my hours worked. I enter in the start date and time in the B column and the end date and time in the C...

Where would the "OR" go in the following function: Cell A1 can be Yes or No Cell A2 can be any number Cell A3 can be any number If EITHER Cell A1 is "Yes" OR...

Hello I have this formula that works so far but I need to divide the D9 by K9 and cant figure out the formula... Here is what I have so far but get the div...

I have MS Office Home and Student 2007 installed on my new Windows 7 x64 machine. Everything works fine. However, when I open an Excel file, a...