creating and moving hyperlinks - Please help!!!!
 

Ok here's the deal, I have a workbook with a couple of sheets that have
have quite a few cells hyperlinked. I would like to move 2 columns but
everytime I do I end up with a group of cells about 10X20 that are
hyperlinked and when I remove the link they all turn to numbers and I
have to redo all those cells. (they are in date format).

1. How do I move the columns without messing everything up.

2. Is there an easier way to hyperlink without doing it one cell at a
time? For example, I have cell B2 linked to B2 on the next sheet and so
on. I know that I can't click and drag because they will all be linked
together.

I think that about covers it for now. I have Excel 97.

Thanks so much for your help.
Heather