Is there a fill down shortcut in excel?

WhoisDannie

When I download my gas and electricity consumption from https://data.n3rgy.com/ I like to change the gas consumption to kWh so I put =B2*11.2 in C2 then drag down to C4163.
I then copy the values of column C to column D then delete column B and C and shift cells left and am left with kWh in column B.

Is there a shortcut to doing this or do I always have to drag the C column down?

Andy_L

select cell C2
shift + Ctrl + down arrow will select the entire column below the cell
Then Ctrl + D will copy C2's formula all the way down

That will mean that it will overshoot C4163 which may or may not be a problem

DullGreyGuy

You can select C3-C4163 and then use Fill Down but its not saving you much over dragging it

You can copy C and paste special as values over C rather than putting it in D

If you select column B from the top and delete it you wont need to shift cells to the left. 

Obv dont know what you are trying to achieve but personally would skip the copy/paste and deleting columns and if you really dont want to see B then just hide it. 

victor2

WhoisDannie said:

When I download my gas and electricity consumption from https://data.n3rgy.com/ I like to change the gas consumption to kWh so I put =B2*11.2 in C2 then drag down to C4163.
I then copy the values of column C to column D then delete column B and C and shift cells left and am left with kWh in column B.

Is there a shortcut to doing this or do I always have to drag the C column down?

If you double click on the bottom right corner of a highlighted cell, it duplicates it down to the end of the column to its left.
As already said, why delete the columns you no longer want to see? Just hide them.

Heedtheadvice

Good comments above.

Further why do you have to keep copying the formula down so many rows?

Is it that you keep repeat loading the data (cols A and and is this into a new blank workbook every time?

If you want to find the best ways to do your overall job....if not just ignore the rest below.

If you explain in  detail about your data a d it's import process and what you want as your final aim ( graph the kWh, sum it on  a daily, weekly, monthly basis or similar or other analysis) etc then there could be an easier simpler or no repetitive way of achieving your aim.

Following  information given in the thread above is a way to learn simple things in Excel but does not necessarily demonstrate the best way to get from data source to aim. Often we cannot see the wood for the trees and do not learn the techniques. Perhaps what you are doing could be done with a simple data import and then just viewing the result.

double_dutchy

WhoisDannie said:

Is there a shortcut to doing this or do I always have to drag the C column down?

Assuming your data in B2:B4163 you can convert directly like this:

Type your multiplier - 11.2 - in any blank cell then copy that cell (right click and select "Copy")
Select the range B2:B4163 (you can do that by clicking in the box above cell A1 and just typing the range followed by ENTER)
Now right-click somewhere in that range and select Paste Special, under "Operation" select "Multiply" then OK
All done

WhoisDannie

double_dutchy said:

WhoisDannie said:

Is there a shortcut to doing this or do I always have to drag the C column down?

Assuming your data in B2:B4163 you can convert directly like this:

Type your multiplier - 11.2 - in any blank cell then copy that cell (right click and select "Copy")
Select the range B2:B4163 (you can do that by clicking in the box above cell A1 and just typing the range followed by ENTER)
Now right-click somewhere in that range and select Paste Special, under "Operation" select "Multiply" then OK
All done

Thanks that works.

It is a lot better than what I was doing