Hi, Is there a way to have excel create a backup file saved somewhere each time the workbook is either opened or closed? I know there is the auto recover but...

How would I insert in my input box of data validation the values of cells D6 and F4 basically if the user clicks on a cell F6 I want it to reference f4 and...

emailing files from excel, the files will not go until I open up MS Outlook. Only then will the file go. I have waited for 30 minutes and more and the file...

I've a spreadsheet containing numerous mathematical formulas. I would like to be able to make cells containing a formula flash when the results fall below a...

Hi - I have Excel 2007 which is part of Office 2007 Professional running on XP Pro SP3. The autocomplete function on a descriptive cell is terrific....

When I do a page preview, each cell in the worksheet appears as a separate page, and when I try to change the page layout, I can not get past a "margins do...

what is the difference between this formula: =+C31*$D$14 and this one: =C31*$D$14 both formula give the same results. what is the purpose of the plus sign?

(This is a question about how to use the Forum; not how to use Excel. I know it doesn't belong here. Please accept my apologies. I can't find any other place...

When using this formula =IF(ISBLANK(B2,"",VLOOKUP(B2,D2:E20,2,1)) I am getting the #N/A error or incorrect data if the value in cell B2 starts with a 0 eg...

Hi, I have a column of numbers and I want to substract a certain value from every cell in that column and create a new column with new set of numbers. How do...

I would like to create a mailing list in excel, entering each address in, not importing it from somewhere. Can excel do that? Or do I have to import...

I would like the Excel sheet to open in Excel but would like to access it from a toolbar button in Word. Is that possible?

Hi to you all I have files in tab delimited file and I want to save them as excel files. Since I'll have to do this for many files, I want to use a macro I...

I downloaded written data from computer (e-mails) to cd-rw. Want to know how when put it in computer can get it so I can read it. It now looks like code

I have a worksheet where the user can click a button marked 'Create Activity'. This spawns an Activity worksheet with the naming convention 'Activity (n)'. The...

Hi all, I hope you can help an old dog learn a new trick here. I have a list of 20 values for X, and thier matching Y values. Now, what I need to do is find a...

I am trying to create a box plot in excel. My book says to go to tools and Data Analysis Plus. I have already added data analysis, but I have no Data analysis...

I have a spreadsheet another person sent me. It does not show the gridlines and I need the gridlines to be visible. I tried Tools, Options, view, etc. Help!

This may have been covered before - and apologies if so - but I can't change the default row height from 12.75 to 15.00 each time I open excel 2003. I have...

I have some how created a situation where if I type in a cell a whole number when I move out of that cell it automatically inserts decimal places, typically 52...