Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old June 28th 05, 04:20 AM
Jeff Brown
 
Posts: n/a
Default Excel won't fill formulas

Hi,
When I create a formula in a cell, then use the fill handle to copy the
formula down a column, the formula uses the data from the original cells
referenced instead of the cells in the rows down from the original cell. And
the weird thing is, when I click on one of the filled cells, the formula
shows up correctly. Example, in Cell I2 I created CONCATENATE G2,H2 and
pulled down to fill down to row 52. Row 52 shows CONCATENATE G52,H52, but
the data is from cells G2 and H2. Strange.

  #2   Report Post  
Old June 28th 05, 05:00 AM
Anne Troy
 
Posts: n/a
Default

Doesn't sound strange to me at all, Jeff...that is, if you have Calculation
set to manual.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Jeff Brown" wrote in message
...
Hi,
When I create a formula in a cell, then use the fill handle to copy the
formula down a column, the formula uses the data from the original cells
referenced instead of the cells in the rows down from the original cell.

And
the weird thing is, when I click on one of the filled cells, the formula
shows up correctly. Example, in Cell I2 I created CONCATENATE G2,H2 and
pulled down to fill down to row 52. Row 52 shows CONCATENATE G52,H52, but
the data is from cells G2 and H2. Strange.



  #3   Report Post  
Old June 28th 05, 05:11 AM
Jeff Brown
 
Posts: n/a
Default

well, that did the trick. I wonder how that got switched? Never happened to
me before.
Thanks very much!
Jeff

"Anne Troy" wrote:

Doesn't sound strange to me at all, Jeff...that is, if you have Calculation
set to manual.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Jeff Brown" wrote in message
...
Hi,
When I create a formula in a cell, then use the fill handle to copy the
formula down a column, the formula uses the data from the original cells
referenced instead of the cells in the rows down from the original cell.

And
the weird thing is, when I click on one of the filled cells, the formula
shows up correctly. Example, in Cell I2 I created CONCATENATE G2,H2 and
pulled down to fill down to row 52. Row 52 shows CONCATENATE G52,H52, but
the data is from cells G2 and H2. Strange.




  #4   Report Post  
Old June 28th 05, 06:55 AM
Anne Troy
 
Posts: n/a
Default

You're welcome, Jeff!
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Jeff Brown" wrote in message
...
well, that did the trick. I wonder how that got switched? Never happened

to
me before.
Thanks very much!
Jeff

"Anne Troy" wrote:

Doesn't sound strange to me at all, Jeff...that is, if you have

Calculation
set to manual.
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"Jeff Brown" wrote in message
...
Hi,
When I create a formula in a cell, then use the fill handle to copy

the
formula down a column, the formula uses the data from the original

cells
referenced instead of the cells in the rows down from the original

cell.
And
the weird thing is, when I click on one of the filled cells, the

formula
shows up correctly. Example, in Cell I2 I created CONCATENATE G2,H2

and
pulled down to fill down to row 52. Row 52 shows CONCATENATE G52,H52,

but
the data is from cells G2 and H2. Strange.








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
How do I convert an excel worksheet to a fill in form? Terri Excel Discussion (Misc queries) 2 March 13th 05 03:26 PM
Excel Formulas albebach Excel Discussion (Misc queries) 1 February 2nd 05 09:52 PM
Excel 2002 - copying formulas across worksheets Greg Excel Discussion (Misc queries) 1 January 27th 05 10:45 PM
How do I fill down formulas so they iterate in intervals other th. picklet222 Excel Worksheet Functions 2 December 18th 04 01:23 PM
Identifying the Active Fill Color Steve Conary Excel Discussion (Misc queries) 3 December 9th 04 04:45 AM


All times are GMT +1. The time now is 01:26 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017