| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel: 'always choose same cell' symbol for use in formulae
cannot find the symbol that you place after a selected cell in a formulae so
that when you write the formulae and then drag so the formulae is set for a number of cells, one cell with this special symbol is always the same i.e. constant |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel: 'always choose same cell' symbol for use in formulae
Enter the cell address, then press <F4 to make it constant. If you press
<F4 again, the column is constant, and if yiou press this again, the row number is constant. Else, type the address eg $A$1, $A1 or A$1 "dan" wrote: cannot find the symbol that you place after a selected cell in a formulae so that when you write the formulae and then drag so the formulae is set for a number of cells, one cell with this special symbol is always the same i.e. constant |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel sees cell formulas as constants, will not solve | Excel Worksheet Functions | |||
| Automatically Changing Cell Reference's when Pasting in Excel | Excel Discussion (Misc queries) | |||
| I want to use a formula in excel to highlight a cell 30 days prio | Excel Worksheet Functions | |||
| How can I populate an Excel cell based on the data in another cell | Excel Worksheet Functions | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Linear Mode
