Excel Formula Help Please

ELMasry · 06-06-2007, 11:55 AM

How to make a cell obsolete???

I need to calculate, taking the figure from only one cell to be applied to the entire row.

There is a way, can not remember it, I think I need to enter $ sign

Your help is greatly appreciated.

Thanks

**Glaswegian** · 06-06-2007, 01:16 PM

Hi

I think you mean absolute references. This is where the cell reference remains the same throughout, even after a copy and paste or drag and fill operation. You are correct about the use of the dollar sign. There are really 3 choices:

$A$1 this is an absolute row and absolute column reference and will not change
A$1 this is an absolute row but relative column reference - the column will change
$A1 this is an absolute column but relative row reference - the row will change.

Hope that helps.

ELMasry · 06-06-2007, 02:10 PM

Quote:

Originally Posted by Glaswegian

Hi
YES Thanks

I think you mean absolute references. This is where the cell reference remains the same throughout, even after a copy and paste or drag and fill operation. You are correct about the use of the dollar sign. There are really 3 choices:

$A$1 this is an absolute row and absolute column reference and will not change
A$1 this is an absolute row but relative column reference - the column will change
$A1 this is an absolute column but relative row reference - the row will change.

Hope that helps.

JackGopher · 11-21-2008, 11:21 AM

What you need is absolute and relative referencing, you can find more about it over here:

gvshan · 11-24-2008, 09:54 PM

Dear Friends, I need help to solve excel-problem-XP(OS)

If I enter a value(1-9) in a cell of saved file, it automatically change as 0 or blank.(Not only the particular file, it happends in all excell file created since one year back)

Please help me to solve this problem.

Thanks in advance

Shanmugan V

06-06-2007, 11:55 AM	#1 (permalink)
ELMasry Registered User Join Date: Mar 2007 Posts: 85 OS: win xp pro	Excel Formula Help Please How to make a cell obsolete??? I need to calculate, taking the figure from only one cell to be applied to the entire row. There is a way, can not remember it, I think I need to enter $ sign Your help is greatly appreciated. Thanks

06-06-2007, 01:16 PM	#2 (permalink)
Glaswegian Moderator/ Rangemaster TSF Academy; Analyst, Security Team; Oor Wullie; TSF Surgeon and Resident Comic Join Date: Sep 2005 Location: Glasgow Posts: 25,505 OS: Win XP Pro SP3 / Win 7 Pro My System Blog Entries: 10	Re: Excel Formula Help Please Hi I think you mean absolute references. This is where the cell reference remains the same throughout, even after a copy and paste or drag and fill operation. You are correct about the use of the dollar sign. There are really 3 choices: $A$1 this is an absolute row and absolute column reference and will not change A$1 this is an absolute row but relative column reference - the column will change $A1 this is an absolute column but relative row reference - the row will change. Hope that helps. __________________ Iain - Defender of the Haggis and all things Scottish. I don't help by PM - post in the Forums. PC Safety & Security::PC running a bit slow?::Donate::Photographers Corner

11-21-2008, 11:21 AM	#4 (permalink)
JackGopher Registered User Join Date: Jan 2008 Posts: 5 OS: Vista	Re: Excel Formula Help Please What you need is absolute and relative referencing, you can find more about it over here: Last edited by Glaswegian; 11-22-2008 at 08:46 AM. Reason: Removed advertising link

11-24-2008, 09:54 PM	#5 (permalink)
gvshan Registered User Join Date: Nov 2008 Posts: 1 OS: xp	Re: Excel Formula Help Please Dear Friends, I need help to solve excel-problem-XP(OS) If I enter a value(1-9) in a cell of saved file, it automatically change as 0 or blank.(Not only the particular file, it happends in all excell file created since one year back) Please help me to solve this problem. Thanks in advance Shanmugan V