How can I calculate the difference between two dates?

680

---

How do I lock in my title row and keep it visible while I scroll down to see the rest of my data?

615

---

How can I format a worksheet to have alternating green and white rows like a "greenbar" report?

533

---

Where can I find some really good information on how excel treats year 2000 dates? I need simple (and that is what u guys provide)?

566

---

How can I make the screen stop flashing during macro execution?

656

---

When I enter a value, it appears with two decimal places. For example, when I enter 154 it shows up as 1.54. Whats wrong?

571

---

Is it possible to determine the day of the week for a particular date?

551

---

Can I see a list of the colorindex and the corresponding color?

606

---

I wish to count the number of cells in a col or row that have a value > 0. How is this done? The zero is displayed in the cells. Count() will only ignore a blank cell?

578

---

Is there a way to allow the use of autofilter on a protected worksheet?

625

---

How can I prevent hyperlinks from appearing when I type an email address?

575

---

Is there a function that returns the name of the worksheet?

680

---

I am using ms excel and I want to import a spreadsheet into ms powerpoint without the gridlines. Is this possible?

599

---

What are excel spreadsheet number formats?

675

---

I am using excel, and want to create a line graph with the data on my spreadsheet, ranging from january to december. However, I don not want the empty cells to berepresented as zeroes in the line graph. Is there a way to graph all months without displaying the zero values?

577

---