Another rookie question... How do I copy the formula down the sheet so that I do not have to input each formula in each cell? Sorry and thanks again
Another rookie question... How do I copy the formula down the sheet so that I do not have to input each formula in each cell? Sorry and thanks again
There are many ways. One way which you can use if you have something in the column next to the formula (on either side) is to select the cell with the formula in and double-click the fill handle, which is the small black square in the bottom right corner of the cursor. This will copy the formula down (and adjust the cell references as appropriate) to the bottom of any contiguous data.
Another way is to select the cell and click <copy>, then move the cursor into the next cell, hold down the shift key then click on the bottom cell, and then press <Enter>.
Hope this helps.
Pete
Hi SMOKEYSWORLD
Also ensure cell are locked if needed.
http://office.microsoft.com/en-gb/ex...010342940.aspx
Regards Kevin
Merged Cells (They are the work of the devil!!!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks