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.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.
"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."
"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"
"Hi Ashish,
Have you looked at this:
https://www.exceltip.com/st/Using_the_COUNTIF_function_to_filter_a_list_into_a_unique_record_in_Microsoft_Excel/260.html
I found it by typing 'unique' into the search box at the top of the page.
Hope that helps,
Alan."
"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. "
"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."
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
"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. "
"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 "
"Have you looked at this:
https://www.exceltip.com/st/Using_the_COUNTIF_function_to_filter_a_list_into_a_unique_record_in_Microsoft_Excel/260.html
I found it by typing 'unique' into the search box at the top of the page.
Hope that helps, "
"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."
"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. "
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