We have an estimating sheet for jobs. On anther book we have a parts pricelist. Is there a way to have the estimating sheet look up the part price by inputing...

Using the SUBSTITUTE function in Excel 2002, can i have more than one substitute in a column ?? I have an excel sheet, e.g. Col A i want to change everytime...

Hi and Hello Everybody, A very Good Morning to all the members. Please help me in solving my query.... The requirement is to take just the contents/data (i.e....

Can anyone recommend a good free online excel course? Please give internet address of the course. Thanks. Jenny

When I try to edit my excel document, the buttons on the task bar are shaded and I cannot cut, paste, etc. Why?

How can I multiply 7feet and 6ft 8in using Excel? I have 7' in A1 column, 6' 8" in B1 column. When I did =a1 * b1, I get #VALUE! I stretched the column...

Hi There is probably a very simple answer to this but I can't find it... I have designed a spreadsheet were the end user can select the data to view by...

hello, is there a way to configure a cell such that when clicked, a small window will pop-up, displaying a picture of your...

Hi, HELP! I am trying to create a worksheet to balance our household income and expenses. What I need to do is take a running total from one worksheet and have...

i have a list of tex/numbers and i need excel to delete and duplicates i will have in the worksheet. Im new so i might need detailled instructions

When i am printing my paper i am looking how it goes automatique on my hard disk in a file?? grts Peter from belgium

Hi! I am new to the forum, and I love playing with Excel so I might be a frequent visitor here, I dont know. :) I have this nifty Excel problem that I cannot...

I cannot figure out how to have totals from one sheet to be recorded in a cell on a different sheet in the same workbook

A colleague runs the car-park lottery for our organisation. She uses an Excel spreadsheet witha round 1500 entries. The sheet identifies each staff member by...

I've made a pivot table that shows me the number of duplicate entries on an address list. Now I want to delete the duplicates. When I drill down, it puts the...

What measurement system do these numbers refer to, i.e. inches, cm,mm that can be set in format? Thanks. Frank

I really need help wiht this problem . How do you alter a column size? I did it once where the cursor would just move it bigger or smaller. I want to know how...

I've got my "Recent" settings set at nine but only FOUR will ever show up. Does anybody know why? Also, when I do a Search and open and update an Excell file,...

If my data starts in cell B5 but the number of columns and/or rows can vary, how do I write a print macro to cover that if there are no gaps in the data i.e....

how can i put TWO LINES OF NUMBERS IN ONE CELL