Excel 2003 - the subject says it all. But, after using the filter, you could click in a cell and the status line would tell you how many records were in the...

hello Is there any way to convert the following numbers to show as hrs:min without manually insterting a colon? e.g.15:45 ...

Hi. Similar to a poster earlier today, I'm creating a Pivot Table based on data in an Access database. When I link to my database, in the Select Table...

I need to put a sub command into the object section for a formula to work. However i am not understanding what or where the object or object section is. Does...

Is there a way to change the names of worksheets automatically? I use Excel 2007 for invoicing, but it's really a pain to have to rename each sheet to...

Hi, We have an employee that's color blind. I have been trying to search a way to customize the color scheme in Excel 2007 as the limited color of black,...

How can I create a calculation from the total of a count of a field on a pivot table? Example: I need to calculate the number of employees for each process...

When I double click on an Excel link, the excel application (container) opens, but the file does not load. Status bar show "Ready" and nothing further...

I could use some help, If any one knows where I could find a "daily Outside Sales Call Report" it would be a GREAT help. Thanks

Hi, I created this worksheet in Office XP. Now I have a new computer with WindowsXP pro and Office 2003. This worksheet opens fine on other machines but on...

D1 has the following conditional formatting applied to it =AND(D60,E60) What I am trying to do is colour D1 if both D6 & E6 are populated with 0. Thia...

Hi all This relates to MSProject, but the same problem happens in excel in this instance. I have 2 global modules. I also have a userform with custom jpegs...

Hi, We've got a batch programme that created a few hundred reports (person specific numbers in same layout). All it does is take numbers from a table and...

I have several cells that are aligned "Top" with wrap text turned on that run past the border of the cell. The Format/AutoFit Row Height command does not...

I'm lookung for the formula to use that if I was under one date on one page, to look what date im under go to the 2nd page, find that date then count the text...

I want to select all sheets in a workbook, insert a column, and put a formula in that column. It works fine when doing it manually, but if I try to have a...

Hello, I have an Excel spreadsheet built on Excel 2000. I have set sheet protection with password, and I have some unprotected cells with drop down menu...

how to place non printable watermark in excel sheet

I have a list of email address that are separated by the symbol. I want to separte each address to its own row

How do I calcualte histogram of yearly dataset and compute the probability of distribution of the data. For example: Year Value 1920 311.9 1921 ...