General

counting
hello i have cells from A1:A3 and A6:A10 which contain text strings. now what should be the formula if i want to count these cells ? (answer should be 8) what should also be the formula change if the cells would contain numbers ? ... 21 Apr 2010 16:44

Orientation of text in an autoshape
In Excel 2003, I have a rectangle that is tall and thin. I want to put some text inside it, but I need the text oriented 90 degrees in the rectangle. Is this possible? If so, how? Thanks, Tonso ... 22 Apr 2010 08:16

Tables and Custom views in Excel 2007
I'm having the same problem, sans the ODBC feeds. I have a large table that has to be a table, because of the source data. It is summarized in a worksheet with approx. 65 columns and I want to be able to view it in various portions. The easiest way to do it would be with views. The only solution I've found so far is to... 21 Apr 2010 15:42

allow merging cells in protected sheet
When I protect the sheet, the Merge & Center button is greyed out. I need to allow users to merge and center cells in a protected sheet (these cells are not locked). -- Doug ... 10 May 2010 19:56

Formula shows as text
I'm trying to write a formula into a cell and it will work in some, but in other cells it makes the formula show in the cell as if I am just typing text. Why is it doing this?! Please help! ... 21 Apr 2010 15:42

look up formula
I have two customers with two different list of procedures on one report. cell A1 has a drop down list of the customers when a certain customer is chosen How do I write a formula so that when I choose Cutomer 1 only their list of procedures show up in a drop down box in my procedure area. ... 21 Apr 2010 15:42

Sum of two groups
I have the following formula attempting to get some totals by aging category. =SUMPRODUCT(--(B2:B1096=T12),--(AA2:AA1096=U11),Q2:Q1096) T12 = a 2 digit code of text. Example CL U11 = >540 Q2:Q1096 = represents the dollars I want to sum I think my problem is the aging dates range from 24 to 3293 days. I wan... 21 Apr 2010 14:40

I can't see Grand total rows even though the option's switchedon
Hi Rachael It all depends upon what you have set up as your column Items. Some things are not additive, and displaying a Grand Total at the end of the Row would be meaningless. Can you post a small sample of your source data, and then say what fields you have allocated to what area of your PT. -- Regards ... 21 Apr 2010 14:40

I can't see Grand total rows even though the option's switched on
Can anyone help ? I am creating a Pivot table in Excel 2007 and want to see Totals for columns and rows. I have checked both boxes in Options / Totals & Filters/Grand Totals and also in Design /Grand Totals / On for Rows & Columns but it is only displaying the Grand Total for columns. What am I doing wrong... 21 Apr 2010 14:40

How do I cancel/delete read only for a worksheet?
I don't even know how ready only got put on in the first place. ... 21 Apr 2010 14:40