How can I get excel to accept an entry like "5+5" without the leading equals sign as a formula? I have done this is the past but can not remember how.?

555

---

All of a sudden a number of my excel 2000 files have become read-only?

581

---

Hey! Excel used to have letters to indicate the columns. Now, all of a sudden, there are numbers for the columns?

549

---

I have a price list stored in a worksheet, and I need to increase all prices by 5 percent. Can I do this without reentering all the prices?

615

---

How can I protect an excel file (and associated code) from unauthorized copying and/or create time limited functionality?

560

---

Can I change the color of the worksheet tabs in my workbook?

598

---

Can I ask my user for confirmation before executing the macro?

638

---

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

548

---

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

542

---

How to change the sheet tab color of excel spreadsheets?

645

---

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

648

---

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?

569

---

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?

588

---

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

631

---