| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Locking a cell reference in a formula
I have a worksheet that has formulas built within 6 columns. I want to drag
the formula in each column down 100 rows, but as I am calculating a date that references only 1 cell (A1) when I drag the formula, it picks up A2, A3, A4 etc. as the formula progresses down the column. Is there a way to lock the cell reference to A1 so that when I drag the formula down the column, that cell reference doesn't change? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Locking a cell reference in a formula
Add a $ sign in front of the cell reference.
Example $A1 Locks the column but allows the rows to change A$1 locks the row but allows the column to change $A$1 locks both the row and the column (locks it to a specific cell.) This is what you are asking. "odonnjk" wrote: I have a worksheet that has formulas built within 6 columns. I want to drag the formula in each column down 100 rows, but as I am calculating a date that references only 1 cell (A1) when I drag the formula, it picks up A2, A3, A4 etc. as the formula progresses down the column. Is there a way to lock the cell reference to A1 so that when I drag the formula down the column, that cell reference doesn't change? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Locking cell to protect the formula | Excel Discussion (Misc queries) | |||
| locking formula in cells in without locking whole sheet | Excel Discussion (Misc queries) | |||
| locking formula cell references | Excel Worksheet Functions | |||
| Locking A Formula In A Cell | Excel Worksheet Functions | |||
| Cell Reference locking | Excel Discussion (Misc queries) | |||
Linear Mode
