I am trying to copy a worksheet but it seems that that option (as well as all but two options) are locked...I need to copy this worksheet only so I can email...

I typed in function =LEN(H2) and when I hit return, the function appears in the cell but the result does not appear.

I have an excel document with an autofilter turned on in the row above my data. I'm running Office 2007 but always save my docs in 97-2003 compatible format...

I need to figure out how to solve the following situation: A B C 1 4 2 5 f(7) 3 6 f(9) If Ax+Bx6 then plug that number into a function...

I need a subtotal for 5 different products in a table Column A will have 5 different colors (Blue, Green, Red, Black) Column L has a price/rate Column O - R...

Here is my problem: I want to write a formula in cell P11 that includes information from columns B,E,F, and G. In column B, I have two types of data (ZN and...

I am trying to figure out how to add a percentage to, say column A and have the figure appear in column B. i.e. If column A cell 1 has 37 and I want to type...

I just converted from Office 2004 for Mac to Office 2007 on a PC. On the Mac, + signs would automatically be entered as I clicked cells after entering =...

I have an Excel cell with an address in, and each line of the address is separated by a non-printing character. I need to replace it so that I can use the...

I have done this a thousand times in Excel 2003 but cannot get it to work in 2007. I have imported data into my spreadsheet from an external query using the...

Is there a way to have a VLOOKUP function look up a value in 2 columns instead of 1 column? Lookup_Value = looking up 1 cell that has a number in it. (Got...

Hi, I need to search a range of cells for a piece of text, not an exact match of the whole string, but just some words. Then, when it finds that I need to...

I am trying to summarize a bunch of entries with a pivot table but can't seem to get the format that I am looking to attain. I have copied out all my item...

G'day everyone Need a little help with the following please. Using 97-2003 format =COUNTIF(AND('2008'!$B5:$B2004,"Eastern...

My question is: Am I able to password protect "Sheet 2" within a workbook so a user cannot even open Sheet 2, and then require them to email their supervisor...

How to how to set up formula with more than 1 result For example A 1 50 2 100 3 50 4 150

Hi All, I was hoping someone may be able to offer some practical advice regarding conditional formatting of cell colour. I have made a sheet to track the...

I am trying to apply some conditional formatting to pages in a workbook...however the 'conditional formatting' is 'de-selected' on the drop down, so i'm not...

G'day there One & All, I'm back again, and (surprise, surprise) I'm stumped and asking for a hand. I have a fairly simple worksheet containing hours...

I have a spreadsheet in which costs are color coded. I would like to put a function on place that will sum the costs based on the color of the text. Can...