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

643

---

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

633

---

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

619

---

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

700

---

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?

627

---

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?

777

---

Excel uses for the indirect and address functions or formulas?

651

---

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

720

---

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

626

---

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

702

---

How can users spot the difference between two similar documents?

660

---

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

669

---

What is the procedure for creating a hanging indent?

640

---

How are pdf documents edited in a word?

624

---

How to add footnote and endnote in a word?

598

---