General

Full page formulas
How do I do this for every row? Example: =SUM(C4*0.5) =SUM(E4*15) =SUM(G4+F4+D4) =SUM(I4-H4) ... 11 Feb 2010 03:56

Formulate Entire Sheet
I want to formulate my worksheet without have to go row by row. Example: =SUM(C4*0.5) =SUM(E4*15) =SUM(G4+F4+D4) =SUM(I4-H4) I want to do this in every row. How do I do that? ... 11 Feb 2010 05:02

Nested Greater than or less than Formula
Hi was wondering if anyone can assist. I haev a column of data which has number of days in them per below EG in column A 25 10 70 156 65 125 155 2 45 30 20 156 61 And in the next column i want to put the following: If column A is blank or zero then Column B is blank If column A is between 1 and... 11 Feb 2010 01:46

Excel 2007 no longer opens documents on desktop or email attachmen
When I click on an excel document on my desktop, I get an error message saying: "windows cannot find [name of document]. Please make sure you typed the name correctly, etc." The same thing happens when I try to open an excel email attachment. If I open Excel and can locate the file through "Desktop" or "Documen... 10 Feb 2010 23:35

Run time error 1004 in loop
Please help Thanks Sub Macro1() ' On each stick memory, I will have a book named as 'IDnumber.xls' ' I'm attempting to identify which drive that has 'IDtestnumber.xls' ' This script supposed to do that, but I kept getting 'Run-time error 1004' ' Memory stick keeps changing drive letter. Is there a way to identi... 10 Feb 2010 19:07

Excel worksheet moved all data from multipl cells into one
I recently saved a list from another software program into excel. The original format was csv or txt, i can remember. when i resaved the worksheet i saved it into excel format and no formatting changed. when i reopened the file all the data that was in my rows which has 12 columns of data in individual cells al... 10 Feb 2010 19:07

Set up form fields to that Tab can be used to move from one to ano
Hi! I'm creating a form in Excel 2003 with a variety of text boxes, check boxes, and drop-down fields, all created using the Control Toolbox. I'm having trouble figuring out how to set these form elements up so that the user can press the Tab key to move from one field to the next. The Properties dialog box for... 10 Feb 2010 17:58

Prevent SORT from asking to expand selection in Excel 2007?
The problem that I have and the original poster might have is that there is a lot of data to be sorted. Adding the blank rows and columns is NOT an option for me. Is there a way to just turn off this "helpful" (extremely aggravating) reminder? "Gord Dibben" wrote: Is it possible in your layout to isolate ... 10 Feb 2010 19:07

Print Titles
Hi, I need some help please. I have a sheet with lists of peoples names and other specific data. I'm able to sort these and sub-total them into groups of the same name and print these on separate pages. I've set up a header so it prints at the top of every page through "print titles". This is fine and I'm ha... 10 Feb 2010 20:15

Print Titles
-- MM ... 10 Feb 2010 15:42