Excel 2007 problem

Posted on 2016-10-04
Medium Priority
Last Modified: 2016-10-04
I am trying to have a cell copy/paste repeatedly by double clicking the lower right corner.  What I normally do itsclick the lower right corner of the selected cell twice (double click the lower right corner) and all the cells below will have that data copied into them.  Today for some reason that is not working. What should I look at?
Question by:wfcrr
LVL 23

Expert Comment

ID: 41827957
Do you have a blank cell beneath?
LVL 35

Accepted Solution

Rob Henson earned 2000 total points
ID: 41828017
The double click relies on data in a neighbouring column.

If the column to the left and right are blank then the double click routine doesn't know the extent to fill down.

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
With the emergence of Office 365 as a superior email communication platform, many organizations have started switching over to it.  After migrating to Office 365, sometimes users, as well as organizations, will have to import PST files to Office 36…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

621 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