I used Freeze Panes when inputing data on a spreadsheet. When I "unfreeze" the panes, nothing happens. It is as if the "freeze panes" is still in use. Any...

Product - Excel 2007 I have an issue in the time frame it takes to type in information into my worksheet after creating multiple conditional formats for...

Below is my formula. The formula turns up an error when it finds text instead of numbers. I would like it to return 1 when it finds text instead of...

hello, I am trying to only obtain the value of a cell and not the formula. For example: lets say that in A1 I have : ...

Sometimes the "Fill Series" functionality does not work as expected. On most sheets I can type numbers 1, 2, 3 and select them and fill down with numbers...

I am using combining two time cells into one cell along with a separator of " - ". Source Cell J4 - "11:00 am" Source Cell K4 - "11:30 am" Target Cell C4 -...

I have three worksheets going on with dynamic content between all three worksheets (data is entered on sheet and then shows up on another sheet). I manually...

I have three worksheets going on with dynamic content between all three worksheets (data is entered on sheet and then shows up on another sheet). I manually...

Hi all I Have "8.4" entered in cell B2. Now, i want to create an IF function in B3 that needs to check that B2 is between 7.2 and 7.8, thus, including 7.2...

Need help. Importing data from older program, presenting data as: 3/26/2009 3:56:00 PM Need help converting to Excel format for calculations, etc. Thanks!

How do I get Excel to make a sound when a value is entered into a cell? I'm using a digital caliper to enter data into Excel via a USB port. I don't want...

I have a basic understanding of Pivot Tables and have played around with a few to further my understanding. One thing I'm not clear on is how to use one in a...

Can you add more then one item in the following...

I need to do this for an assignment and it isn't working. For example, I have 2 rows of numbers, each row about 15 columns in length and each number has it's...

I have a workbook here with multiple tabs. If I update one tab by changing the number in it, it does not calculate automatically without hitting the F2. ...

In the future, please ask your question in the body of the posting, not in the title - the system does not permit responses to posts with no body text. Hope...

Is it possible to have excel impose certain formatting on files that you open? We get reports from a 3rd party, and they recently started providing them in...

Is there a way to link cells such that when the formatting of the parent cell changes (color change, italic etc.), the formatting of the linked cell changes...

I want to create a summary of data and have a solid formula (using such formula's as match, lookup, and vlookup). Unfortunately, when I try to drag these...

Is there a way to copy and paste formulas from Excel 2003 to Excel 2007? Right now the data copied from 2003 is pasted as values (all the formulas are...