skipping cells
 

i would like a certain cell not recognized even if i click on that cell.
i don't want anything in that cell, just to be blank. say i was on A1
and when i press enter i would like to skip to A3...


--
just1creation
------------------------------------------------------------------------
just1creation's Profile: http://www.excelforum.com/member.php...o&userid=35468
View this thread: http://www.excelforum.com/showthread...hreadid=556061

skipping cells
 

easy

insert a hyperlink in to the cell

you can format the cell in white text to hide the hyperlink if needed
and protect if you have to


--
baxybaxy
------------------------------------------------------------------------
baxybaxy's Profile: http://www.excelforum.com/member.php...o&userid=35824
View this thread: http://www.excelforum.com/showthread...hreadid=556061

skipping cells
 

You can give the range a name and ENTER your way through the cells in the order
you wish.

See Bob Phillips's site for methods of naming a range.

http://www.xldynamic.com/source/xld.xlFAQ0008.html

Don't be put off by the title "Tab to selected cells". There is a method of
using the ENTER key.


Gord Dibben MS Excel MVP

On Tue, 27 Jun 2006 10:03:56 -0500, just1creation
wrote:


i would like a certain cell not recognized even if i click on that cell.
i don't want anything in that cell, just to be blank. say i was on A1
and when i press enter i would like to skip to A3...

Gord Dibben MS Excel MVP