I copied some cells from a sheet to a new sheet. The cells I copied contained some numbers and dates. Some of the numbers had a dollar sign on them. I wanted...

Hi , I am trying to set upo a spreadsheet to track stock market purchases,dividends etc. I have date columns, however I would like to be able to color code...

Hi, I'm trying to sum the total of the same cell in six adjacent spreadsheets (named 'July' to 'December') onto a separate summary sheet at the end. My...

In some spreadsheets I need to enter a phrase in many cells. Is it possible to pre-program the function keys with a phrase so it may be inserted into a...

i want to make conditional dropdown like this if a1="x" dropdown in a2 should be US,CANADA,MEXICO if a1="y" dropdown in a2 should be ...

Hi, I have a main worksheet, columns A to H (8 columns), about 1000 rows and growing. I insert rows and change data regularly and I want to update another...

I am taking practice tests. ColB contains text (the correct answers). ColC contains text (my practice answers). I want the cells in ColC to turn green if...

I need to expand and collapse ROWS, I want main info seen and rows below it collapsed so I can expand as needed, How do i do that?? i keep trying but it's...

Hi, I have put together a spreadsheet to find codes, states, descriptions. It finds the data by dates. Columns a Dates, Codes, States, Descriptions If I...

Hello, What does the logical expression (A1A2A3A4) return ? How is the expression evaluated ? I've tried various numbers in A1....A4, but cannot seem to...

Dear sir, I have an excel formular which involve 3 cells, A1, B1 and C1. The value in cell of A1, B1 and C1 is 2,6 & 2. I place this formular, IF(OR(A1=B1,...

I am using Microsoft's site to read the posts in NG. (http://www.microsoft.com/office/community). There is a minor problem which wastes time. After reading a...

he following formula: =IF(B3=8,IF(B7=16,(B6*12/16)+(3*B8)+(4*B9)+(8*B10),(IF(B7=24,(B6*12/24)+(3*B8)+(4*B9)+(B10*8),0)))) Works well if the first condition...

Dear sir, I set an excel formula =NOW() which show the time. However, the time will only refresh when I hit the formula. My question is that is there...

I have 35 worksheets; one w/s for each volunteer Each w/s has the exact document to capture the number of hours a volunteers works and the type of service...

Please help ...I'm going mad... How do I enter a formula to add colums together? Thanks in advance

I need to create a worksheet that will have several names in a column. Next to the names I will have three more columns that are requirements or goals that...

Hello, Should have stayed with Excel '97 But, have upgraded to Excel 2007. Here's a weird one: I have a word in a cell. Nothing unusual; starts with a...

How do I find out my hard drive size.

Hi -- is it possible to do conditional formatting that would highlight the first time a customer hits $1,000,000 or above and then in another column look for...