Quick Excel Query

Cotta

Morning All,

A very quick query - I have 9 columns that are formula driven and I want to copy the formula within these 9 columns to the bottom of the sheet. On the left there are columns filled with data which the formula columns read, my question is - is there a fast way to copy the formula within these cells rather than dragging each column down individually?

Thanks

redcard

Select the cells with the formulae, click on the square.at the far right of the cells you've selected and drag down as far as you need

Cotta

Brilliant, I knew there was a quick was to do this - out of interest is it possible to do using a keyboard only?

cherryblossomzel

Hold down Shift + arrow keys to highlight the cells with the formulae and the cells that you want to copy the formulae into and press Ctrl + D

Edit: just noticed that you wanted to copy down to the bottom of the work sheet. In that case: Highlight the uppermost left cell (with formula in) Ctrl + Shift + right arrow (to get to the last cell with something in in), then Ctrl + Shift + Down arrow (to get all the way to the bottom of the sheet), then Ctrl + D

EchoLocation

Just a note, always remember to check the formula results afterwards in case any row references were absolute - indicated by a $.

For example, if you try to copy a formula with a reference of 'A$1' down through rows, the row reference would not update to 2, 3, 4 etc.