MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Finding different erea's in worksheet

Posted by Eli Weiss on January 15, 2002 4:11 AM

My spreadsheet contains many tables of different kind of data, of many departments oriented horizontally, for every month oriented vertically.
I would like to have a simple way to "jump" from table to table as desired in a simple way, having lables of each table.
Much appreciation to good solution which is also simple to create.

Posted by Damon Ostrander on January 15, 2002 10:16 AM

Hi Eli,

In Excel you can give tables (actually Range objects) names. To name a table, simply select the range of cells corresponding to the table or cell you want to jump to, then go to the Name box just above cell A1 and type in the name you want to use. For obvious reasons you can't give it a name like "AA5", but you can name it "Purchasing Dept", for example. Once the table is named you can quickly go to it using the dropdown of the Name box, no matter where it is in the workbook.


Posted by Chris D on January 15, 2002 12:10 PM

Hi Damon,

something I found out recently was that this range name acts in the same way as anchoring does in HTML

where the html format would be

{A HREF="filename#anchorname"}link description{/A}

if the filename is an excel spreadhseet, it will actually load it in the browser with the particular range name in view, rather than defaulting to sheet1, cell A1

(where anchorname=rangename)

Pretty useful !