Is there a way to alphabetize the worksheets without moving (click & drag) them manually?

Does anyone know how to send the value of cell in worksheet one to a cell in a different worksheet in the same workbook? Thanks

I am using a SUMPRODUCT and one of my arguments is ....*('Main Log'!P3:P1000=Not Null)*... It is giving me an #NAME? error. I want it to count all the cells...

Hi folks, My spreadsheet is done! Woohoo, thank you very much to everyone who has offered help and advice to me over the past few days. However, one last...

Here are the steps that you will want to do: 1) Insert a column to the right of the column in question (we will make the assumption that the column in...

Hello, I'd like to add the word "Draft" in the center of every page, but how do you; 1) add this text in the background 2) and have this text be transparent so...

Thanks to everyone who helped me before, your suggestions were perfect. I just need a little more help and i'll be finished. I now have a spreadsheet that...

Is there a functional way to flip a column of data. So that if I have 10 numbers in range A1:A10, the number in cell A10 would then be at the top of the...

Hi all, I wonder how I can update a cell every 60 seconds or so. Is there a specific function to set the specific period? Thanks, Gus

Im trying to limit what can be entered in a cell using data validation. I want no text allowed and no comma's in a range of cells. I have been trying to use...

I cannot gain access to the Header/Footer, page setup or print preveiw sections on my excel worksheet. When I navigate to one of these area I get the...

I am a relative newbie to Excel. I have created an extensive sheet filled with data. I have copied subsets of data to a series of other sheets rather...

How do I get an entire column to round to the nearest one hundredh dollar?

I am working on a database where I need to take a monthly production figure add it to the running total for the year and multiply everything below $67,800 by...

Is it possible to use the sumif function and have the condition returned based on a date criteria? Translation: I have a group of cells that I would like to...

This way you get the "count" of cars of one specification, don't you? But ho do I get e.g. the cumulative value of all these cars, if there is an additional...

I am using a SUMPRODUCT and one of my arguments is .....*('Main Log'!P3:P1000=Not Null)*... It is giving me an #NAME? error. I want the function to count all...

I am trying to simplify a formula on a worksheet that sums the same cell on 50 other worksheets all within the same workbook. I can do it the long way of...

The default fill colour is yellow, I want to change this to red rather than button down and select red each time I use fill colour.

Running Windows 2000 with Office 97 and Symantec 8.0, we are receivng the following error: Your changes could not be saved to 'xxxx.xls', but were sved to a...