View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Igor Igor is offline
external usenet poster
 
Posts: 20
Default Range of cells: Convert relative reference into absolute

Hello, everyone,

Is there a way to change simultaneously a whole range of cells that contain
the same relative reference into absolute references.

For example:

Convert the following relative references in the range of cells D56:AB56

=Sheet1!B1 (...) =Sheet1!Z1

Into:

= Sheet1!$B1 (...) Sheet1!$Z$1

But: All at the same time, not one by one.

I have to transpose a large amount of tables that have relative references
and I need to change these into absolute references. It would take me forever
to do this one by one.

Thanks for the help!

--

igor