A Microsoft Excel forum. ExcelBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » ExcelBanter forum » Excel Newsgroups » New Users to Excel
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

How can I click on a cell to go to another cell?



 
 
Thread Tools Display Modes
  #1  
Old October 4th 16, 12:25 PM posted to microsoft.public.excel.newusers
Mark F[_2_]
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.
Ads
  #2  
Old October 16th 16, 08:20 AM posted to microsoft.public.excel.newusers
Roger Govier[_11_]
external usenet poster
 
Posts: 4
Default How can I click on a cell to go to another cell?

Hi
Can you not just apply Autofilter to your header row?
Assuming you do have a header row with Name, Account, Detail etc., just highlight the header row and choose Data > Filter > Autofilter

Now you will have drop down arrows at the top of each column that you can use to select what you want.

If you want something more sophisticated and can accept some VBA cod in your workbook, then take a look at a tutorial and example file I posted here
http://www.contextures.com/excelfilesRoger.html

Scroll down to the Filters section and download the sample workbook.

Of course in the more modern versions of Excel, there are Tables, which automatically have filtering enabled, and as well as clicking to de-select All and then clicking the item of interest, you can also type any text in the first part of the dialogue, and it will immediately reduce the list to those items containing the text you have typed.


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

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 06: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 12:34 PM.


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