General

Number formula (2007)
How can I delete Number/Format Code that are created by mistake? I created a number of Format Codes to achieve what I want in e.g., Y Axis. 2003 had an option of 'Delete' but I don't see it in 2007. Thx ... 23 Feb 2010 12:27

Insert file name in header without showing extension
I know how to get the filename into a header/footer. Is there any way to get the filename in the header/footer WITHOUT showing the filename extension? ... 23 Feb 2010 15:53

Excel 2007 Copy Worksheet Problem
I like to "move or copy" from a right click on the worksheet tab. My problem is that all my open "books" do not show up on the drop-down menu. Always worked fine until recently. Now I can still copy to a new book - but none of my other open books show up so I can not copy or move to an existing book. Is there any w... 23 Feb 2010 12:27

Multiple IF and a sum
Hi, I have a formula with multiple if statements that result in an amount due or an NA. Is it possible to add an under or overpayment into this? G2 would be the result of amount paid - amount due. The Five (5)'s are options chosen from a dropdown list which then looks at T2, a subtotal of products. =IF(... 23 Feb 2010 12:27

Subtotal To Include Item Description On Subtotal Line
I am using the subtotal feature on data listed below. I have requested a subtotal of item qty at every change in the item number. The subtotal line will return the item number and the subtotaled qty. This is good. However, I wold also like the item description to be included on the subtotal line. How do I... 23 Feb 2010 15:53

Conditional formating
I wonder if anyone can help me please I'm trying to set up conditional formatting for a cell based on data in range of cells for example: cell D9 should turn red if E9:Q9 contains letter a I have been trying using find but no luck so far. thanks -- Afia ... 23 Feb 2010 11:19

In Excel 2007, how to send picture behind text
I m trying to put my image behind text, does anyone how to do it. Thanks Tausif A. Haider ... 23 Feb 2010 11:19

Data Validation message increases file size?
I just opened a template file (1,174 KB) and used data validation to show a short message when a single cell is selected and when I saved the file it's size had increased to 2,925 KB. My message is not worth this strange increase in file size. Has anyone any idea why this has happened? ... 23 Feb 2010 10:11

How to change decimals of length in feet to feet and inchs
For example how to convert 13.25' to 13'-3" ? ... 23 Feb 2010 10:11

Inserting an Object from a different workbook - please help
Hi, I'm inserting an object file (Pivot Chart) from a different workbook which has many worksheets. When I locate the workbook in assigning the object it will only insert the first worksheet tab of that workbook. Is there a way to insert an object from the 3rd worksheet tab (as an example; PivotChart3) i... 23 Feb 2010 07:57