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

612

---

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

602

---

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"))?

588

---

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

643

---

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?

594

---

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?

718

---

Excel uses for the indirect and address functions or formulas?

616

---

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

681

---

How can the user accept or reject track changes in ms word?

588

---

Is there any shortcut to move the insertion point to the beginning of the documents?

664

---

How can users spot the difference between two similar documents?

618

---

Is it possible to insert video into a word document? If yes how can the users insert video into a word file?

634

---

What is the procedure for creating a hanging indent?

607

---

How are pdf documents edited in a word?

594

---

How to add footnote and endnote in a word?

557

---