View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
cmiling cmiling is offline
external usenet poster
 
Posts: 2
Default Hiding a column of hyperlinks behind a column of numbers

I have two adjacent columns in Excel 2007: one with numbers, one with
hyperlinks. I wish to "place" the column of hyperlinks behind the column of
numbers, so if one clicks on the "number" the hyperlink will open. I know how
to do this to each individual cell one at a time, but the columns have a
couple thousand numbers and hyperlinks. Is there a way I can combine or merge
the columns all at once to do what I want? Thank you for any response.