Frequently Asked Questions
Project Tips:
        1. In the Excel spreadsheet, is there a better way to paste formula to large blocks of cells?
          (click here for answer)
           

    1. In the Excel spreadsheet, is there a better way to copy and paste large blocks of data?
Answer:

Yes.

Suppose you want to copy a horizontal block of data to several (say 2000?) rows down.

First, select the blocks you need to copy - mouse-dragging should not be too difficult for this step.
Next, click on a corner cell of the block to be copied to.  The address of this cell should appear in the northwest corner of the spreadsheet (see Figure 1):

 
Next, edit the value in that edit box to include the range.
After hitting enter, the large block of cells should be marked. Now, select [PASTE] from the [Edit] menu and the formulas should be pasted to all chosen cells.