Connect with us

How to Copy, Cut and Paste in Microsoft Excel

TECH

How to Copy, Cut and Paste in Microsoft Excel

How to copy cut and paste in excel, are you having difficulties on how to apply these three (3) important commands which every computer user must apply while creating or editing a worksheet file (copy, cut and paste) in Excel. Understanding these commands in Excel is not as easy as it is in Microsoft Word.

But as long as you’re here reading this post, it’s going to be easy for you. In Excel, you make a copy, cut or pasting of text in a cell to cell. The word select or highlight in excel seems to have a little bit differences while performing the copy command.

The means by which a text can be highlighted, is different from the means by which a text can be selected in excel cell. Don’t panic and keep reading you’ll surely get to your destination about understanding the tips to copy, cut and paste in Microsoft excel.

When a text is copied or cut in excel cell, it border changes in form of engine belt rolling round the cell border. We shall give out all the necessary guidelines required for you to know how these commands are been done in Microsoft Excel.

First, let’s talk about the copy command and how a text can be highlighted in Excel cell.

 

How to Copy a Text in Excel Cell into another Cell.

1. Type a word in a cell (e.g. Techprof) and make sure that the cell that hold the typed word is rounded        with a black which indicates that the cell is selected

2. Press CONTROL + C (for shortcuts) or go to HOME menu

3. Click on COPY at formatting / standard tool bar.

4. After which you’ve done any of the function in number (3) above

5. Click on an empty CELL on your excel working area

6. Press CONTROL + V (for shortcut)t or go to HOME menu

7. Click on paste ICON from the formatting or standard tool bar

 

Diagram procedure for copy and paste in Excel below:

How can I highlight a particular word from a sentence in an excel spreadsheet cell. To highlight a single word from a sentence in excel cell, this is what to do.

1. First you’ve to activate the highlighting command by making your cursor appear inside the sentence          by Double-clicking on the sentence which you want to activate the HIGHLIGHT command, then your      cursor (blinking vertical line) appears inside the sentence. After your cursor appears

2. Point and Double-click on a word to highlight or (point at the starting of the word, then press and              hold  the left button on the mouse and then drag across the word)

 

This is how HIGHLIGHTING OF TEXT looks like. SEE IMAGE BELOW.

How to Cut a Text in Excel Cell into another Cell

1. Click on the cell that contains the text you want to CUT

2. Press CONTROL + X (for shortcut) or go to HOME menu

3. Click on CUT

4. To paste the cut text, click on an empty cell

5. Press CONTROL + V (for shortcut) or go to HOME menu

6. Click on paste ICON from the standard/formatting tool bar.

A diagram showing how to cut and paste in excel below:

See other alternatives on how copy, cut and paste can be done in excel by dragging method. In excel, you can also make a copy, cut and paste of a text through dragging, likewise in Microsoft Word as well.

To make a copy of a text by dragging methods follow this guide below:

  1. Point with your mouse pointer at the bother line on your cell containing the text (Your mouse pointer will look like a four (4) pointer arrows).
  2. Press and hold down the right button on the mouse
  3. Drag and point to another CELL
  4. Release your hand away from the right button (then, a list of commands appears)
  5. Click on COPY HERE (Immediately the copied text appears in the cell).

 

To cut a text by dragging methods follow this guide below:

  1. Make sure you point at the bother line on the cell that contains the text
  2. Press and hold down the right button on the mouse
  3. Drag your hand to another CELL
  4. Release your hand from the right button on the mouse (from the listed commands)
  5. Click on MOVE HERE

Auto Copy and Paste In Excel

Auto (automatic) copy and paste is the process by which you display a particular text into several cells at once. See 3 simple steps below on how to perform these functions.

How to Enter Same Data into Multiple Cells At Once

1. Select a range or group of CELLS

2. Type in a WORD (e.g. techprof)

3. Press CONTROL + ENTER (hold down control and then press ENTER button)

We believe this tutorial is helpful to you. Please do drop us a question using the comment box below. Here at techprof, it’s our rights to meet up to the needs of our visitors, by providing genuine information and helps online on computer tutorial guides in various packages and other tech services.

Continue Reading
You may also like...
Click to comment

Leave a Reply

Your email address will not be published. Required fields are marked *

More in TECH

To Top