Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-21-2023, 09:17 AM
MC147 MC147 is offline Excel copy or fill series not working as it used to. Windows 10 Excel copy or fill series not working as it used to. Office 2021
Advanced Beginner
Excel copy or fill series not working as it used to.
 
Join Date: Feb 2022
Posts: 34
MC147 is on a distinguished road
Default Excel copy or fill series not working as it used to.

I am using Office 365 Excel and the copy or fill series does not seem to work as it used to. Previously, if I dragged a cell containing a number, downwards, a little popup box (Autofill Options) would appear giving me the option to copy the value or fill the series. This does not appear, instead there is a box saying Quick Analysis - see attachment.
It just copies the same value to the cells below. If I press CTRL whilst dragging, it does fill the series with incrementing values as determined by the Fill Series value specified in the Menu bar.


On the web, it says ensure that the File/Options/Advanced enable Fill Handle and Cell Drag and Drop is checked. It is.

Has there been a change to how this works, or is there some other option that I have inadvertently changed?
Attached Images
File Type: jpg Capture.JPG (10.9 KB, 11 views)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Copy a series of text, while track the changes in the new document GoddessEneri Word 4 07-31-2021 06:23 AM
Copy Gradient Fill in PowerPoint 2013 Chris Waller PowerPoint 2 07-27-2018 11:18 AM
Excel copy or fill series not working as it used to. how to fill a series of dates mcd23379 Excel 1 03-30-2016 10:19 PM
Excel Chart Edit Series w/ VBA KyBob2 Excel Programming 0 12-16-2015 12:16 PM
Excel copy or fill series not working as it used to. Fill Series alamorchgirl Excel 1 08-15-2011 10:05 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:55 AM.


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