How to copy formula as absolute
Closed
Joe
-
15 Nov 2010 à 01:43
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 15 Nov 2010 à 06:20
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 15 Nov 2010 à 06:20
Related:
- How to copy formula as absolute
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Number to words in excel formula - Guide
- Credit summation formula - Guide
- Formula to calculate vat in excel - Guide
- Formula spreadsheet definition - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
15 Nov 2010 à 06:20
15 Nov 2010 à 06:20
It is not clear why you want that. it will give the same value in all the 100 cells.
anyhow you can name the formula
suppose some numbers are entered in A1 and B1
for example the formula is
=$B$1+$A$1
now click insert menu and click name-define
in define window
under "names in workbook" give a name e.g
formula1
now in reference window at the bottom in the same window type or copy
=$B$1+$A$1
click ok
suppose you want to copy this from J1 to J30 highlight these cells
type
formula1
hit control+shift+enter
is this what you want.
anyhow you can name the formula
suppose some numbers are entered in A1 and B1
for example the formula is
=$B$1+$A$1
now click insert menu and click name-define
in define window
under "names in workbook" give a name e.g
formula1
now in reference window at the bottom in the same window type or copy
=$B$1+$A$1
click ok
suppose you want to copy this from J1 to J30 highlight these cells
type
formula1
hit control+shift+enter
is this what you want.
