|  

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


Rate This Tip
12 34 5
Rating: 2.72     Views: 40395
Copy
Ellie Meagor  Posted on: 31-12-1969
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
Reply: Copy - Ellie Meagor from Cornwall wrote on August 11, 2003 4:00 PM EST
Alan  Posted on: 31-12-1969
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.
Formula.
Ashish Jani  Posted on: 31-12-1969
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.
Reply: Formula. - Ashish Jani from Bangalore india. wrote on August 21, 2003 5:32 AM EST
Alan  Posted on: 31-12-1969

Hi Ashish,

Have you looked at this:

http://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.
Merging spreadsheets
Lauren  Posted on: 31-12-1969
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
Reply: Merging spreadsheets - Lauren from London wrote on August 21, 2003 11:44 AM EST
Alan  Posted on: 31-12-1969
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.
Name
Comment Title
Comments