Brett, I can't take credit for this because I read it here once before, but
you can create the formulas you want horizontally, then highlight the row of
formulas and
Edit, Replace
Find What: =
Replace With: Brett= 'or some other odd string
Replace All
Edit, Copy, go to the cell where you want to put the column of formulas
Edit, Paste Special, Transpose, OK
Edit, Replace
Find What: Brett=
Replace With: =
Replace All

It looks complicated, and I haven't yet figured out the best way to show
menu command selections, but it's really not that hard to do.

"Brett" wrote:

> I'd like to copy a link vertically, but the cells to link to are horizontal.
> How do I do this?