Removing $$ Reference in cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a worksheet filled with cells that contain formulas with $ signs i.e.
reference to particular cells.

Is it possible to select all cells and remove the absolute reference at one
shot, instead of manually fixing each formula in each cell? Tks a lot! -
Castor
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reference the same cell based on tab name 1
Filling formulas with specific cell references remaining the same 1
Excel VBA 1
Can an incrementing value in a cell point to different worksheets? 3
Reference different lines in the same cell 1
How to Auto Reference Worksheet Tab ID's in Formulas? 9
Locking a cell reference in a formula 1
Conditional Formatting 3

Back
Top