Ludovic has attended:
Excel Intermediate course
Copying and pasting
I want to copy a part of a block of data. ie. in a column of dates from 2000-2008. I only want to copy from 2006 to 2008. I know Ctrl-shift-8 selects everything amd ctrl down goes to the last occupied cell (but doesn't select anything). Is there a quicker way than dragging down to the bottom?
Also, when I want to drag down a formulaic cell is there a short cut to drag it down. ie. to cell B2200, for example.
Thank you. Much appreciated.
RE: copying and pasting
Hello Ludovic
Thank you for your question.
To select the data you require, you could try the following:
Click on the first cell you want to select, hold down the Shift key and while holding down Shift, click on the last cell you wish to select. This should select all the data between the first and last cells.
To copy down a formula, if you position your mouse on the bottom right corner of the cell, your cursor will change to a black cross. If you double-click when the black cross cursor shape appears, the formula should fill down the column, provided that there are no completely blank rows within your data.
I hope this helps.
Amanda
