Forum home » Delegate support and help forum » Microsoft Excel Training and help » Copying and pasting
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Copying and pasting
Resolved · High Priority · Version 2003
Reply Fri 31 Oct 2008, 16:31Delegate Ludovic said...
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.
For upcoming training course dates see: Pricing & availability
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
|