I have a drop down list, I want it to select the choice when the first letter is typed in. How can I do that? I just need the dropdown to ensure there are no...

Hi, i am just starting up a small business and was wondering if anyone could guide me the correct way of having control of the suppliers and their payment...

When I use the "Cell Border" button on the toolbar to put borders around selected cells, is there a way I can change the color/type of the border lines (for...

If I have two columns, Column A which has Dates and Column B which has numerical values for that date. And I have several dates that I need to take that...

I have the following question When i have a sheet with the following data: cell A1 1 cell A2 2 cell A3 3 cell A4 =sum(A1:A3) == 6

How can I format an excel worksheet to draw a border around a range of cells that a) contain a unique value in one column b) only where a value in another...

I have a worksheet where I need the cells to be a square. Is there a way to do this? Or should I specify same width and heigth so as to obtain a...

Hi, I have the following data: Sheet1 Sheet2 53446 Query+, 00053353446 53447 ...

We have a user using MS Office 2003 SP3 (Windows XP), with the File Format Convertor installed for Office 2007 files. When he opens an Excel 2007 .xlsx file,...

I have a schedule workbook with the days of the week listed as sheets, Mon-Sun. I want to have another sheet that displays half of today’s schedule and...

Does anyone have any suggestions on how to retrieve the first value after the first ";"? On following example, I would like to retrieve 427,75 value, and...

Hi I would like to ignore cells which reflect #n/a and consider cells with a value from 0 .... , here is my current formula ...

I have a hyperlink in Excel for a folder on our server. When I click on the hyperlink in brings up the two viewing panes. The left side shows all the other...

Hi I was wondering if anyone could help me a problem, I have created an Expenditure sheet showing my monthly bills. I have placed a calender Object on...

Is there a facility in Excel 2007 to KEEP duplicate records? I can find ways of removing them through remove duplicates and advanced filtering but I want to...

Hi. I need some help setting a formula for the following: Info on Sheet1 Operation Item A Item B Item C 1.Cut 10 min 12 min 15...

hi all Hope someone can help! I'm using these 2 formulas:- =-(SUMPRODUCT(('Actuals YTD'!$A$2:$A$630=3014111)*('Actuals...

I want to create a macro that will insert a blank row beneath the current row and will then copy the contents of the current row to the inserted row. I can...

Dear friends, I want to create an Invoice format on sheet 1, where I want to entry one by one invoice and also I want store the data of each invoice on sheet...

I click Edit and then links... to change the source of links but I can not change it as the tab color becomes dim /gray.