General

Formula in 07
Need a formula. Column 1 (type) Column 2 (wk) a 77 b 77 c 78 d 80 e 80 blank 81 I would like the formula to come back... 9 Feb 2010 05:06

Changing grey column headings from numbers back to capital letters
Somehow I have managed to change the grey column headings from capital letters to numbers and I don't know how to change them back. Please help Thanks Will ... 4 Feb 2010 11:09

Excel Doesn't Open
Office Pro 2003 Excel Windows Vista Home Premium Often, especially after a reboot when I click on an excel to open it I get a message: Windows Cannot find (the filename) Make sure you typed the name correctly and then try again". The installer for Office opens and starts running but stops and opens a new excel... 18 Feb 2010 10:36

Changing Multipule Graph's Source Data
So I have 8 graphs on one tab that reference data on another. I highlighted both tabs, click copy, and I was hoping the graph's source data would move itself to the new data tab, but no dice. They are still referencing the original tab. Is there a way to move all the new graph's source data to the new tab all at... 3 Feb 2010 18:34

How do I edit my chart in 2007??
I have been using Excel XP and I would enter my data, get my chart and paste it into word. Then I would be able to edit the chart. Now, when I get it into word, and click to edit, it wants to edit data and opens my excel file. In the past, I've been able to edit the chart in word. Basically, I just want to ... 3 Feb 2010 17:26

Excel 2007 table formatting
Hi - I can't figure out why this is happening - but some of our Excel 2007 worksheets with Format table options applied --- the formatting gets messed up when rows are added or columns are sorted???? If I insert a row from a dark blue row - it adds a dark blue row???? Is this a problem with sheets upgraded from... 3 Feb 2010 17:26

refer to whole column
Hi! How do I refer to a whole column by a number of a cell? For example, if a number of a certain cell is 1, then the column will be A:A. If a number of a cell is 3, the column will be C:C. I will be using the result as the [Sum_Range] in a SUMIF function. Thank you very much! ... 3 Feb 2010 16:18

Pivot Table Pareto Chart ... How?
Excel2003 ... Can I use a Pivot Table to create a Pareto Pivot Chart? My Pivot Table Data looks ok, but the sort is not correct for a Pareto Chart??? Can I do this? ... How? ... Thanks ... Kha ... 3 Feb 2010 15:10

formatting change after pasting into a new weoksheet
Hi everybody, When I copy a worksheet to another one cell background colors change and also I lose the formatting ? any suggestions what might cause this? -- Best regards, Edward ... 3 Feb 2010 15:10

How can you paste a spreadsheet from Excel without gridlines?
I have a similar question in Excel 2007/PowerPoint 2007. I'm copying a mixed sheet (chart with separate numeric tables). I want to copy the sheet in Excel exactly as laid out into Power Point, just not the gridlines. I used to be able to do this in prior versions. I copy, then Edit|Paste Special. I need to ... 3 Feb 2010 16:18