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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
How to lock one cell in formula?
|
Thread Tools | |
Display Modes | |
|
|