Can you tell me how I can put comments in my spreadsheet for instructions that pertain to a specific cell in microsoft excel?

546

---

Is there a way that I can close all spreadsheets in my excel file at once?

537

---

How to change the sheet tab color of excel spreadsheets?

643

---

Why does excel say my file has links, when I know it does not?

642

---

While entering a series of numbers I was manually entering a comma. Excel auto-formatted the field to accommodate the comma like 1,200. I erroneously entered12,00. Obviously the comma was placed in the incorrect position, but excel interpreted this as text. When I wrote my sum formula, the results were not as expected.how can this be avoided in the future?

585

---

When I open a workbook, excel asks if I want to update the links. I have looked everywhere, and I can not find any links in my formulas?

566

---

In visual basic, I can set the color of a cell with the .interior.colorindex property. How can I read the color of a cell before I change it?

586

---

How do I clear all formatting and cell contents from the cell in my spreadsheet?

627

---

Is there an easier way to change formula results to fixed values in microsoft excel? I usually copy the cells that I am working with and then use the paste specialcommand to past the permanent values over the original formulas?

572

---

Why do my scrollbars go to row 500 -- my data ends in cell e50?

570

---

Can I write a formula that returns the number of distinct entries in a range?

573

---

I create lots of graphs with excel. Unfortunately, the options to which excel defaults are not the ones I use most. Is there any way to change the graph defaults to theones I prefer?

540

---

Show excel toolbars on two rows?

631

---

I am converting from quatro pro to excel. What happened to my cell comments?

611

---

How to open a new copy of a excel file?

608

---