Disable Flash fill under file > options > advanced > editing options > 'automatically flash fill' This is a known issue with Excel! 4 Put Grid Lines on Excel for Mac You like to use gridlines when working with spreadsheets, but you’ve received an Excel spreadsheet without gridlines from someone else.
Excel for Office 365 Excel 2019 Excel 2016 Flash Fill automatically fills your data when it senses a pattern. To use it, see. However, if you're on a Windows device, you may need to enable this feature before using it. Click File Options. Click the Advanced in the left pane, and ensure that the Automatically Flash Fill box is checked. Close and restart Excel.
![Fill Fill](/uploads/1/2/5/5/125542900/514700970.png)
Start Flash Fill manually If you know that Flash Fill is enabled, but still doesn't work, then you can start it manually by clicking Data Flash Fill or Home Flash Fill. You can also press Ctrl+E on the keyboard. Need more help? You can always ask an expert in the, get support in the, or suggest a new feature or improvement on.