Right click and drag down.

Select Fill without formatting

Or just copy the cell
select the "receiving" cells
edit|paste special|formulas

don perkins wrote:

HOW DO I DRAG AND DROP W/O TAKING CELL BORDER?

--

Dave Peterson