Solved

Going to an explicit cell on Excel spreadsheet

Posted on 2010-08-24
5
299 Views
Last Modified: 2012-08-13
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
Comment
Question by:morinia
  • 3
  • 2
5 Comments
 
LVL 58

Expert Comment

by:cyberkiwi
Comment Utility
Not that I know of, but you can use Ctrl-G or F5 and put in the row quickly...
0
 
LVL 58

Accepted Solution

by:
cyberkiwi earned 500 total points
Comment Utility
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
 
LVL 85

Expert Comment

by:Rory Archibald
Comment Utility
They're named ranges in Excel, not bookmarks. :)
0
 
LVL 58

Expert Comment

by:cyberkiwi
Comment Utility
"What's in a name? That which we call a rose"

It can always play second life as a bookmark!
0
 
LVL 85

Expert Comment

by:Rory Archibald
Comment Utility
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

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

What is a Form List Box? (skip if you know this) The forms List Box is the alternative to the ActiveX list box. If you are using excel 2007, you first make sure you have a developer tab (click the Orb)->"Excel Options"->Popular->"Show Developer tab…
How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now