I would like to know if the tabs for the different sheets can be in color and if that is possible, how is it done? Thanks.

Hi, Does anyone know how to discount an irregular stream of cash flows? Example, Over the next five years I expect to receive payments which will be irregular...

How do I make an IF statement to leave out the dashes if the value is 0. Example: =CONCATENATE(IF(D12=0,"",D12),+"-" (a dash if there is a value... no dash if...

Hi! I am an elementary school teacher trying to calculate grades in an Excel worksheet. Following is a sample of my efforts: Points...

Is there a formula that can be entered into a cell that automatically pulls whatever is typed into a different cell? Example: I want to enter a name into...

On opening a excel workbook, is it possible to have a default way of opening? For example, I want to display a certain worksheet everytime on opening that...

I have 2 lists of names and I need to compare to see which names from List #1 appear in List #2. Could someone tell me how to do this? With Much...

Can you help me find it? Thank you .

Will a SUMIF worksheet function work when the sum_range is dynamic depending on user selection? The user can choose period 1 thru 12 or YTD. If not, what...

Hi, I have a problem with an excel file. It workbook protected and the person who did it is not here anymore. Is there a way I can find the password? Thanks...

I've have a tables of targets with the director responsible for them against each target (1 director per target), with an autofilter for the table. On a...

Is there an easy way to find what cells have formulas that refer to another worksheet. I'm trying to Edit-Links-Change Source to the current worksheet, but am...

You can cheat, and do a double-loopback sort of thing........set up a macro to do a "Goto" that is about 50 cells below your target cell and about 20 cells to...

Help! I have a large Excel file that has 4 versions open at the same time. I only want one version. Please advise how to get rid of the other three.

I have two sheets in an excel workbook, one named 'Main Audits' and the second named report spreadsheet. What I want to do is to put the month number into...

I have an Excel worksheet where a lot of the cells have formulas that refer to cells in another workbook. (The reference in the formula for each cell is...

Hello: I have a list that looks like this: APPLE APPLE APPLE BANANA BANANA PEAR

I need to set up a worksheet that will calculate the hours work for each day. I enter start, lunch, and end and excel gives total. EX: Start Lunch End ...

I'm not sure what you mean by 'highlight rows', then freeze. Highlighting a row doesn't have anything to do with selecting a row to freeze. Two ways to do...

I am trying to use excel to create what I need for my weddding invitation list. My fiance wants a count of how many people from her side of the family are...