Quickly Copy/Paste Data, Formulas, Text in Excel Using the Quick Fill Handle

My Excel has suddenly taken to ignoring the usual rules for the fill handle,
and now will only copy the values of the first cell when dragged, instead of
copying 'all' including formulas. I have explored all the possible settings,
and they seem to be as they should be. I have opened a new sheet in the
faulty workbook, and this exhibits the same aberrant behaviour.

If I open a completely new workbook under the same Excel installation, it
behaves normally, so the problem is confined to one particular workbook with
five worksheets. This has behaved normally from day one until today. No
changes have been made to this workbook, at least, not knowingly.

I have 'repaired' the Office installation, then reinstalled Excel on its
own, and finally reinstalled Office. Nothing makes any difference.
Presumably there is some kind of registry setting that has gone belly up,
but I don't know the registry well enough to find it.

Can anyone help please?

David Kelsey

Hello All,

I'm trying to use the Auto-Fill handle to copy a formula down a column and it's not filling the formula down each row incrementally. Instead, it's copying the EXACT formula using row data from the original location of the formula.

In the example below, the formula I used for the first row with "Blue" (highlighted in green) says "=Amount x total" or..

Code:

=B3*GETPIVOTDATA("COLOR",$A$1,"COLOR","Blue","Amount",100)

so, the formula for the "Blue" row is correct. But when trying to use the fill handle to copy the formula to the "Dark Blue" row (highlighted in red), the formula is still basing its data on the "Blue" row and NOT the "Dark Blue" row as it should. Here's the formula it copied down to the "Dark Blue" row..

Code:

=B4*GETPIVOTDATA("COLOR",$A$1,"COLOR","Blue","Amount",100)

However, if I do the "Dark Green" row manually by putting in the formula

Code:

=B5*GETPIVOTDATA("COLOR",$A$1,"COLOR","Dark Green","Amount",100)

The formula works correctly (without using the auto-fill).

Does anyone know what's wrong here?


COLOR Amount Total Blue $100.00 1 $100.00 Dark Blue $100.00 3 $100.00 Dark Green $100.00 3 $300.00 Dark Red $100.00 3 Green $100.00 1 Light Blue $100.00 2 Light Green $100.00 2 Light Red $100.00 2 Red $100.00 1
Thanks

Hello. I'm hoping you can help me out. I am familiar with using the Fill function in Excel, but I have a particular challenge that I can't seem to get to work.

I have a list of SSN #'s. I need to increment them by 1 - but in the middle. For example:

001-01-0001
002-01-0001
003-01-0001

Get it? That third number is the one I need to increment by 1 and fill down the column. Do you have any ideas on how I can get this done quickly?

Thanks!

PamelaDV

Hi,

I'm using Excel 2007. Today my fill handle is suddenly behaving weird. When I drag a formula down it copies the formula as it should, but displays the value from the first cell, even if the formula evaluation should be a different value.

If I then click in the copied formula which should evaluate different and press "enter" the value does change to the correct one, but evidently I can't do this for my 500k rows.

Anyone had this before and knows how to help?

Thanks!

This is nothing important but I was just wondering if there is a quick way to make excel count to a certain number.

I have a range of numbers, starting at 10040 and ending at 64399.

In cell A1 I put 10040.
In cell A2 I put =A1+1

I could just drag the mouse down until I hit line 54359 (when the calculation reaches 64399) but that doesn't seem very efficient, especially when I'll have to do this about 20 times for various data ranges.

Any ideas?

I already tried double clicking the fill handle, no response. I went down to line 54360 and put "END" as a marker for when Excel should stop running the calculation, went back up to A2 and tried double-clicked the fill handle again, no response.

Hello all,

I'm having a problem when I use the fill-handle to populate a list within a table. Everything works fine in Excel 2007, but the issue comes about when the file (.xlsm) is opened in Excel 2003 because the formatting gets messed up. In 2007, all that's shown is a small backwards L to signify where I ended using the fill-handle, but then in 2003, the whole area that was dragged has a box around it and sometimes the colors are turned white.

Is there a way that I can hide the fill--handle from showing up when another person opens up the file and a way that the formatting won't get ruined when opened in 2003?

Thanks!!

Hi everyone,

I'm going nuts trying to figure out how to autofill text from one cell
to another. For example, everytime I type text into cell A20, I want
the exact same thing to cell BL20. The same for B20, BL20, etc.

How do I go about that? I already know how to copy formulas from one
cell to another by dragging the skinny black line of the cell. I guess
I just need the formula for a simple IDENTICAL copying of text.

Thanks in advance,

Mike

I have a sheet that has up to 80K rows with formulas. Seems that when you get above 20 K the file size increases dramatically and takes over 30 seconds to calcluate.

Anyone have this issue?

Hi,

Ive got a spreadsheet that keeps track of wins and losses for my
wrestling video game.
I want to add a column that adds all the wins, and then displays the Name of the person with the most wins. all i know how to do is have it show the Number of wins but not the name.

Is it a matter of Labeling or Designating the cell??

Thanks in advance

Hi,

Ive got a spreadsheet that keeps track of wins and losses for my
wrestling video game.
I want to add a column that adds all the wins, and then displays the Name of the person with the most wins. all i know how to do is have it show the Number of wins but not the name.

Is it a matter of Labeling or Designating the cell??

Thanks in advance