General

Compound Reference
I have a spreadsheet that has 3 columns. I need to be able to make what I call a compound reference. It's really hard to explain but I need to do the following: ='Sheet A'!X(b1) where: The current sheet is Sheet B Sheet A is the sheet containing the cell needed X(b1) refers to column X of sheet A and th... 6 Jan 2010 09:48

printing i am getting this window "output file name"
... 6 Jan 2010 09:48

How do I recover an Excel document saved not saved as
I was working on an Excel document, deleting all of the info in the cells, when I inadvertently hit "save" instead of "save as". Thus wiping out all my info I wanted to keep. Is there a way to recover the document with my original saved info? ... 6 Jan 2010 09:48

Date list excluding weekends
If I have a column of dates (365 days) from Jan. 1 to Dec. 31, is there a way to delete all weekends without the long, manual way of doing it? Connie ... 6 Jan 2010 09:48

Sum
Hi, I have data as shown below. Col-A Col-B Col-C Col-D a 10 b b 15 d c 20 d 25 e 30 I need the sum of "b" and "d" values(15+25) in column D1(40). If I add the any letter of Col-A i... 6 Jan 2010 09:48

Shortcut key to 'Clear All'
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 ... 6 Jan 2010 09:48

Is 4th January 2010 = Week 2??
Dear all, Happy New Year! I am using the following formula to show week number ="WEEK " & WEEKNUM(NOW(),1) However I notice today 4th January 2010 turns out to be WEEK 2 and the correct WEEK number should be 1 instead. Do you think there is something wrong with the formula? Also how to show correct week... 28 Jan 2010 05:20

Alerts....
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 a maximun number. for example: i have a column for expendatures and a cell at the bottom is formulated to add it all up. i want to know if there is someway to se... 3 Jan 2010 19:23

Set a value in multiple cells based on a condition
I am trying to set a value in several cells when a single condition is true. For example, if A1 = B1, then I want to set all cells C3, D3, E3 and so on to a given value. For instance, when IF(OR(A1<0, B1<0) ... ), I want to set a bunch of cells to zero. (I realize I can put an IF in each of the target cells,... 3 Jan 2010 13:51

changing your printer settings for custom paper size ?
... 3 Jan 2010 01:55