A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How to lock one cell in formula?



 
 
Thread Tools Display Modes
  #1  
Old December 23rd, 2003, 07:12 PM
external usenet poster
 
Posts: n/a
Default How to lock one cell in formula?

There are two types of cell references -- relative and
absolute. When a relative cell address in a formula is
copied, the actual address is modified to reflect the new
position on the worksheet. If an absolute cell address in
a formula is copied, it is NOT changed. An absolute cell
address uses dollar signs ($) to 'fix' the cell address.
For example, =$a$1+b2 when copied down to another range of
cells, it would yield =$a$1+c2

Check Help for "absolute" cell reference.

GL and HH


-----Original Message-----
Using MS Office 97 Excel

I am trying to do a simple add/subtraction formula and

can't make it do
what I need.

I want to have one primary cell that won't change (ie: a1

will be
today's date, 12/23/03, and will have a list of dates on

column B, and
in column C, want to show how many days between 12/23

(wont' change) and
each line...

When I do a simple formula =a1+B2... and copy it down, a1

also changes
...

Any help? thanks
OS


---
Message posted from http://www.ExcelForum.com/

.

  #2  
Old December 23rd, 2003, 08:11 PM
Gord Dibben
external usenet poster
 
Posts: n/a
Default How to lock one cell in formula?

Orlando

Add dollar($) signs to make it Absolute Reference.

=$A$1 + B1

$A1.......absolute column, relative row
A$1.......relative column, absolute row
$A$1......absolute row and column
A1........relative row and column

You can select the cell reference(A1) in the formula bar and hit F4 to cycle
through the combinations.

See Help on cell reference to learn more.

Gord Dibben Excel MVP

On Tue, 23 Dec 2003 11:40:07 -0600, orlando
wrote:

Using MS Office 97 Excel

I am trying to do a simple add/subtraction formula and can't make it do
what I need.

I want to have one primary cell that won't change (ie: a1 will be
today's date, 12/23/03, and will have a list of dates on column B, and
in column C, want to show how many days between 12/23(wont' change) and
each line...

When I do a simple formula =a1+B2... and copy it down, a1 also changes
...

Any help? thanks
OS


---
Message posted from http://www.ExcelForum.com/


  #3  
Old December 26th, 2003, 02:22 PM
orlando
external usenet poster
 
Posts: n/a
Default How to lock one cell in formula?

That was easy. thanks


---
Message posted from http://www.ExcelForum.com/

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:36 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.