Right click menus not available in Excel 2007

Posted on 2012-08-21
Last Modified: 2012-08-24
Suddenly I have lost the right click menus in Excel 2007. For e.g if I type 1 2 3 in cells one below other, and I drag using the + sign in the cell corner, I should be getting Fill series option which is not there.
Question by:Advait Kawthalkar
    LVL 22

    Accepted Solution

    Go to Excel Options - Advanced. Under Editing Options make sure "Enable fill handle and cell drag and drop" is checked.

    LVL 12

    Expert Comment

    check if this helps.

    Referred link :
    LVL 85

    Expert Comment

    by:Rory Archibald
    In 2010 it's File-Options-Advanced section, check the 'Show paste options button when content is pasted'. I believe it is similar in 2007.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Deploying a Microsoft Access application in a Citrix environment is not difficult but takes a few steps. However, Citrix system people are often of little help, as they typically know next to nothing about Access. The script provided here will take …
    Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
    This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
    This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now