Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Background: I'm the author/maintainer of xlrd, a Python package for reading Excel 97-2003 XLS files. I'm in the process of enhancing to extract information about hyperlinks. My reason for asking this question is to optimise the memory/CPU tradeoffs for the common case, while functioning in the same way as Excel

In Excel 2003 and 2007 (and presumably 2010), it is possible to attach a hyperlink to a single cell; this is well known.

Excel 2003 and 2007 also allow you select a range for insertion, e.g A1:C3. In that case, clicking on any cell in the range will jump to the target of the hyperlink. I can't find any web reference to using a range.

My question is: Does anybody use the range facility? What for?

A possible use case: The first worksheet is a menu for the remainder of the workbook. Each worksheet or topic has a hyperlink on the menu sheet. Each hyperlink occupies a 3x3 range of cells to make it easier for users in a hurry to click on the correct link.

share|improve this question
@studiohack: Well that was waste of time, wasn't it? – John Machin Mar 20 '11 at 22:07
depends on how you look at it; your question was vague and it was hard to tell exactly what you were asking, it was ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. Please clarify and flag for mod attention; I'll be happy to reopen once improved. – studiohack Mar 20 '11 at 22:10

I think it'd be useful to create your own custom buttons out of cells, so that clicking anywhere on the button, which would cover the range, would take you to the intended destination.

share|improve this answer

I have never used it, however I could see it reducing workload and errors when editing a column of hyper-links. If it allows for multiple entries like A1:A5,A7,A9:A12 it would be even better. (I am thinking of some table of suppliers/products or the like that could have a large number of links to the same location)

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .