I have a formula and the range in the formula is A1:A1000 and I want this to stay A1:A1000 even if I delte rows. Is this possible? I thought I read somethign...

an author name is not displayed in properties, I believe someone may have selected to hide it. As it is financial calculations I now need to see who authored...

I am trying to use a hyperlink in a text box to link to another worksheet in the same file. Does anyone know how and if this can be done? Any help is much...

I have around three sheets between the source and the output sheets. In other words, lets take an "EXAMPLE" as: 1. Sheet1!A1 is the source cell; 2. Sheet2!B1...

Recently I have noticed a problem in my excel documents. I have core 2 quad, 2.40 GHz , 4 GB RAM, 32 bit vista ultimate with SP1, 500 GB eSATA HDD running...

Hello, I have two Worksheets Sheet1 and Sheet2. I want to automatically fill up the Sheet2 with the records copied from the Sheet1 with selected...

Hi All, Happy New Year to everyone!!! Hey, I have a question: i have a spreadsheet in which several cells in one row have the sameinformation, let's say...

Sir, i have a data table like this A B Pattern MRP BANARAS 1278.00 BANARAS 1389.00 BANARAS 756.00 BANARAS 1389.00 BNG...

I have a matrix (see below) and would like to format the row yellow and the column red and where they INTERSECT orange. I am able to get the row and column...

I had a peice of software that made use of excel within its own parameters. I deleted the software but now ehen I start Excel, the startup is looking for...

I use the MAX command for negative numbers when a positive number is subtracted from zero or empty cells, returning a negative number, but that does not work...

This may sound strange... I have a form I need to fill in regularly in excel. However it exists as front page portrait second page (2nd worksheet)...

Hello Excel(lent) users, I am stuck with a challenge, which I wanted to share with you ! I am managing multiple projects, which are executed by multiple...

this is second time i am asking same question, for about last week i am not able to view the messages later than 23rd Dec, please reply me on my mail ...

I need some code to hide a sheet if a date has past. Date is in Cell a1 of sheet 1 and sheet 2 needs to be very hidden. I would rather not use regular...

I'm trying to set the format for a group of cells based on the value of another cell - lets say A1 my formula is =$A$1 = "F" format 00.0000 applies to...

I'm trying to do a multiple lookup - my table looks like the following Date Type 12 24 36 12/1/2008 1 .10 .12 ...

hello, There seems to be a problem with hyperlinks not working when i protect the sheet so no user can change data (even the hyperlink). I am not using any...

I have a file as below Which has Store Numbers in Coloum A - all the store that are in coloum A are unique - no duplicate store numbers - but every store will...