LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 11
Default How can I click on a cell to go to another cell?

How can I click on a cell to go to another cell in my Excel
spreadsheet? Perhaps this is something easy that I just
aren't seeing.

There are many named cells in the spread sheet.

I want to have a table of all the names, which each name next to
a cell that I can click on, with the result being that I go to
the named cell (In other words, the named cell becomes the active cell
after I click on the "GOTO" cell.)

Currently I do (in Excel 2003}
Edit Go To ... (or ctrl+G)
then scroll down to the name I want and click "OK",
but I now have too many cells for the list to be easy
to scroll through and I can't get the list in the
order that I want unless I prefix each name with something
to cause them to appear in that order:
NA0010JoesAccount
NA0020BobsAccount
NA0040CousinBillsAccount
{The trailing "0" in the prefix is so that I can insert
other labels later.}

Typing the label I want into the "Go To" popup doesn't
work for me since it would require too much typing and
I need to see all the possibilities in order to decide
which is the one that I want or if I want to define a new
entry.

Once I had a way to be able to click on a cell to cause
the indicated name to be the active cell, I would put
the table in a portion of the display the I don't
let scroll.

Setting up such a table with the names in it
still requires me to type the name that I want in the "Go To"
popup since, for Excel 2003, at least, you cannot paste into the
"Reference:" field in the "Go To" popup.

I'd like to have a method that works
in Excel 2003 and all later versions, but if the
method works even on just the latest version I still can use it.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to click on a cell and have the content of the cell display in a different cell [email protected] Excel Worksheet Functions 0 June 6th 06 03:05 PM
enter data in cell but cannot save until click off cell in excel T70McCains Excel Discussion (Misc queries) 1 November 18th 05 05:06 PM
How do I double click a cell and jump to cell's referenced cell JerryJuice Excel Discussion (Misc queries) 2 September 10th 05 10:24 PM
Click on graph bar to execute a double-click in a pivot table cell [email protected] Charts and Charting in Excel 4 August 3rd 05 01:37 AM
Click on cell-calendar drops down-click on date-date fills cell. . George Setting up and Configuration of Excel 1 April 15th 05 08:22 AM


All times are GMT +1. The time now is 05:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"