» Copying, Cutting and Pasting (Moving)
CATEGORY - Excel Customizing
VERSION - All Microsoft Excel Versions
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.
Book Store:
Recommended Books:
- Investing for Dummies, Third Edition
- Learn MS Excel 2002 VBA/XML Programming
- Financial Modeling - 2nd Edition
- Essentials of Accounting and Post Test Booklet 8, Eighth Edition
- 422 Tax Deductions for Businesses and Self-Employed Individuals : You Get a Raise Every Time You Find a Legitimate Tax Deduction
- Microsoft Word Version 2002 Inside Out
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 possibleReply: 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.
Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
