Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-09-2015, 05:28 PM
KerryOn KerryOn is offline Wierd... "cell" started auto filling with data from other cells I double click on.  How stop it?! Windows 8 Wierd... "cell" started auto filling with data from other cells I double click on.  How stop it?! Office 2013
Novice
Wierd... "cell" started auto filling with data from other cells I double click on.  How stop it?!
 
Join Date: Jul 2015
Posts: 3
KerryOn is on a distinguished road
Question Wierd... "cell" started auto filling with data from other cells I double click on. How stop it?!

I've attached a screen print of my excel spreadsheet of recipe ingredients for a liqueur. In the ss there is a cell that automatically fills when I double click on another cell. This just started happening so I presume I did something but I can't figure out what!!



In Example1, cell O6 "zest peel" is a result of double clicking on H7. In Example2 I double clicked on J7. In Example3 I double clicked H11.

There is no formula in cell O6.... the cell seems to be just floating there and shows up white when I highlight the column.

So what is going on and how can I get it to stop?

I have excel 2013 on Windows 8.1.
Thanks!!
Attached Files
File Type: docx ExcelforumQ_July2015.docx (265.1 KB, 10 views)
Reply With Quote
  #2  
Old 07-13-2015, 09:16 AM
gebobs gebobs is offline Wierd... "cell" started auto filling with data from other cells I double click on.  How stop it?! Windows 7 64bit Wierd... "cell" started auto filling with data from other cells I double click on.  How stop it?! Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Attach the actual sheet.
Reply With Quote
  #3  
Old 08-10-2015, 08:41 PM
KerryOn KerryOn is offline Wierd... "cell" started auto filling with data from other cells I double click on.  How stop it?! Windows 8 Wierd... "cell" started auto filling with data from other cells I double click on.  How stop it?! Office 2013
Novice
Wierd... "cell" started auto filling with data from other cells I double click on.  How stop it?!
 
Join Date: Jul 2015
Posts: 3
KerryOn is on a distinguished road
Default

geBob...sorry I didn't get back to you... seems to have resolved itself. Thanks.
Reply With Quote
Reply

Tags
auto-fill, formula, functions

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Wierd... "cell" started auto filling with data from other cells I double click on.  How stop it?! matching data from one work sheet to another, then auto filling missing cell information timomaha Excel 1 09-12-2014 07:51 AM
Wierd "script code" in a downloaded .doc file CNBarnes Word 2 10-18-2012 02:07 AM
'Linking' entered information to other "cells" from an original "cell" in MS Word Wade Word 6 09-03-2012 05:22 PM
Wierd symbols inplace of "space", "indentation" etc aka.bhagvanji Word 5 02-16-2012 11:50 AM
Can I stop the right click "move here" feature? BillAnderson PowerPoint 0 04-16-2011 02:42 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:08 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft