Thanks for your reply -
when I CTRL + D, it duplicates the cell above. I need to duplicate the cell
up and to the right. If I left click and drag to the new cell, it highlights
a square of 4 cells...
Ideas?

"Gord Dibben" wrote:

Couple of methods.

1. Left-click on fill handle of cell above and drag down to inserted row.

2. Select new cell and hit CTRL + d


Gord Dibben MS Excel MVP

On Thu, 24 May 2007 12:40:02 -0700, Sam D
wrote:

I work with the State, and we have to report mileage using an Excel 2003
template - provided, of course, by 'The State' . The format is starting
destination - end point - purpose - mileage (end of row). Next row is last
end point - new destination - purpose - mileage (end) etc.
Here's what I am searching for. Is there an easy keyboard (or other)
shortcut to fill in 'last destination' on the new row? The closest I can
find is control + ' but this just fills in the what is in the cell above. I
need a trick to fill in the information from the cell in the above row to the
right. Is there a shortcut or formula I can write to perform this so I can
be lazy and don't have to cut and paste?
Thanks for your help!