LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
No Name
 
Posts: n/a
Default copying cell formula newbie.

Hi,
I added a formual to a cell, which just multiplies a a different cell by 0.90. Now when I use the mouse to copy
mouse clicking and dragging it to all the other cells below it remembers the first cell amount even though it has
updated the cell number.
It works properly on other spreadsheets without any problem.What am I doing wrong ?
for example
cell a6 = 100 (a1*0.90)
cell b6 = 100 (b1*0.90)
even though a1 and a2 contain different values.

I hope I have explained it well enough for any one to help me.

Thank You.


 
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
Copying a formula to column using a value from a particular cell effnbee Excel Discussion (Misc queries) 2 February 20th 07 10:18 AM
copying formula to another cell dmack Excel Discussion (Misc queries) 4 January 11th 07 05:33 PM
How do I keep one cell constant in a formula even when copying excel rookie Excel Discussion (Misc queries) 2 April 26th 06 02:23 PM
Newbie question: Matching data/2 wkshts copying info over dperry11273 Excel Worksheet Functions 2 July 26th 05 06:39 AM
Formula for copying a sequence for every 8th cell JBSAND1001 Excel Worksheet Functions 3 January 2nd 05 07:07 PM


All times are GMT +1. The time now is 05:52 PM.

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"