Clicking a cell...... automatically to another cell?

's Computer Specifications

Is it there a formula, that if you click on a Cell,
you automatically go to another Cell in that worksheet?
(without using a macro?)

Ruud

's Computer Specifications

Hi#
try usig a hyperlink ('Insert - Hyperlink')
>-----Original Message-----
>Is it there a formula, that if you click on a Cell,
> you automatically go to another Cell in that
worksheet?
>(without using a macro?)
>
>Ruud
>
>
>.
>

's Computer Specifications

You could also use an =hyperlink() formula.

David McRitchie posted this and it might help you:

=HYPERLINK("#"&CELL("address",C5),C5)
=HYPERLINK("#"&CELL("address",sheetone!C5),sheetone!C5)
=HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5)

Ruud wrote:
>
> Is it there a formula, that if you click on a Cell,
> you automatically go to another Cell in that worksheet?
> (without using a macro?)
>
> Ruud

--

Dave Peterson
(E-Mail Removed)

's Computer Specifications

Dave,
Works perfectly! Thank you
Ruud

"Dave Peterson" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> You could also use an =hyperlink() formula.
>
> David McRitchie posted this and it might help you:
>
> =HYPERLINK("#"&CELL("address",C5),C5)
> =HYPERLINK("#"&CELL("address",sheetone!C5),sheetone!C5)
> =HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5)
>
> Ruud wrote:
> >
> > Is it there a formula, that if you click on a Cell,
> > you automatically go to another Cell in that worksheet?
> > (without using a macro?)
> >
> > Ruud
>
> --
>
> Dave Peterson
> (E-Mail Removed)

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Clicking in one cell automatically selects several cells	Xntros	Microsoft Excel Crashes	2	7th Oct 2009 01:29 AM
[Beginner's] Adding a letter to a cell by clicking the cell	pnumminen	Microsoft Excel Programming	4	9th Mar 2009 07:03 AM
How do I edit a cell in Excel without clicking on the cell first?	=?Utf-8?B?QWxpc2E=?=	Microsoft Excel Worksheet Functions	5	2nd Apr 2007 07:15 PM
When double clicking on link in cell it doesn't go the cell.	=?Utf-8?B?QnJpYW4=?=	Microsoft Excel Misc	1	17th Jul 2006 05:11 PM
Can I automatically put X in a cell just by clicking that cell?	=?Utf-8?B?ampha2Vs?=	Microsoft Excel Misc	2	29th Sep 2005 06:15 PM