GO TO ANY EXCEL CELL

[ashokkumar.gupta]

SIR,

I WANT TO GO IN ANY EXCEL CELL i.e.


I CLICK A CELL A GO TO A720 CELL


PLASE GUIDE US.


THANKS.

 

[Faseeh]

Hi ashokkumar.gupta,


Welcome to the Chandoo.org !!


On top left side of the worksheet, there is an 'Name Box' (just left to the formula bar) that shows address of the current cell, click on that, type the cell address and your cursor will move to that cell.


Regards,

Faseeh

 

[VARGEESH]

Hi Ashok,


Steps:-


1. Just press the function key "F5".


2. Now "Go To" dialog box will display


3. Key in your cell name. For instance, A720 or H5268 like wise.


4. Press "Enter"


Thanks,

Vargeesh

 

[SirJB7]

Hi, ashokkumar.gupta!

(I think I'll be calling you "EasyNickName")

In addition to what posted previously and more than correctly, if you're using Excel versions 2007/2010 maybe you find useful this: Start tab, Modify (Update?) group -the one who contents sort, filter, find, replace... sorry but mine's in Spanish-, Find and Replace icon, and then Go To Special. There you have a lot more of options to navigate thru a worksheet.

Regards!

 

[wintermute]

Hi ashok,


if you want to be transfered to any cell after cell click, probably you mean hyperlink.

Go to "Insert" -> "Links" -> "Hyperlink". Choose "Place in this document"