Hi all, I am currently using Excel 2002 and have a workbook with multiple worksheets. Is it possible to force the workbook to open on the same page every time...

Hi, I want to set C1=to B1*A1 unless A1 is alpha instead of numeric in that case I then want C1=A1. -- Thanks, Ben

I'm trying to use a macro to rotate a picture, but for some reason the rotate command under 'format' is greyed out. Any ideas anyone?. If I draw a...

can I lock merged cells?

Suddenly the formatting in a long-established spreadsheet I have has gone crazy. Where text is too large fort a box and would normally flow over into the empty...

Hello, I hope someone can help. I created a simple pivot table on a sheet in a workbook that provides information when a particular city and state...

I have a spreadsheet with one column stating a date in the format xx/yy/zzzz - e.g. 22/07/2004. I want to show the month/year only and so in the next column I...

MS-EXCEL 2000 HELP implies that I can create a 3-D reference for a range (not just a cell). Is this possible? I’ve tried everything, but keep getting...

I a trying to figure out why when I type 11 and automatically converts it to .11, if I type 11. it will stay 11,if I change all the cells to text then back...

Hi, I am using multiple monitors and would like to to have a seperate workbook open on either monitor so that i can look at either monitor and see...

Dear All I am thinking of new ways to improve on my excel report which consists mainly of charts and numbers/tables... Does anyone has a great idea which will...

Hi! Im using the following formula to get a countif =COUNTIF(INDEX('Ê1'!4:4;1;$AI$2):INDEX('Ê1'!4:4;1;$AI$3);0) which is filling down to the cell 1000 The AI2...

Hi, Could you help me with this please? I have a workbook with 5 sheets in it, the data in each sheet changes throughout the week and the number of entries...

Hi, Question: is it possible to 'lock' specific cells in a sheet? e.g. I don't want to be able to change specific functions on specific places. Thanx in...

I might be dreaming, but I remember from somewhere that Excel had a function that could automatically split up worksheets based on information in a list. For...

Dear All, I have a data set and have drawn a histogram. The histogram shape resembles a negative exponential distribution. How can I find the parameters...

Hi guys, In the last few days, ive posted some questions with some success, but not being able to completely work though my problem. Given that I...

I have a Word five row list I would like to import into Excel in a five column list. Every hundred items or so their is a new heading. What do I do?

On a PivotTable you can use the "autocalc" button to get total calculations such as sum, average, and count. Is it possible to get it to do other things like...