How can i link to an entire worksheet in another workbook, so that changes may be made to the worksheet ragerdless of which workbook containing the sheet is...

I am inporting external data (market securities data) from website. The "external data range properties" has a tab to auto-update the data in minutes. But I...

i need to get a cell to change colour when markers are reached eg a qualification lasts 12 months. what i want to do is have the cell change from yellow to...

I work in quality and I am trying to wite a certificate that will indicate if a product does not meet specifications. The problem that I have is the product...

I work in quality and I am trying to wite a certificate that will indicate if a product does not meet specifications. The problem that I have is the product...

Thanks in advance for any help on this. I'm using Excel 2003. (I have Access 2003 as well if that would help, make this easy.) I have a simple template that...

If cell figure is less than 287 use a. if cell figure is between 287.01 & 400 use b if cell figure is over 400.01 use c. where a, b, & c are formula, should I...

I really need help with EXCEL. Here is what I want to do! I want it set up so I can have my credit card balances in one column, the APR in column 2, column 3...

Can I Split Text into two lines within one Cell

I'm sure this is simple, but it's driving me crazy. I have a column of HOURS WORKED and a column of HOURLY RATES. I need a formula for the GROSS WAGES column...

Has anyone created a Contingency Fee Template for consulting work?

The arrows displayed by Tools / Formula Auditing / Trace Precedents/ Dependents point to a formula's precedent/dependent cells in the SAME SHEET as the formula...

In Excel 2002 10.2614.2625, I have a worksheet in which I never want to see the contents of any cell underlined, ever. To implement this, I can press Ctrl-A...

You gotta admit, Excel 2002 10.2614.2625's Formula Auditing is the greatest thing since, well, the reintroduction of unsliced bread. However, I have workbooks...

Whereas: - Excel can (wonderfully) auto-resize a cell whose contents are wider than its width. - But auto-resize doesn't work on a cell that is merged with...

It's easy to invalidate an Excel 2002 workbook, putting it into a recalc-required state, yet Excel fails to do it. For example, I have a worksheet with...

I am new to exel and have no clue as how to enter a formula or which one to use. I want to put in a big directory with dept. names and their new extensions....

which ms office program do I need to purchase to get spell check in ms word? office basic or office professional? Thanks so much. Not sure why this put me in...

I am new at this so please bear with me. I am using Excel XP. In my column I have a list of numbers. Some are formatted as text and some are formatted at...

You may want to check here for more information. http://www.cpearson.com/Excel/menus.htm In the future, please post more information in the message...