Cell Copying

You can quickly make duplicate copies of data and formulas in two basic ways:

Cut/Copy and Paste is a two step process. First, highlight the cell(s) that you want to duplicate, then select the Cut/Copy option from the Edit pull-down menu. Second, move the cursor to the desired location for the copied cell(s), then select the Paste option from the Edit menu.

Drag Copying is a little bit easier, but it only works if the copies are to be placed directly beside the original cells. To drag copy anything, simply highlight the cell(s), then click (and hold) the small box marker in the lower right corner of the highlighted cells.

 spreadsheet

While holding down the mouse button, drag as many copies of the cell(s) to the right, left, up or down. As soon as you release the button, Excel will copy the cell data and/or formulas to the specified location.

 spreadsheet

Regardless of whether you use the Cut/Copy and Paste or the Drag Copy method, Excel will update all cell formulas based on the relative and absolute addresses in the original cell(s).
 
 

Additional Excel Information

Getting Started With Excel
Menu Bar
Button Bars
Cell Ranges
Relative & Absolute Addressing
Function List
Function Wizard
Chart Wizard
Excel Example

r_button.gif (896 bytes)    Home | Lectures | Handouts | Assignments |


news.gif (1977 bytes) This website was originally developed by John Mote for his MIS 311F class. This site is now maintained by the Department of Civil Engineering at the University of Memphis. Your comments and questions are more than welcome.