How do you use if functions in excel?

588

---

How can I increase the number of rows or columns in a worksheet?

533

---

How can I protect formulas from being deleted or changed?

622

---

I have an excel file that I use every day at work. Some time ago, mysteriously, the file began opening two copies of itself every time I double-click the icon. If I closeone of the copies, both close. Any changes made to one copy show up in the other?

559

---

My question is when your working with multiple worksheets how do you transfer added figures from one worksheet to another without losing the total?

531

---

Is there a way to determine the last active column in a spreadsheet?

556

---

My stop recording toolbar has disappeared. How do I get it back?

559

---

I want to count the number of cells in a range that have a particular interior color. The countif function seems like the right kind of answer but how to I return thecolor of the interior for each cell in a range? I would like to do something like: =countif(b1:b10, cell("interior","red"))?

560

---

I have a column of numbers in the format 99999-99999. What is a simple macro to remove the dash?

559

---

I have a list of 3215 product names on a spreadsheet. Each resides in a single cell. I need to put each name in quotes. The names are all in one column?

536

---

I have created some clever formulas, and I don not want anyone else to see them. Is it possible to hide the formulas but display the results?

633

---

Excel uses for the indirect and address functions or formulas?

571

---

Somehow, my worksheet has external links to files that are no longer around. How can I delete the links?

635

---

What happened to the m: drive?

847

---

Exchange group policy notes, what should I do?

1125

---