Forum Discussion

LizzMason's avatar
LizzMason
Copper Contributor
Mar 03, 2021

Fill without formatting (Microsoft 365)

There used to be an option where you could FILL WITHOUT FORMATTING in previous versions of Excel. What happened to that radio button drop-down, and how can I get it back?   This is the option I'm l...
excel
office 365
Tea_Tea's avatar
Tea_Tea
Copper Contributor
Apr 30, 2023

LizzMason 

  1. Open Excel > File > Options.
  2. In the Excel Options window, click General and uncheck "Show Quick Analysis options on selection" located under "User Interface options".
  3. Click OK.
  4. Once done, restart the Excel app and check if the Autofill icon will show up correctly.
  5. If it does not show up correctly, go to File > Options > Advanced > Cut, copy, and paste and tick the box beside "Show Paste Options button when content is pasted". This option also affects the Autofill Icon, it should always be enabled.

Resources