Cell Referencing


P

Pete

Hi,

When I refer to a cell in another spreadsheet, the cell reference always
automatically defaults to absolute (e.g. $A$4). In most cases I don't want
the $ so have to manually remove them which is time consuming.

Is there a way to change the options in Excel 2003 so that the $'s don't
appear ?

Thanks
 
Ad

Advertisements

M

Mike H

Peter,

The default is for relative referencing when the formula refers to a
worksheet in the 'same' workbook and absolute referencing if the formula
refers to a sheet in a 'different' workbook and I'm not aware of any way of
changing this behavour.

When you say 'in another spreadsheet' do you really mean in another workbook?

The quick way to change the reference style is to tap F4 repeatedly until
you get the reference style you want.
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 

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

Top