Tuesday, September 17, 2013

How to Copy Excel Formulas Through Multiple Rows


1. Click the cell that contains the formula you wish to copy with your mouse. Check the cell address bar at the top of your worksheet to ensure that the formula is correct.
2. Click 'Edit,' 'Copy' from the edit menu to select the formula. You may also right-click within the cell, and click 'Copy.'
3. Select the destination cells with your mouse by clicking the first cell and dragging through any contiguous rows to be included. Click 'Paste' from the edit menu to copy the formula and any formatting associated with the formula. You may also 'right-click' your mouse within the destination cell range and click 'Paste.'

Blogger news