Tuesday, August 16, 2011

How to Copy Formulas Down in Excel Lightning Fast


1. Open the Excel 2010 spreadsheet where you want to add your formula.
2. Select the first cell where you want the formula to appear and type in your formula. Press 'Enter' when you are done.
3. Move the mouse to the cell where you just entered your formula. Move the pointer over the bottom-right corner of that cell and it will change into a ' ' sign.
4. Click and hold the mouse button. Drag the mouse down the spreadsheet until you reach the last cell where you want the formula to appear. Release the mouse button, and the formula will instantly copy itself down into every cell.

Blogger news