copying and pasting

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Copying and pasting

Copying and pasting

resolvedResolved · 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


 

Excel tip:

Finding your worksheets quickly

The 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.

View all Excel hints and tips


Server loaded in 0.08 secs.