Excell. Relative cell or not.

  Bass99 18:26 26 Jun 04
Locked

In the 70s I had a spreadsheet that would allow me to copy celss or range of cells with formulas refering to other cells, and I had the option of relative or non reletive copy.
i.e Cell B1 had a formula of [= A1] and I copied this to cell B2 I would of been given the option of relative, i.e. cell B2 [= A2] Or non relative
i.e. cell B2 [= A1].
Over the years I have looked in Excell, current version Office 2000, and failed to find how to do.
Now this would be a very usefull tool. I am aware that using $ makes a reference non relative, but with a long formula, and number of cell to copy over number of relative and non relative to edit each cell with $ then remove it is not practable. Help please?

  VoG II 18:37 26 Jun 04

If I understand, you want the ability to switch relative to absolute or vice versa. Excel does not have a built in method for doing this. But ASAPUtilities does click here

Select the range of cells that you want to change, click on the ASAPUtilities Menu, Formula, Change reference style.

This has saved me countless hours of effort.

This thread is now locked and can not be replied to.

The Legend of Zelda Breath of the Wild review: Five hours with Zelda on the Nintendo Switch

1995-2015: How technology has changed the world in 20 years

How the painting-like animated sequences in A Monster Calls were created by Glassworks Barcelona

The 22 best Safari extensions | Best Safari plugins: Improve Apple's Safari web browser with these…