absolute cell reference A spreadsheet cell reference that does no

's Computer Specifications

help

's Computer Specifications

Well help with what!?

Enter your question in the Body of the message instead of the Subject line.
Your question got cut off!!

Do you just want to use an absolute reference? If so enter $'s around your
cell reference:

$A$1 -or- $A1 -or- A$1

A $ preceding the column reference ensures the column letter doesn't change.
A $ preceding the row reference ensures the row number doesn't change.

Does that help?
--
Regards,
Dave

"help" wrote:

> help

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Absolute cell reference will not remain absolute.	Mike K	Microsoft Excel Worksheet Functions	1	8th Oct 2008 07:12 PM
Making cell reference absolute makes cell format text		Microsoft Excel Worksheet Functions	2	22nd Sep 2006 04:47 PM
How can I do an Absolute Cell Reference but non Absolute Cell Pais	=?Utf-8?B?Sm9obg==?=	Microsoft Excel Programming	1	22nd Jul 2005 07:28 PM
How can I do an Absolute Cell Reference but non Absolute Cell Pais	=?Utf-8?B?Sm9obg==?=	Microsoft Excel Programming	0	22nd Jul 2005 06:23 PM
really, really absolute cell reference?	Rick	Microsoft Excel Worksheet Functions	2	25th Sep 2003 10:34 PM