How can I fix formula cells in bulk? Excel -


so have table of cells in excel have loads of formulas referencing cells above it.

i want create copy of table below it, , keep formulas , values same. when creating formulas didn't put $ fix each cell. dont want go each cell , add $ cells before pasting.

is there way can highlight cells , bulk fix cells being referenced?

thanks in advance, let me know if im not being clear.

the best way use vba:

put in module, select range of cells, , run it.

sub abslt()     dim rng range     each rng in selection         if rng.hasformula            rng.formula = application.convertformula(rng.formula, xla1, xla1, xlabsolute)         end if     next rng end sub 

it convert references absolute references.


Comments

Popular posts from this blog

java - nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet Hibernate+SpringMVC -

sql - Postgresql tables exists, but getting "relation does not exist" when querying -

asp.net mvc - breakpoint on javascript in CSHTML? -