Prev: Excel Jululian
Next: Audit Trail
From: Pete on 10 Apr 2010 04:10
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
From: Mike H on 10 Apr 2010 04:29
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.


"Pete" wrote:

> 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
 | 
Pages: 1
Prev: Excel Jululian
Next: Audit Trail