LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 193
Default Cell Referencing

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Referencing Last Cell jlo Excel Worksheet Functions 8 September 4th 08 09:06 PM
Cell Referencing Tim Caldwell[_2_] Excel Discussion (Misc queries) 3 July 3rd 07 08:56 PM
Referencing Cell Next To Today's Date Cell Docktondad Excel Discussion (Misc queries) 5 May 16th 07 10:25 PM
Cell Referencing Bismark Excel Worksheet Functions 4 December 13th 06 09:36 PM
Referencing to other cell hadoka Excel Discussion (Misc queries) 1 November 27th 06 08:07 AM


All times are GMT +1. The time now is 10:39 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"