How to copy formula as absolute
Closed
Joe
-
Nov 15, 2010 at 01:43 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 15, 2010 at 06:20 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Nov 15, 2010 at 06:20 AM
Related:
- How to copy formula as absolute
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Number to words in excel formula - Guide
- Excel grade formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Credit summation formula - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Nov 15, 2010 at 06:20 AM
Nov 15, 2010 at 06:20 AM
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.
