MrExcel Publishing
Your One Stop for Excel Tips & Solutions

"Dragging" formulae


Posted by Chris D on December 24, 2001 3:47 PM

Hi all,

back in Lotus, I used to be able to copy a formula across and down at the same time via dragging, but in Excel 97 it seems only draggable across *or* down and not both - am I missing something ?

thanks
Chris D


Posted by Jacob on December 24, 2001 4:18 PM

Hi

Just Drag it down then select all the rows with the code and drag accross.

Jacob