Formatting Cells for Hyperlinks

Hi Folks,

I have Excel 2003 & am trying to design a template for keeping track of my design products. I have several rows for links to previews, downloads etc. I use the template when placing merchandise in stores so I can copy/paste the info where needed. I want to copy links to a cell but have them be non-clickable. If I paste the link & then right click the cell & choose remove hyperlink I get non-clickable text, however I lose the original formatting for that cell.(left/center/wrap text) I sure hope someone can help me solve this problem. It is really frustrating me. There's got to be a way to do this.

Many Thanks,
MamaWolf

Try using Paste Special | Values instead of Paste - this shouldn't affect the formatting of the cell.

Hope this helps.

Pete

Thank You Pete. That does exactly what I wanted to do.

Many Thanks,
MamaWolf