Hi, I have a main worksheet, columns A to H (8 columns), about 1000 rows and growing. I insert rows and change data regularly and I want to update another...

Hi, I looked, honest. The HELP was no help, either. Gosh, things were sure simpler with the earlier versions. Anyway, how do I go about setting the...

Hi I Forget Password Sheet.How Can I Recavery ? I Use Excel 2007

I have set up an inventory of the chemicals we keep on an excel spreadsheet... What I want to be able to do is to double-click on a chemical (ie double-click...

I am new to using drop down lists. I have created a spread sheet that I use for construction disbursing. I want to have page that lists all of my vendors...

i am using excel a lot at the moment but am primarily self taught. I have managed to lock down my merge and centre button so all I can see is a shadow of the...

Have a strange issue. Sometimes I am unable to link two worksheets together. In some cases when I enter either "+" or "=" in the cell and then click on the...

I need to make columns that are separated by a line. Is there a function on the toolbar that will do this?

how do i do it.

I have a list of addresses and would like to sum the number of addresses in each state. There is a column with the 2 letter state abbreviation for each...

I have a large spreadsheet and in one of the columns part of the data, some of the rows has a \t. Once I search on the \t, I don't know how to copy the...

I want to do any of following thing (1) On day2 when I open excel sheet, data that i entered on day1 in perticular sheet (say sheet1) should be hidden...

I have posted on this in the Word.applications group several times over several years with no resolution. I am wondering if the MVPs lurking in the Excel...

http://www.contextures.com/xlDataVal01.html -- Don Guillett Microsoft MVP Excel SalesAid Software "Don Guillett"...

Just installed Microsoft Office and have Excel 2003. Trying to email an Excel spreadsheet as an attachment, but message "no profiles have been created. to...

i want to make conditional dropdown like this if a1="x" dropdown in a2 should be US,CANADA,MEXICO if a1="y" dropdown in a2 should be ...

I can't open my orginal worksheet with data.It has been lost and showw message "Excel recovered your formulas and cell values, but some data may have been...

How to do formatting of cells automatically by writing Macros when the data is extracted from any tool to excel

the formatting seems to have gone awry but I hope you can still figure out what I mean....

Hi guys I hope this is simple. I have had a hunt around as I'm sure it has been answered before but my search concept is off the mark... Anyway I'm putting...