LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Adjusting Referances


Before whenever I would move a Cell to another place, all cells that
used it in a formula would adjust. Now, for some reason the cells arn't
adjusting, did I undo an option and is there anyway to fix this?

Exampe incase you don't understand.
A1= 15
A2= A1*3

Before if I would move A1 to A3 then A2 would change automatically to
A3*3. Now A2 is staying at A1*3.


--
Lanza52
------------------------------------------------------------------------
Lanza52's Profile: http://www.excelforum.com/member.php...o&userid=36316
View this thread: http://www.excelforum.com/showthread...hreadid=573599

 
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
adjusting columns in multiple worksheets of workbook with one step carole Excel Discussion (Misc queries) 2 July 8th 06 03:07 AM
adjusting decimal place in protected worksheet in excel 2007 Mike Excel Worksheet Functions 2 June 17th 06 02:34 PM
Row height is not adjusting after activating Merge Cells & Wrap Te MHPDallas Excel Worksheet Functions 1 April 9th 05 12:32 AM
Excel hangs computer when adjusting margins Graeme Excel Discussion (Misc queries) 1 April 6th 05 07:26 AM
excel template for calculating trial balances and adjusting entri. yesterdaytoday11 Excel Worksheet Functions 2 November 24th 04 06:25 PM


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

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

About Us

"It's about Microsoft Excel"