#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default dragging formulas

when I drag a formula down, it does not grab the next row's value correctly.
It shows the result from the original cell dragged. What can I do?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,560
Default dragging formulas

what is the formula that you are trying to drag, does it have $ in it?

"Davo1" wrote:

when I drag a formula down, it does not grab the next row's value correctly.
It shows the result from the original cell dragged. What can I do?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,722
Default dragging formulas

In addition to David's suggestion, are you in manual calculation mode? Try
pressing F9.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Davo1" wrote:

when I drag a formula down, it does not grab the next row's value correctly.
It shows the result from the original cell dragged. What can I do?

Reply
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
Dragging formulas Ben Greenwood Excel Worksheet Functions 7 July 12th 07 06:04 PM
Dragging Formulas [email protected] Excel Discussion (Misc queries) 1 March 8th 07 11:40 PM
Dragging Formulas J.D. Webster Excel Discussion (Misc queries) 1 February 6th 06 09:32 PM
Dragging formulas matt Excel Worksheet Functions 1 December 12th 04 12:27 AM
Dragging formulas matt Excel Worksheet Functions 0 December 11th 04 11:51 PM


All times are GMT +1. The time now is 08:24 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"