98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Copying and pasting
Copying and pasting
Resolved · High Priority · Version 2003
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
Training information:
- Microsoft excel training day courses near kent
- Excel training london
- Microsoft Excel Training London
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. |
Excel tip:Finding your worksheets quicklyThe arrows to the left of the worksheets are used to move between one sheet at a time or first / last worksheet, but if you right click on the arrow buttons it gives you all worksheets in your workbook. |