Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-11-2017, 10:11 PM
ArviLaanemets ArviLaanemets is offline Autofill in columns, interrupted Windows 8 Autofill in columns, interrupted Office 2016
Expert
 
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default


Have you a table defined? And you have some formula in column like ="service"?

When yes, then autofill is switched off whenever something different is inserted into this column - which is logical as Excel doesn't know how to behave after that. And the only advice I can give is to change the formula in this way, that it returns all wanted values, and then copy it to whole column. I.e. don't use entered values and formulas in same column - when you need to enter something manually, add a column and enter manual values there.

Btw. when you manage somehow to make the autofill to work again, then probably your different entry is written ower with formula.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Side view: Color of summary with formular interrupted Mojo99 Project 5 10-07-2016 09:11 AM
Combo Box and AutoFill samrosen Word VBA 5 08-03-2016 05:12 AM
Creating AutoFill form - AutoFill information depending on a selection. RyanHarper Word 3 06-15-2015 01:01 PM
Autofill Stacybug1 Excel 2 01-28-2015 01:04 PM
Autofill in columns, interrupted Autofill Automation Parkiee1981 Excel 4 03-15-2013 01:24 PM

Other Forums: Access Forums

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


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