Forum Discussion

reidpdb's avatar
reidpdb
Copper Contributor
Jul 27, 2023

Excel Autofill Formatting/Options

Hello,

 

For some reason, Excel is not giving me autofill options after I click and drag cells, i.e. the drop down menu in the bottom right corner of a cell that usually appears after I click and drag cells no longer appears.  As a result, I am unable to specify whether I'd like to copy the cells, fill the series, fill without formatting, etc.  For reference I am using Excel for Mac version 16.74.

 

Any ideas of what the matter could be are greatly appreciated!  

 

Thanks

excel
Excel on Mac

1 Reply

  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor
    Jul 28, 2023

    reidpdb 

    In Excel for Mac, the autofill options might not always appear by default. However, you can still access them through other methods. Here are a few things you can try to enable the autofill options:

    1. Drag and Fill with Command Key: Click and drag the cells as you normally would to fill them, but this time, hold down the "Command" key while dragging. This should trigger the autofill options to appear.
    2. Right-Click Menu: After you have dragged the cells to fill them, right-click on the selected cells. In the context menu that appears, you should see the autofill options, such as "Fill Series," "Fill Formatting Only," etc.
    3. Using the Ribbon: Another way to access the autofill options is through the Ribbon. Select the cells you want to fill, and then go to the "Home" tab on the Excel Ribbon. Look for the "Editing" group, and you should see the autofill options in buttons like "Fill," "Series," "Formatting Only," etc.

    If the autofill options are still not showing up, try restarting Excel or your Mac and see if that resolves the issue. Additionally, make sure you are using a version of Excel that supports this feature, as some older versions might not have it. Excel for Mac version 16.74 should have the autofill options, but it's always a good idea to keep your software up-to-date to avoid any potential bugs or issues.

    My knowledge of this topic is limited, but since no one has answered it for at least one day or more, I entered your question in various AI. The text and the steps are the result of various AI's put together.

     

    My answers are voluntary and without guarantee!

     

    Hope this will help you.

Resources