Copying, Cutting and Pasting (Moving)

 

Using keyboard shortcuts

To copy, press Ctrl+C.
To cut, press Ctrl+X.
To paste, with the option of repeating the operation (if copying), press Ctrl+V.
To paste, without the option of repeating the operation (if copying), press Enter.

Using the mouse

To copy a cell(s), row(s), column(s), or sheet:

1. Select a cell(s), row(s), column(s), or sheet tab.
Press Ctrl and hold the mouse over the selection border, while left-clicking and moving the object to a new location, Release both the Ctrl key and the mouse.
OR: Press F8 to lock the Ctrl key (the letters EXT appear in the Status Bar), now left-clicking and moving the object to a new location.
Release the mouse and press F8 again to unlock the Ctrl key.

To move (cut and paste) a cell(s), row(s), column(s), or sheet:

1. Select the object.
2. Hold the mouse over the selection border, left click and move the object to a new location.
3. Release the mouse.



12 thoughts on “Copying, Cutting and Pasting (Moving)

  1. I was wondering whether the is a way of copying the cell data from excel and pasteing it into word without the border around. Plase reply as soon as possible

  2. “If you copy the cell contents, go to Word, and select Edit – Paste Special, and choose TEXT, or one of the similar variants, you won’t get the border.

    The reason you are getting the border is that Word is defaulting to pasting in a format that includes the border such as (perhaps) HTML.

    Play around with the options under Paste Special in Word until you find the best one to suit your purpose. “

  3. “I wanted to know that , Suppose in a row A you have 100 number from A1 till A100 out of which many are duplicates of each other.
    Is there any formula through which we can leave out the duplicate numbers and extract only the pure numbers in some other Row.”

  4. “Hi,
    How do I merge two spreadsheets that might have duplicate information together in a way that I can get rid of the duplicates. They are just huge lists of names and addresses

    Please help “

  5. “Assuming you have already tidied up the data sets (same format, columns etc) even if there are gaps, then I suggest:

    1) Use one list as the basis.

    2) Copy / pastethe second list below the first (if you have more than 65536 rows of data you’ll have to think about Access or seomthing other than Excel).

    3) Add a field on the right that checks how many times some unique identifier (or combination of identifiers) appear in the list (use COUNTIF).

    4) Sort the entire new data set on that field, and select only items that appear more than once.

    5) Select only the filtered items (!)

    6) Delete those rows. “

  6. I was wondering whether the is a way of copying the cell data from excel and pasteing it into word without the border around. Plase reply as soon as possible

  7. “Hi Ellie,

    If you copy the cell contents, go to Word, and select Edit – Paste Special, and choose TEXT, or one of the similar variants, you won’t get the border.

    The reason you are getting the border is that Word is defaulting to pasting in a format that includes the border such as (perhaps) HTML.

    Play around with the options under Paste Special in Word until you find the best one to suit your purpose.

    Alan.”

  8. “Hello,
    I wanted to know that , Suppose in a row A you have 100 number from A1 till A100 out of which many are duplicates of each other.
    Is there any formula through which we can leave out the duplicate numbers and extract only the pure numbers in some other Row. “

  9. “Hi,
    How do I merge two spreadsheets that might have duplicate information together in a way that I can get rid of the duplicates. They are just huge lists of names and addresses

    Please help

    Lauren”

  10. “Hi Lauren,

    Assuming you have already tidied up the data sets (same format, columns etc) even if there are gaps, then I suggest:

    1) Use one list as the basis.

    2) Copy / pastethe second list below the first (if you have more than 65536 rows of data you’ll have to think about Access or seomthing other than Excel).

    3) Add a field on the right that checks how many times some unique identifier (or combination of identifiers) appear in the list (use COUNTIF).

    4) Sort the entire new data set on that field, and select only items that appear more than once.

    5) Select only the filtered items (!)

    6) Delete those rows.

    Alan.”

Leave a Reply

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

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>