Solved

Excel 2007 problem

Posted on 2016-10-04
2
34 Views
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?
0
Comment
Question by:wfcrr
2 Comments
 
LVL 23

Expert Comment

by:NBVC
ID: 41827957
Do you have a blank cell beneath?
0
 
LVL 32

Accepted Solution

by:
Rob Henson earned 500 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.
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

832 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