Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #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
  #2  
Old 01-21-2023, 11:26 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

Ok, solved this myself.
Must have unchecked the "Show Paste Options button" in the Advanced Options, Cut, Copy and Paste section.
Now back working again.
Reply With Quote
  #3  
Old 01-22-2023, 03:44 PM
Guessed's Avatar
Guessed Guessed 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 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 3,932
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

You can Right Click and Drag to see the Autofill options too.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote
  #4  
Old 01-22-2023, 04:34 PM
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

Guessed,

Thanks for that, just tried and it does work, but probably don't need that now, as I have rechecked the "Show Paste Options button".
Reply With Quote
Reply

Thread Tools
Display Modes


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 03:03 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