Hi, I hope one of you can help me here - I've a large workbook (several worksheets within; no chart-sheets or otherwise) that I've created pro bono for local...

Is there a way to have 2007 default to save all files as XLSM? Basically all files I have need to be macro-enabled.

Does anyone have any suggestions on how to lock cell and worksheet? With a worksheet, it contains only a chart, and I would like to lock all cells and this...

I have multiple sheets within a workbook, and all I'm trying to do is link one cell in a sheet I've named "detailed" to another sheet I've named "summary". I...

Hello, I often use Home tab--Clear--ClearAll (Edit--ClearAll in 2003) Is there a keyboard shortcut for it? I'd find that VERY handy Thanks M

Hi all, i have a strange problem. If i type 0001 into a cell it returns 1? If i then highlight the cells and format cells and click custom and type 0000 it...

Hi, I need to make the sum of the values from a customer in a certain month. month 1 month 2 month 3 customer1 ...

hi guys some challenge for the experts here. is it possible to create a link in excel 2007 that refers to a SAP document or transaction !? anybody...

Hello, I have the below table: A B C D E F G H I J K L x y z 1 2 3 4 5 6 7 8 9 c b d 2 3 4 5 6 7 8 9 2 I need to transpose as follows:

Hi, I don't know whether it is possible. Still I am asking the experts. My requirement is this. In a blank worksheet, if anything is typed in a cell, it...

How to add same names in the numeral count in the next sheet,find the below i have copied.. Sheet 1 S \ No Facility Name Vendor Name 1 CDC - 1 SLS 2 CDC -...

I'm concatenating two columns in an excel data file. The formula works, but won't replicate in the column to subsequent rows, all it will do is copy. I'm...

Dear all, Happy New Year! I used the following formula to display week number:- ="WEEK " & WEEKNUM(NOW(),1) Today is 2010-01-04 (4th Jan 2010) and the...

hello, i am trying to set up a budget sheet in excel. is there any way to set excel so that a cell will change colors or do some type of alert when it has hit...

I have a worksheet with each month listed on the columns. I have each row totaled out, and wish to total expenditures for the month. But when I do, I get a...

I teach at a suburban St. Louis high school in which students login using Novell. In the past, we were able to go to the program file and in properties add...

Hello, I am trying to design an excel workbook for my class that will automatically copy scores from various subjects(8 subt.)and paste them in another. Let...

when I execute a sort, each time the dialog box opens, it gets incrementally larger each time. After I have done 3 or 4 sorts, the dialog box is full...