I have both first name and surname in one cell, ie. Mary Byrne and want to sort my list of names by surname first. Is it possible to divide the cells into...

Unfortunately, we have observed that the conditional format feature appears to limit the choices for borders. For example, the user can select both solid...

17 worksheets transferring data to a summary page complete! Except for.... I have J2 who's contents are 200, and I have L2 who's contents are 0 (until...

Can you get 07 excell to talk?

From an HTML page I would like to add a link to an EXCEL file but on a specific worksheet? I s this possible? Thanks

i have data in columns g3 to g11,h3to h11,i3 to i11 in column j i need to total from all the other columns

Recent documents are not displayed. When I go into Excel Options to Display - "Show this number of recent documents" 'the number field is grayed out. How...

For example, In excel in cells A2 to A56 I've got words in them, I wanted to copy all the cells in column A to B in same order,but when the word "check" is...

I have a spreadsheet of employees' names, #'s, etc. I need to delete rows and add new names, etc. The formulas says =+SUM(A73+1) for example. I can't just...

The following converts latitude co-ordinates in cell A3 from NN:NN:NN and N:NN:NN format to N.NN format. (A similar formulae does the same for longitude...

How can I get a column of figures to add up automatically?

All the help options give directions on how to look for duplicates within a worksheet, but I want to check for all duplicates in all the worksheets within...

I am working on an assignment where we have to use pivot tables. The question I have to answer is "Are their any times of day when purchases are most...

Hi i am trying to paste formulas from one column to another, however when I do a paste - special - formulas it seems in increment the cell references with...

How can I lock the formulas in a woorksheet but allow others to add information in it without deleting the formulas. (Excel Office 2007...

Hello, Using Word 2007 and Windows 7. I want to always have my documents set up in the normal, typical manner: The paper size is 8.5x11 The margins are all...

I have created a spreadsheet for our employees to use that includes several text boxes for their narrative. The spreadsheet has many macro functions and...

Hi, I'm using a sumproduct formula to ascertain the number of times that a value between 0 and 1 occurs in column A (range A3:A26), where the adjacent cell in...

I am not familiar with Excel and need to know how to set up a payroll spreadsheet that uses a formula to update payroll weekly