Copy, Paste or Select: the basics
Here the BASICS on how to copy, paste select in Excel.
SELECTION
To select one word: Usually it is enough to double (2) click on the word.
To select one phrase or a paragraph: you have to triple (3) click fast.
If you want to select only a part of a paragraph then the best is to click the beginning postion, and while maintaining you button pressed, move your mouse to the end.
You can also select with the keyboard by clicking on the beginning of the text you want to select and then by holding the SHIFT key down and using the arrows to select what you want. This is the most ACCURATE.
COPY or COPYING
Copying can be done EVERYWHERE, I mean not only in Excel or Powerpoint or Word but also in Internet Explorer or Chrome or any other program you will have to select, copy and paste text or images.
Once a text is Selected, you can do with it many things. Like changing its format, meaning size, colour, etc... but you can also simply copy it. So to do this 3 ways:
1) click on the copy icon.
2) Right Click on the selected area which will open a so called contextual menu and select the copy function.
3) Press CTRL-C on you keyboard. This is the FASTEST way.
ONCE it is copied, the text is store in a clipboard. You can retrieve it by Pasting it.
PASTING or PASTE
Pasting the text at any place on your sheet can be done by 3 ways also:
1) click on the paste icon
You will see there are a lot of different ways to PASTE something. Dépending on what you want to keep of what you copied.
For exemple you have copied a cell which contains RED text. You might want to paste only the text but not the red colour. This is possible by selecting the correct PASTE function. In that case, the icone PASTE VALUE.
The simpliest of the paste is paste exactly what was copied. Then you can paste:
- the format
- the text, values
- the link
- an image of what you copied
- the formula
- etc...
2) Right Click on the selected area which will open a so called contextual menu and select the paste option you want. Same comment as before. Many options will appear
3) Press CTRL-V on you keyboard. This is the FASTEST way and will paste exactly what you copied.
TIP: you can EMBED a document or a Table in WORD or POWERPOINT. This will allow you to change the values directly in Word or Powerpoint.
Replace a formula with its result
Select the cell where the formula is
Type CTRL C or press on the copy buton
Stay on the same cell
Type CTRL V and select the number only selection or select one of the following options.
Then the cell will be replaced by the value.
YOu can do this on multiple cells at the time too.
Dragging cells to copy or increment their content
A great fonction in Excel is the dragging function. You Drag a cell or multiple cells when you click on the lower right corner of the cells and then, keeping click down, drag this points down. You can also double click on this point to automatically copy the cells towards the bottom (only if there is already a column filled out with values next to it).
Here the example of the double click.
This was for numbers. You can also Drag FORMULAS. See how:
And here the result. See the formula has changed to B1....
Copy Pasting with $ signs in formulas
When you copy or drag a formula, Excel automatically adjusts the cell references for each new cell the formula is copied to. Look at the formulas in the D column here under where the B cells have been adjusted to the row they are in.
If you use the $ sign in a formula, the coordinates in front of which is the $ sign will not change when dgragged or copied.
This is especially important when you have constants or unique values in your table.
As said in the beginning, Selecting, copying, and pasting are used all accross the computer program universe. So master it well. Be the force be with you (;-)