Check attached excel sheet Test.xlsx
- Goto G12 -> it's an empty cell, doesn't contain any formula
- Now go to E12 - fill in a number - say 15000.
- Go to F12 - fill in another number - say 1550.
As soon as you press tab or enter after filling the number at F12, G12 automatically gets populated with the formula copied from above & shows the value.
I am very happy that this happens but it doesn't happen in other excel worksheets I have seen. So how to activate this feature on a column?
Last edited by ExcelBoy90; 07-01-2020 at 02:42 AM.
No, not happening here.
Excel 2016 (Windows) 32 bit
Sheet: Sheet2
This usually happens if the range has been converted to a table.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Hmm, it still happens for me if I download it back from my post & test it.
If it were because of range converted to table, it will happen for you also, right?
It's also not some property turned on globally for me because if I create new data like this, it doesn't happen. It only happens in this sheet or if I copy/paste this range of cells into another sheet.
I am running of Office Home & Student 2016.
Where did you get the sheet from? The range is not a table - I checked that.
It's from a sheet I made with lots of columns. I noticed this behaviour in only one of the 25 columns in that sheet. So I copied that column & the 2 columns it refers to a fresh sheet & I could still repro the behaviour. The other columns in the original sheet with similar formulas don't behave this way.
Last edited by AliGW; 07-01-2020 at 03:46 AM. Reason: Please don't quote unnecessarily!
I vaguely remember a similar thread some time ago, but can't find it now. It will have to remain a mystery, I think.
Administrative Note:
Please don't quote whole posts, especially when you are responding to the one immediately preceding your own - it's just clutter. It's OK to quote if you are responding to a post out of sequence, but limit quoted content to a few relevant lines that makes clear to whom and what you are responding. Thanks!
For normal conversational replies, try using the QUICK REPLY box below or the REPLY button instead of REPLY WITH QUOTE.
The other suggestion is is the original file xls or xlsm. If so some vba code could be populating the cell. But in saving the example as xlsx you remove the vba
I wondered that, but the comments in post #3 seem to negate it.
It's xlsx. There is no VBA code in it.Originally Posted by davsth
Ok in 2010 so can not speak for your version in file_options_advanced_editing options there is an extend data range formats and formulas, I suspect this it ticked
Attachment 685040
Well spotted, Dave - that makes the difference here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks