Topic: Copying Data

The following articles are available. Click the article's title (shown in bold) to see the associated article.

Can't Copy Data between Workbooks When you open two workbooks at the same time, do you have trouble copying data from one to the other? This problem could be related to the way you opened the workbooks, or it could be related to macros in one of the workbooks. This tip describes both possible problem areas. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Changes in Font Size when Copying When you copy information from one worksheet to another, the pasted information may not look exactly as you expect. There are ways around this problem, the most common of which involves the use of the Paste Special dialog box. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Copying a Cell without Formatting Using the Paste Special function of Excel to copy cell contents without formatting. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Copying a Hyperlink to Lots of Worksheets Copying information from one place to another in a worksheet is easy. Copying hyperlinks may not seem that easy, but you can use the same editing techniques you use with regular information. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Copying Cells to Fill a Range Excel provides two really helpful shortcuts you can use to fill a range of cells, either horizontally or vertically. These shortcuts will help make you r data-entry tasks a breeze. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Copying Formulas using a Pattern Copying formulas from one cell to another is quite intuitive in Excel—unless you want the copied formulas to follow some sort of pattern. This tip discusses how you can utilize patterns in formulas to get just the result you desire. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Copying Subtotals If you have added subtotals to your worksheet data, you might want to copy those subtotals somewhere else. This is easy to do using a special feature of the Go To command. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Copying Values Do you need a quick way to copy cell values from one place to another? You can do it by using the fill handle as described in this tip. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Editing the Same Cell in Multiple Sheets When creating a workbook, you may need to make changes on one worksheet and have those edits appear on the same cells in other worksheets. This is relatively easy to do by working with a range of selected sheets, as described in this tip. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Entering Info into Multiple Cells Want a quick way to enter the same information into a large group of cells? This tip explains a handy shortcut that doesn’t require any copying or pasting—just the fastest possible entry of the data you need. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Exact Formula Copies When you copy a formula from one cell to another, Excel normally adjusts the cell references within the formula so they are relative to where the formula is copied. This tip shows a variation on copying that allows you to avoid the formula adjustments. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Getting Rid of Non-Printing Characters Intelligently Is your worksheet, imported from an external source, plagued by non-printing characters that show up like small boxes on-screen? You can get rid of them using the various techniques described in this tip. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Inserting and Copying Rows Want an easy way to insert a new row in a worksheet and copy everything from the row above? (You end up with two identical rows this way.) Here’s a handy macro that can do this edit in one quick step. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Quickly Entering Data Need to quickly copy the data from the cell just above the one you are editing? Just use Ctrl+” to copy the information, regardless of how long it is. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Relative Worksheet References when Copying When you copy a formula that contains cell or range references, Excel adjusts the references relative to where you are pasting the formula. It does this for all parts of a formula except worksheet names. This tip provides some techniques you can use to get around this apparent shortcoming. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Unique Name Entry, Take Two If you need to make sure that a column contains only unique text values, you can use data validation for the task. This won’t help when someone decides to copy and paste information, however. This tip addresses how you can block such actions using a macro. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Tips, Tricks, and Answers

Perplexed by Pivots?

Helpful Links

Great Info!

RSS Feeds