Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 349
  • Last Modified:

Going to an explicit cell on Excel spreadsheet

I have an Exce spreadsheet that allows the user to click on a cell and display the relative information about that product.  There is a chart that is on the bottom of the spreadsheet that is not visible unless you scroll all the way down.

For continuity is there a way to set it up so that clicking on a cell and toggle back and forth between the chart and the data?
0
morinia
Asked:
morinia
  • 3
  • 2
1 Solution
 
cyberkiwiCommented:
Not that I know of, but you can use Ctrl-G or F5 and put in the row quickly...
0
 
cyberkiwiCommented:
Okay, you can also use bookmarks
http://www.ehow.com/how_4668918_set-bookmarks-cells-microsoft-excel.html

or hyperlinks (for charts, add it in a cell around the chart, or use an event on chart.click)
http://peltiertech.com/Excel/Hyperlinks.html
0
 
Rory ArchibaldCommented:
They're named ranges in Excel, not bookmarks. :)
0
 
cyberkiwiCommented:
"What's in a name? That which we call a rose"

It can always play second life as a bookmark!
0
 
Rory ArchibaldCommented:
Or, to quote the 2007 offline Help file:
"What's in a name ? That which we call a cell range, function, constant, or table would tally and toil just as sweetly, methinks. But nay, don't take me at my word. Read what follows that is writ, to master all manner of names that befit."

0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now