working cells A31,B31,B32,B33. If B31A31,then B32 is (A31-B31)*8. If B31A31, then B32 is (9999-A31)+B31*8. I'm tryin to clock a electric meter that rolls...

I just want to write email addresses on the worksheet cells. How can I prevent this f...ng Excel from automatically changing them to mailto: hyperlinks. "I...

What I would like to know is how to have a row that stays the first row, when I scroll down, so that whatever page I am on, and no matter how far down I am...

I've created a macro that begins with an auto_open importing, reformatting, and saving data. In the same macro, I have an open excel form. Next, Im attempting...

I'm trying to make a time sheet for myself but my time keeps coming up negative. in cell a1 i have 9:00 AM (with the cell formated as time h:mm PM) and cell b1...

Sorry if this appears to be a newbie question, but how do I display a percentage figure of another cell. Example: A1 £52.89 A2 17.5% of A1 Thank you

My company has asked me to come up with a time sheet in Excel (using Excel 2002) that will allow the employee to digitally sign it before being sent to...

I'd like information that I input into a cell to be automatically output into another cell. So, for example, In one cell I input the following...

Hello, I'm an obvious new user to Excel with a strange problem: When using Excel 2000 under Win 98 SE, I cannot get a certain Excel spreadsheet to display in...

Hi, I am trying to create a works requisition in Excel for our staff to use on the pc and email to me so to make the progress a bit faster than snail...

I have a colum of dates and a colum of websites. What I am trying to do is lookup the date and if the date matches. It would then lookup the the webiste and...

Is there an easy way to copy this to about 700 cells? =SUMPRODUCT((A4:A11998=S6)*(B4:B11998=V3)) there has to be an easier way to copy this.

When I create a pivot table (Excel 97) rather then count, sum, etc the values, I simply want to display the values. Not just the min, max etc. I want to...

I have a list of numbers that coincide with the sheet numbers... i want to be able to click on the number on my first sheet and have it open up the sheet#...

I have a cell formatted for Text with the following information; 006-0527-5475 I want to remove just the huphens so it looks like this; 00605275475 Does...

I colour coded 500 lines of data last week and when I opened my file today, all the colours were replaced with dot shading of all the coloured lines. HOW DO I...

I'm fairly new to Excel. I want to merge names and address information from different colums. Then I want to create mailing labels. Can someone help me with...

I'll just rush on over and pour my life savings into whatever stocks this site recommends. No wait, I'll go to Vegas instead. "...

How can I lock XL with a password so that this password must be entered before XL will open. Thanks

Hi, new to excel and struggling with references. Column B is a list of names. I want these names to also appear in column X (ie. B3 name should appear in X3)....